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.
Hi there,
I have a report that gets data from Salesforce and SQL server. I installed personal data gateway and set the scheduled refresh. When it refreshed, it threw following error:
Underlying error code: -2147467259
Underlying error message: Information is needed in order to combine data
DM_ErrorDetailNameCode_UnderlyingHResult: -2147467259
Microsoft.Data.Mashup.MashupSecurityException.DataSources: [{"kind":"SQL","path":"Servername\\PROD"},{"kind":"Salesforce","path":"https://******.my.salesforce.com/"}]
Microsoft.Data.Mashup.MashupSecurityException.Reason: PrivacySetting
Cluster URI: WABI-AUSTRALIA-SOUTHEAST-redirect.analysis.windows.net
Activity ID: eb9dbd75-a012-4043-aed1-05fc09133a3a
Request ID: 47460d46-9b24-4d58-b00d-1314bbb4b8ff
Time: 2021-12-08 04:09:34Z
Could anyone help me where I made the mistake?
Solved! Go to Solution.
Hi @Dunner2020 ,
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 the SQL data sources is Organizational as well. Then refresh the dataset again.
Best Regards
Community Support Team _ Polly
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Hi @Dunner2020 ,
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 the SQL data sources is Organizational as well. Then refresh the dataset again.
Best Regards
Community Support Team _ Polly
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Hi @Dunner2020
The error is due to the Privacy settings in your PBIX file.
If you want to get it working you would set the Privacy level to NONE for each of the data sources
Here are more details on the Power BI Privacy Levels: Chris Webb's BI Blog: Data Privacy Settings In Power BI/Power Query, Part 1: Performance Implication...
Hi @Dunner2020
Ahh ok thanks, I think you might need to install the Standard Gateway, this will allow you to configure the privacy settings in the Power BI Service for those gateways?
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 |
---|---|
58 | |
20 | |
19 | |
18 | |
9 |