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.
Maybe I'm not thinking clearly here. I have historical data loaded into an Excel file that matches the same format I'm retrieving data from an API.
I want to append the historical excel information to the data I'm pulling from the API. I get the unable to combine data - appended query references other queries or steps so it may not directly access a data source. Please rebuiuld this data combination error.
How do I account for this? Or is this a privacy setting issue?
Thanks
Solved! Go to Solution.
@PowerUser123 after you have connected to both api and your csv/excel format, in the power query window there is an option to append data or merge data as new query
in the power query window, you select both the table/query and then choose option to merge queries as new. this should work for you.
Proud to be a Super User!
@PowerUser123 after you have connected to both api and your csv/excel format, in the power query window there is an option to append data or merge data as new query
in the power query window, you select both the table/query and then choose option to merge queries as new. this should work for you.
Proud to be a Super User!
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 |
---|---|
106 | |
104 | |
79 | |
68 | |
61 |
User | Count |
---|---|
143 | |
104 | |
103 | |
82 | |
70 |