Improve Efficiency with Static Data Tables in Power Query, Power Pivot and Power BI

0:22 Introduction
1:41 Static Data Tables in Power Query
3:21 Static Data Tables in Power Pivot
4:08 Static Data Tables in Power BI
5:50 {} Table Constructor - DAX in Power BI
7:58 DATATABLE Function - DAX in Power BI

[giulianopierucci]

Very interesting and useful! Thanks Phil and Mynda

[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.

[amitsharma-msxs]

Thanks for sharing .could you pl make a complete DAX course video for beginner to advance level ?

[RafaelOliveira-spzc]

Hello! Is there any way to create a static table from a dynamic table on Power Query or Power BI? I mean, I want the values, but I don't want to refresh static table when the dynamic table refreshs

[ExcellenceInExcel]

Hi thanks for this video, will help a lot

[AccountingandQuickbooks]

Very helpful as usual thanks for sharing

[nayanjyotimajumdar]

Have recently subscribed to your channel and I am really amazed by how much I can achieve with the excel skills that you have shared on your channel. Can you do anything Pareto Analysis? Being a Planner, I have to work with more than 1000 SKUs monthly. Pareto or any other tool could help me deliver better results.

[wayneedmondson]

Thanks Mynda and Phil. Always interesting topics at your channel. Thanks for sharing :)) Thumbs up!!

[paulwarren]

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?

[darrylmorgan]

Hi Mynda!Really Enjoyed This Helpful Tutorial From Phil...Thank You Both :)

[ricos]

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!).

[AjayKumar-idmb]

Hey, which ms office you are using I am not getting the option of getting data from the folder.

[IvanCortinas_ES]

Thank you for commenting on these interesting topics at the present time in which the tools are: + Power Query, + Power BI

[dinonppa]

Thank you! I love the videos! Keep them coming.

[DiamondRock]

Waw, this is a new level in using power BI thanks Phil an Mynda

[edjoseph]

Thanks Phil and Mynda for this great video.

[JasonNew]

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.