Forum Discussion
Enable load Confusion
Hi all,
So usually I have a staging area outside of Power BI where I create Dim and facts.
but for the current project I have had to do everything in Power Query Editor. So I have
1, Landing tables from the dataflow
2. Referenced Transformation tables
3. Referenced Dim and Fact tables
Publishing brought everything through into the model. It looked a real mess. And then I was told I could Disable Load of the staging tables and everything would still work. The dims and Facts would still be refreshed.
So I have done this. And then i thought, Could I also disable load of the Landing Tables? Would everything still refresh OK if just dim and Facts were set to enable load?
Hi DebbieE ,
Based on your description, you have questions about how Enable Load and Disable Load in Power Query Editor work and how the situation applies.
First, when you disable the loading of a table in Power Query Editor, it means that the table won't load into the Power BI model. However, if it is referenced by other tables, such as your dimension and fact tables, the transformation will still be applied and the referenced table will be refreshed.
Second, if you disable the loading of the landing table, the transformation will not be applied and the data will not be refreshed. This means that your reference transformation tables, dimensions, and fact tables will not get updated data.
Finally, if you disable loading for all tables except dimension and fact tables, your reports and dashboards should still work as long as the dimension and fact tables are set to Enable Load and the correct landing and transformation tables are referenced.
In summary, you should keep the "Enable Loading" option checked for both land and reference conversion tables. This will ensure that the data is imported and transformed correctly. Disable the loading of these tables only if you are confident that they are not needed for the final reports and dashboards.
You can refer to the following documents for more information
Develop solutions with dataflows - Power BI | Microsoft Learn
Managing query refresh - Power BI | Microsoft Learn
Solved: difference between "enable load" vs "enable load t... - Microsoft Fabric CommunityBest regards,
Albert HeIf this post helps, then please consider Accept it as the solution to help the other members find it more quickly
2 Replies
Hi DebbieE ,
Based on your description, you have questions about how Enable Load and Disable Load in Power Query Editor work and how the situation applies.
First, when you disable the loading of a table in Power Query Editor, it means that the table won't load into the Power BI model. However, if it is referenced by other tables, such as your dimension and fact tables, the transformation will still be applied and the referenced table will be refreshed.
Second, if you disable the loading of the landing table, the transformation will not be applied and the data will not be refreshed. This means that your reference transformation tables, dimensions, and fact tables will not get updated data.
Finally, if you disable loading for all tables except dimension and fact tables, your reports and dashboards should still work as long as the dimension and fact tables are set to Enable Load and the correct landing and transformation tables are referenced.
In summary, you should keep the "Enable Loading" option checked for both land and reference conversion tables. This will ensure that the data is imported and transformed correctly. Disable the loading of these tables only if you are confident that they are not needed for the final reports and dashboards.
You can refer to the following documents for more information
Develop solutions with dataflows - Power BI | Microsoft Learn
Managing query refresh - Power BI | Microsoft Learn
Solved: difference between "enable load" vs "enable load t... - Microsoft Fabric CommunityBest regards,
Albert HeIf this post helps, then please consider Accept it as the solution to help the other members find it more quickly
Great. sounds like i can remove landing and staging tables and just keep my dim and facts. Thats great. thank you
