Skip to main content
Microsoft Idea

Power BI

Completed

Error: Information is needed in order to combine data

Vote (39) Share
Andreas Munch, Skill AS's profile image

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 (50)
Andreas Munch, Skill AS's profile image Profile Picture

Bertrand RENOTTE on 05 Jul 2020 23:18:44

RE: Error: Information is needed in order to combine data

I don't see any update on this issue but it's still on as of today.
Any chance of a fix ?

Andreas Munch, Skill AS's profile image Profile Picture

Bertrand RENOTTE on 05 Jul 2020 22:59:21

RE: Error: Information is needed in order to combine data

Still have the same issue too.

On-premises gateway is up-to-date.

File > Options and Settings > Options:
GLOBAL > Privacy: have set the Privacy Levels to "Always ignore Privacy Level Settings"
CURRENT FILE > Privacy: have set the Privacy Levels to "Ignore the Privacy Levels and potentially improve performance"
File > Options and Settings > Data source settings:
For all my CSV data sources in my pbix file, have set the Privacy Level dropdown list in the Edit Permission dialog to "None"

Don't know if worth to mention but my files are on a network share and the source location is as \\myserver\myshare\xxx

Andreas Munch, Skill AS's profile image Profile Picture

John on 05 Jul 2020 22:56:41

RE: Error: Information is needed in order to combine data

Still have the same issue here.

On-premises gateway is up-to-date.

File > Options and Settings > Options:
GLOBAL > Privacy: have set the Privacy Levels to "Always ignore Privacy Level Settings"
CURRENT FILE > Privacy: have set the Privacy Levels to "Ignore the Privacy Levels and potentially improve performance"
File > Options and Settings > Data source settings:
For all the four ODBC data sources in my pbix file, have set the Privacy Level dropdown list in the Edit Permission dialog to "None"

Andreas Munch, Skill AS's profile image Profile Picture

Andreas Munch, Skill AS on 05 Jul 2020 22:17:31

RE: Error: Information is needed in order to combine data

Yes, as some have commented this is now working... Thanks for the fix MS....

Andreas Munch, Skill AS's profile image Profile Picture

Aubrey Power BI User on 05 Jul 2020 22:17:30

RE: Error: Information is needed in order to combine data

I am merging the data from a 2 excel spreadsheets and data from SQL Server a manual publish from power bi Desktop will refresh the data but the Scheduled refresh and manual resfresh from the gateway fails with an unknown error

Andreas Munch, Skill AS's profile image Profile Picture

JD on 05 Jul 2020 22:17:12

RE: Error: Information is needed in order to combine data

This is working now...

Andreas Munch, Skill AS's profile image Profile Picture

Munch.biz Norway on 05 Jul 2020 22:13:58

RE: Error: Information is needed in order to combine data

No, Fergus Allan. It's in the release notes but it's npt working. The error is fixed but an empty dataset is returned

Andreas Munch, Skill AS's profile image Profile Picture

Fergus Allan on 05 Jul 2020 22:13:57

RE: Error: Information is needed in order to combine data

I believe this issue had been resolved end of November.

Andreas Munch, Skill AS's profile image Profile Picture

Ian Watkins on 05 Jul 2020 22:10:26

RE: Error: Information is needed in order to combine data

Please sort this out. It makes Power Bi unusable in our organisation.

Andreas Munch, Skill AS's profile image Profile Picture

JD on 05 Jul 2020 22:10:13

RE: Error: Information is needed in order to combine data

I just opened a ticket and hear back: "It requires a change to the product which can take a few weeks as we have to test any changes in the route to live environment"... so early December?