Skip to main content

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

933dfac1 fda9-4b36-898d-c7271ad5a6c8 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

5c61b20b 0903-428a-8170-44634ebd7cd4 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

8f380927 1589-452e-8881-6253abe23166 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

8d0c15cf 90e0-4715-a695-31308be63a9d 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

aa6d20d3 fbf8-48c3-8f05-c51603eb1c78 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

f2ae5f0d 18d3-4bcf-9708-cf6c0f115c0c 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

8f380927 1589-452e-8881-6253abe23166 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?

Andreas Munch, Skill AS's profile image Profile Picture

8f380927 1589-452e-8881-6253abe23166 on 05 Jul 2020 22:10:03

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

I'm stuck on this too. Same error, same symptoms, same stuck!

Andreas Munch, Skill AS's profile image Profile Picture

23309802 5327-4608-9a85-757be45ca59b on 05 Jul 2020 22:09:54

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

Would be great to have instruction in M code that will force M Engine ignore privacy levels on query level. Currently it is really annoying and not transparent.... Surprising sometimes: when two queries from the same system cannot be merged (refreshed on Power BI) due to a reason that privacy levels are different (even when in Power BI Desktop option set to "Ignore").

Andreas Munch, Skill AS's profile image Profile Picture

ea2e3945 23db-4941-9835-1ae4af8becd4 on 05 Jul 2020 22:09:33

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

I am seeing the same problem. Privacy for the file is set to ignore and data source privacy is set to none for both sources I am merging.