cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
dalenewnham Frequent Visitor
Frequent Visitor

Error: Information is needed in order to combine data

Power BI refreshes fail with the error "Information is needed in order to combine data". This seems to mostly happen when I modify an existing query. Setting the file privacy to ignore does not have any effect. I'm merging data from google analytics and a personal office 365 drive. There is at least one other post and an enhancement request on this issue but any guidance is greatly appreciated!

10 REPLIES 10
Super User
Super User

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

What happens when you try to refresh manually?


Did I answer your question? Mark my post as a solution!

Proud to be a Datanaut!


edgedj Occasional Visitor
Occasional Visitor

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

I'm also getting this error. I have been working on a SQL Azure dataset and it's been refreshing fine both manually and scheduled for a couple of weeks now. Yesterday I added a SharePoint list and the manual refresh is working but the scheduled refresh fails with

 

Data Source Error: Information is needed in order to combine data

Cluster URI: WABI-NORTH-EUROPE-redirect.analysis.windows.net

 

The credentials for the refresh are set correctly for both SharePoint and SQL Azure

 

Cheers

Dave

Evogelpohl Member
Member

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

Same here.  Just published from latest version of PBI Designer a solution that pulls from SQL on-prem and REST/Cloud via the latest personal gateway.  Get this on Powerbi.com when refreshing:

 

Last refresh failed: Sun Oct 25 2015 19:23:57 GMT-0500 (Central Daylight Time)
An error occurred while processing the data in the dataset.

Data Source Error:Information is needed in order to combine data
Cluster URI:WABI-US-NORTH-CENTRAL-redirect.analysis.windows.net
Activity Id:09b7dde0-d091-47a6-acc5-32d863219dad
Request Id:efd94e90-6952-4cce-992a-a50d4f992c1c
Time:2015-10-26 00:23:57Z
Highlighted
jan Regular Visitor
Regular Visitor

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

I have the same error...combining two excel files on sharepoint and in a separate file, combining CRM and excel. Both refresh manually correctly. Privacy settings set to none.  Help needed!

JanVW Frequent Visitor
Frequent Visitor

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

Getting the same error here when trying to refresh CRM online odata feeds+azure sql db. Also, I need to fill in credentials for each odata feed while they all are for the same instance...

jirineoral Regular Visitor
Regular Visitor

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

Have the same issue combining data from SQL Azure DB and data from AzureMarketplace? Was anyone able to resolve it yet?

Thanks

 

Jiri

dalenewnham Frequent Visitor
Frequent Visitor

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

I see the same problem combining data from Google Analytics and an Azure database. File privacy is set to ignore and datasource privacy is set to none. I also tried with datasource privacy set to public for both sources. A solution to this is critical for our project.

 

Dale

Leandro Regular Visitor
Regular Visitor

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

Did someone find a fix for that?

 

I get the same error trying to refresh a data model with SQL and OneDrive connections.

AndreasMunch Frequent Visitor
Frequent Visitor

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