Forum Discussion
EusebioJr
4 years agoNew Member
Step 'Type Changed' referencing other queries or steps
Hello everyone !I'm having problems updating the data. When I start the update process, the following message appears:
Query 'F-Supply' (step 'Type Changed') references other queries or steps, so they may not have direct access to the data source. Recompile this data combination.
And this happens with other queries. So, to solve the problem I need to click on edit the query, it updates through Power Query and then I can go back to BI Desktop and put it to update.
Does anyone know why this is happening?
Note: All my databases are in sharepoint in excel spreadsheet
2 Replies
- Arul
Super User
I suspect there could be the issue if you merged external data source to other query. Please refer the blog since it is very much alligned to your issue.
https://www.excelguru.ca/blog/2015/03/11/power-query-errors-please-rebuild-this-data-combination/
Thanks,
Arul