Forum Discussion
Helper IUnable to combine data-Source references other queries or steps Error
HI Fraz707,
Have you tried to merge these query steps into one query table? (e.g. move connect to second database steps to the first query table) It may fix the 'privacy level' issue between invoking data across different queries tables.
In addition, can you please share more informants to help us to clarify this issue? (e.g. refresh history, gateway log, request-id...)
Troubleshoot gateways - Power BI#refresh-history
Regards,
XIaoxin Sheng
Helper IHey Anonymous please take a look I've updated the question.
Thanks.
HI Fraz707,
Maybe you can try to navigate to power bi service dataset and gateway data source settings to modify your data source and data credentials privacy level to 'organization' and try again.
Privacy Levels for Cloud Data Sources
If you are work with the personal gateway, please refer to the following link to change the settings:
Use personal gateways in Power BI#use-fast-combine-with-the-personal-gateway
BTW, what version of the report you used on power bi service hide? if you mean the raw version, I'd like to suggest you publish the report that modified 'privacy settings' to replace the old one.
Regards,Xiaoxin Sheng
- Fraz707
HI, Thanks for your respose Anonymous
Tried the 'Organization' level setting still not working in my case. Since its an organisational data therefore can't use the Personal Gateway for it. Tried replacing the Privacy setting and publishing it again but still its failing to refresh with the same error.
Any other suggestion particularly on power bi web , like the settings we have on desktop to ignore the privacy level?
Thanks.