Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
I am getting this error message when refreshing (manually or via schedule) on Power BI service. This happened initially on a complex data model but I narrowed it down to being and issue with combine queries.
I simulated another example with just 2 tables from 2 databases on the same SQL server. Both tables are appended. All works well on desktop but refresh fails on service.
The gateway is installed and has always worked (and still works on other reports that do not use merging/appending queries).
I have tried all combinations possible with the privacy settings with no success
From other recent posts I understand I am not the only one to have this issue.
For info, I do not think that it is the merging itself that causes the problem. I tried with 2 Excel tables on a SharePoint site and that worked just fine.
Christine
Solved! Go to Solution.
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 Yu
Hi @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
Thanks Qiuyun you saved my day!! 🙂
I was getting this error while trying to combine a Google Analytics (GA), BigQuery, SQL Server and Oracle datasource. Changing the datasources to "Organizational" solved the refresh problem in the PowerBi portal.
@Qiuyun
I LOVE YOU! This answer solved my BI-life! Thanks!
This solution worked for me as well.
The Logs have been sent to you via private message and the gateway updated to the November version. Data refresh still failed after the gateway update
REFRESH HISTORY information:
Type: On demand
Start: 29/11/2018 9:46:35 AM
End: 29/11/2018 9:46:40 AM
Status: Failed
Message: Cannot connect to the mashup data source. See error details for more information.
Underlying error code: -2147467259 Table: Append1.
Underlying error message: Information is needed in order to combine data
DM_ErrorDetailNameCode_UnderlyingHResult: -2147467259
Microsoft.Data.Mashup.MashupSecurityException.DataSources: [{"kind":"SQL","path":"MM-SQL02;<database1>"},{"kind":"SQL","path":"MM-SQL02;<database2>"}]
Microsoft.Data.Mashup.MashupSecurityException.Reason: PrivacySetting
Cluster URI: WABI-AUSTRALIA-SOUTHEAST-redirect.analysis.windows.net
Activity ID: 757d2275-8c38-4e46-9cdc-c2f52077ee00
Request ID: 0dde2f7b-d357-7f45-c38e-ff659f3cdb26
Time: 2018-11-28 20:46:40Z
Hi @Anonymous,
Please go to Refresh History, click Show, there should be detail error information. Please share them with us.
Also please share on-premises data gateway log files with us. You can upload it to your OneDrive and send the share link to me via private message.
Please update gateway to the latest information then refresh dataset again to see if the issue still here.
Best Regards,
Qiuyun Yu