Forum Discussion
Information is needed in order to combine data
Hi Anonymous,
Please download the report and open it in Power BI desktop, go to Query Editor, refresh data to see if any message pops out. Also please go to the Data Source Settings, click on Edit Permission for these two data sources points to two databases, ensure both privacy level is Organizational.
Then republish the report to Power BI service, go to Manage Gateways, ensure Privacy Level for these two SQL data sources is Organizational as well. Then refresh the dataset again.
Best Regards,
Qiuyun YuHi v-qiuyu-msft,
Thank you so much, you solved my problem. The issue was at the Manage Gateways, the privacy level was "Private". I couldn't modify the existing datasource but could delete it and re-create it with the correct settings.
Your help is really appreciated.
Kind Regards,
Christine
Mine is also the same case. It just said 'More Information Needed'.
My connections are:
1. AsAzure
2. SharePoint
3. PowerBI Dataflow
All of the privacy levels are set to - Organizational.
Tried different workspaces/ different combinations.
On PowerBI Desktop it works fine but fails again on Service. On Service - all the credentials are set-up, no Gateway used, Privacy level settings are all 'Organizational'. It still fails...
This issue is quite random. I faced the same for some of my reports earlier (2 weeks ago).
Please help and let us know the rrot-cause as well as this is totally a grey area 🙂 .
Re: Has anything changed in Power BI Service? All ... - Microsoft Power BI Community
Hi Rushkie, I ran into the same problem. For me the problem started two days ago. For some reason the datasets will still refresh in a certain workspace. This can be due to the fact that this is a premium capacity workspace, or simply that the dataset and dataflow are in the same workspace. Still trying to figure out what causes it exactly.