Andreas Munch, Skill AS on 25 Sep 2015 19:30:03
I'm trying to combine two simple oData-feed from two different CRM-organisations with the "Table.Combine". It works with datasets from a single source, it works from two sources in Power BI Desktop, but i fails on app.powerbi.com.
The error I get is "Information is needed in order to combine data". This is really essential for us if we can use Power BI.
Administrator on 27 Apr 2016 00:11:58
This has been fixed.
- Comments (47)
RE: Error: Information is needed in order to combine data
is it possible that this was previously fixed but is broken again I have got this error twice in the last couple of months and haven't been able to fix it even when doing everything suggested here several times
RE: Error: Information is needed in order to combine data
Ran into this. Can confirm that the privacy level solution worked for me as well.
""I solved it by indicating the same privacy level for all sources requiring to be combined.
In data sources configuration, all are indicated with Organisational privacy.
My guess would be that "Ignore Privacy settings" can't be taken into account right now in Power BI services.""
RE: Error: Information is needed in order to combine data
Not fixed. One more thing that works in desktop and then fails in service.
RE: Error: Information is needed in order to combine data
Definitely not fixed. I am getting this error when combining Data-flow with SharePoint Excel file.
RE: Error: Information is needed in order to combine data
Thanks everyone to bring this up.
What I done to solve this issue is set up privacy settings for all data source in same level for both desktop-side and service-portal-side.
If just change settings on PBI desktop, that doesn't really fix the issue.
RE: Error: Information is needed in order to combine data
Big thanks Anonymous - I can verify your solution resolves the issue. Thumbs up!!
"I solved it by indicating the same privacy level for all sources requiring to be combined.
In data sources configuration, all are indicated with Organisational privacy.
My guess would be that "Ignore Privacy settings" can't be taken into account right now in Power BI services."
RE: Error: Information is needed in order to combine data
I encountered this issue.
I solved it by indicating the same privacy level for all sources requiring to be combined.
In data sources configuration, all are indicated with Organisational privacy.
My guess would be that "Ignore Privacy settings" can't be taken into account right now in Power BI services.
RE: Error: Information is needed in order to combine data
Please fix this issue !
RE: Error: Information is needed in order to combine data
Facing the same issue, "Information is needed in order to combine data Table". This is impacting our critical reporting refreshes. Any updates?
RE: Error: Information is needed in order to combine data
This is not fixed, and I have the June version of Desktop installed.
Hide
On demand 13/06/2019 12:05:36 13/06/2019 12:05:41 Failed Unable to connect to the data source undefined.
Underlying error code: -2147467259 Table: MyTable.
Underlying error message: Information is needed in order to combine data
DM_ErrorDetailNameCode_UnderlyingHResult: -2147467259
Microsoft.Data.Mashup.MashupSecurityException.DataSources: [{"kind":"SQL","path":";"},{"kind":"SQL","path":";"}]
Microsoft.Data.Mashup.MashupSecurityException.Reason: PrivacySetting
Cluster URI: WABI-EUROPE-NORTH-B-redirect.analysis.windows.net
Activity ID: b1919951-8977-4855-9366-140a09b64963
Request ID: 0911c8ba-f6b1-880e-0fa7-a2b68c6e58c5
Time: 2019-06-13 11:05:41Z