Forum Discussion
Information is needed in order to combine data
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
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
29 Replies
v-qiuyu-msftCommunity Support
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 YuI 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!
chrossAdvocate III
This solution worked for me as well.
If anyone is still having this same error, then I have another thing for you to check.
I was having the same problem as everyone else, I had the privacy setting to Organizational on all queries, but still got the error.
It turned out to be that I had a query with Encrypt connections selected (unintentionally). Deselected this and re-published to PowerBI service and it worked.
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 CommunityHi 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.
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
- v-qiuyu-msft
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 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
- v-qiuyu-msft
Hi Anonymous,
Good news. :smileyhappy:As the issue is resolved, I will close this thread.
Best Regards,
Qiuyun Yu
michaelshparberAdvocate V
I have the same problem
I combine 3 queries from APIs and get the same error
Each query is running fine separately
I have Organizational Privacy level
and I have Ignore Security option checked
I don't have a Gateway since it's APIs from the cloud
Please help!
Thanks
Michael
Message: Information is needed in order to combine data Table: ACCOUNTS_UNION. Cluster URI: WABI-WEST-EUROPE-redirect.analysis.windows.net Activity ID: 47507ca3-341a-4619-96ce-23236dffc7a4 Request ID: af71938c-b45a-9845-5792-90cc300416b0 Time: 2019-02-15 18:03:42Z - michaelshparber
I have spent 4 hours on this and I have narrowed the problem to one query
When I use it in Append - it causes the error
But the error is only in the service!!!!
Desktop is okThere are no errors in the query itself and it loads OK by itself
DataSource is almost the same as the other two queries with just a slight difference in url
but the same Organizational Privacy and the same Basic authentication
Please help! v-qiuyu-msft
Thanks
Michael
- Doodle
Advocate II
This is not resolved. Still having this issue. We are using premium capacity and still encounter this issue.
Coloca como public que vai (Y)
- andyclap
Advocate IV
A lot is explained by this article https://www.alphabold.com/data-privacy-settings-in-power-bi/
Annoyingly the settings are independent betwen PowerBI desktop, and the PowerBI service, so you have to make sure to set it in both.
I think the documentation around this in Microsoft could do with some improvement - it certainly tripped me up.
Yes, need to update Privacy Level in both Power BI desktop file and in Power BI Service.
There is one data source in Power BI Service which privacy level was "None", as soon as I switch to "Organizational", the refresh works as intented. Thanks for the help.
