Power BI

Completed

Error: Information is needed in order to combine data

Vote (39)

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)

Comments (50)

JD 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!

Ivan Bondarenko 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").

Power BI User 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.

Jiri Neoral on 05 Jul 2020 22:09:10

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

Same issue combining data from SQL Azure DB and function from Azure Data Marketplace.

Janet Humphreys on 05 Jul 2020 22:08:33

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

I have the same issue...privacy setting set to ignore but still get the error

Ivan Arribas on 05 Jul 2020 22:08:28

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

Same problem. Please Help!!!

Eric Vogelpohl on 05 Jul 2020 22:08:24

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

Same problem here.

Power BI User on 05 Jul 2020 22:08:04

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

I'm seeing the same problem and it still occurs if I set the privacy for the file to ignore.

Barbara Raney (Slalom Consulting) on 05 Jul 2020 22:06:53

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

The privacy setting which allows you to "Ignore" the privacy settings and combine data from two different data sources gets reset each time the file is opened by a different user or there is an update to Desktop. Once you set Privacy to "ignore" for a file, it should stay set.

Lloyd Jefferies on 05 Jul 2020 22:06:43

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

Same problem here but with 2 Queries from the same organization