Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Did you hear? There's a new SQL AI Developer certification (DP-800). Start preparing now and be one of the first to get certified. Register now

Error: Information is needed in order to combine data

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.
Status: Completed
Comments
jdunmall
Advocate I
I'm stuck on this too. Same error, same symptoms, same stuck!
jdunmall
Advocate I
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?
ian_watkins
New Member
Please sort this out. It makes Power Bi unusable in our organisation.
AndreasMunch
New Member
No, Fergus Allan. It's in the release notes but it's npt working. The error is fixed but an empty dataset is returned
a-fealla
Microsoft Employee
I believe this issue had been resolved end of November.
jdunmall
Advocate I
This is working now...
andreas_munch
New Member
Yes, as some have commented this is now working... Thanks for the fix MS....
amckillop1
New Member
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
john78
New Member
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"
brenotte
Regular Visitor
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