Improve Efficiency with Static Data Tables in Power Query, Power Pivot and Power BI - My Online Training Hub
video description
Date: 2022-04-08
Related videos
Comments and reviews: 5
Rico
Excellent. I'd be interested to know which is fastest to refresh. I almost always use #table in power query. I almost never solely use data imported directly to power pivot, so it's always best to have all your queries accessible in one location for others to work with (in my opinion!).
reply
Excellent. I'd be interested to know which is fastest to refresh. I almost always use #table in power query. I almost never solely use data imported directly to power pivot, so it's always best to have all your queries accessible in one location for others to work with (in my opinion!).
reply
brianxyz
When you use -Enter Data- to create a new table in Power BI you can edit the data without starting over. Click on the gear icon beside Source and that will take you back to the -Enter Data- interface with your data intact. From there you can add, delete, and edit your data.
reply
When you use -Enter Data- to create a new table in Power BI you can edit the data without starting over. Click on the gear icon beside Source and that will take you back to the -Enter Data- interface with your data intact. From there you can add, delete, and edit your data.
reply
Jason
Would you recommend this method for large datasets that never change? I have about 20 large files (probably a few million rows total) that no longer need to be updated in my PBI model. Thanks for the video! Always looking for ways to optimize.
reply
Would you recommend this method for large datasets that never change? I have about 20 large files (probably a few million rows total) that no longer need to be updated in my PBI model. Thanks for the video! Always looking for ways to optimize.
reply
Paul
Is there an easier way to take an existing excel table and copy it as a static table in Power Query? Essentially, pulling the data from a table, but never refreshing it?
reply
Is there an easier way to take an existing excel table and copy it as a static table in Power Query? Essentially, pulling the data from a table, but never refreshing it?
reply
Iv-n
Thank you for commenting on these interesting topics at the present time in which the tools are: + Power Query, + Power BI
reply
Thank you for commenting on these interesting topics at the present time in which the tools are: + Power Query, + Power BI
reply
Add a review, comment
Other channel videos
9:15
12:16
