Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
10 years ago

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 ...
Need Help
Greg_Deckler's avatar
Greg_Deckler
Icon for Community Champion rankCommunity Champion
10 years ago

What happens when you try to refresh manually?

edgedj's avatar
edgedj
New Member
10 years ago

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's avatar
    Evogelpohl
    Icon for Helper V rankHelper V
    10 years ago

    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.

    Hide details
    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