Power BI is turning 10! Tune in for a special live episode on July 24 with behind-the-scenes stories, product evolution highlights, and a sneak peek at what’s in store for the future.
Save the dateEnhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.
After creating a merge query, I want to disable the load of the source queries, but the Enable Load option is missing. I've made sure Office is up to date and I've done a quick repair.
Solved! Go to Solution.
@bgilbert did my answer above help? If so, can you mark it as the solution. If not, can you post back with additional questions you have?
DAX is for Analysis. Power Query is for Data Modeling
Proud to be a Super User!
MCSA: BI ReportingHi @bgilbert , In Excel, you do not Enable Load from Power Query. Close Power Query, then in the main Excel window, go to the Data ribbon, and make sure Queries & Connections is selected so the below panel shows up.
Right-click on the query you want to load and select "Load to..."
The reason for this is in Power BI, there is only one way to load data - to the data model. In Excel though, you can load to:
Additionally there are other options in the Properties button that are specific to Excel. None of this is relevant to Power BI, so you can load from Power Query straight into the Power BI Data Model.
DAX is for Analysis. Power Query is for Data Modeling
Proud to be a Super User!
MCSA: BI Reporting@bgilbert did my answer above help? If so, can you mark it as the solution. If not, can you post back with additional questions you have?
DAX is for Analysis. Power Query is for Data Modeling
Proud to be a Super User!
MCSA: BI ReportingThank you. That did help me.
Excellent @bgilbert - glad to help out.
DAX is for Analysis. Power Query is for Data Modeling
Proud to be a Super User!
MCSA: BI ReportingHi @bgilbert ,
Which data source you are using or entering data directly? I have tested in my environment and the Enable load option still works fine after merging tables.
You can try to use the latest version of power bi desktop to check whether it still has the same issue.
Best Regards,
Yingjie Li
If this post helps then please consider Accept it as the solution to help the other members find it more quickly.
I'm doing this in Excel Power Query. My data source is Oracle.
Check out the July 2025 Power BI update to learn about new features.
This is your chance to engage directly with the engineering team behind Fabric and Power BI. Share your experiences and shape the future.
User | Count |
---|---|
10 | |
7 | |
7 | |
6 | |
6 |