Forum Discussion
Source references other queries or steps, so it may not directly access a data source. Server
Hi earlr1765
Because you used two source sql and excel in the same query so you will have the problem that it references other queries or steps, you can try the following solution.
1.Ignore the privacy levels, you can set it in power bi desktop, click 'Options and settings' to set it, you can refer to the following picture.
And you can refer to the following link.
Solved: Formula.Firewall: Query references other queries, ... - Microsoft Fabric Community
Solved: Query references other queries or steps, so it may... - Microsoft Fabric Community
2.You can consider to use the dynamic paramater in power query so that you don't need to import the external excel file, but it need that you use the direct query mode to connect to the SQL , you can refer to the following link about the dynamic paramater.
Best Regards!
Yolo Zhu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
No sadly this will not work. The issue doesn't happen on PowerBI Desktop because I have ignored privacy settings, but it does appear in PowerBI Server despite also making both datasets being set to Organization or Public.
A dynamic query will not work since I want to aggregate all data across all the different ClientParameters, not just one selection.
For context the queries only work when I'm specifying a where clause, since the data is too huge to merge together as one extract. So 20 sql queries are faster than 1 query with all 20 data elements.