Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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.
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
102 | |
53 | |
21 | |
12 | |
12 |