cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
adriansuteu Advocate I
Advocate I

Information is needed in order to combine data error even with same Privacy Levels in Desktop/Server

Hello.

 

I get the following error when trying to refresh a report on PBI Server:

 

There was an error when processing the data in the dataset.

Please try again later or contact support. If you contact support, please provide these details.

  • Data source error{"error":{"code":"ModelRefresh_ShortMessage_ProcessingError","pbi.error":{"code":"ModelRefresh_ShortMessage_ProcessingError","parameters":{},"details":[{"code":"Message","detail":{"type":1,"value":"Information is needed in order to combine data"}}],"exceptionCulprit":1}}} Table: PBI_WagesCat.
  • Cluster URIWABI-US-NORTH-CENTRAL-redirect.analysis.windows.net

 

Refresh works fine on Desktop app. There are no error messages. Also, I made sure that both Desktop and Server have the data sources set to the same Privacy Level: Organizational. I triple checked that. My data source are some Excel files stored on OneDrive for Business so in PBI they qualify under Web source type.

I mention that I have just updated my Power BI Desktop version with this new one with the fancy ribbon before downloading (a long time not used report). I edited that report and then overwrite the old one.

I have also tried to delete the report from Server and Publish it then as a new report and I get the same error.

 

Can you please help me?

 

Thank you,

Adrian

 

16 REPLIES 16
Community Support
Community Support

Re: Information is needed in order to combine data error even with same Privacy Levels in Desktop/Se

hi  @adriansuteu 

Even though all the settings were correct in the destkop.  you also need reset the permsions on the power bi cloud (service) side by clicking edit credentials and setting he privacy settings and entering the password. 

 

Regards,

Lin

Community Support Team _ Lin
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
adriansuteu Advocate I
Advocate I

Re: Information is needed in order to combine data error even with same Privacy Levels in Desktop/Se

Hello.

 

Thank you for your answer. Privacy was set on Organizational in Power BI Server from the beggining but I did the following thing:

I went to PBI Server and I clicked on "Edit Credentials" for every data source in the list, made sure it is set on Organizational and then click on Sign In and login again with my credentials.

I still get the following error:

 

Something went wrong
There was an error when processing the data in the dataset.
Please try again later or contact support. If you contact support, please provide these details.
Data source error: {"error":{"code":"ModelRefresh_ShortMessage_ProcessingError","pbi.error":{"code":"ModelRefresh_ShortMessage_ProcessingError","parameters":{},"details":[{"code":"Message","detail":{"type":1,"value":"Information is needed in order to combine data"}}],"exceptionCulprit":1}}} Table: PBI_Wages.
Cluster URI: WABI-US-NORTH-CENTRAL-redirect.analysis.windows.net
Activity ID: 2b5cd332-4393-4cee-96fb-e09826873874
Request ID: 3ae4c162-5dbf-afaf-e812-70eecd86e9bd
Time: 2020-03-13 08:14:51Z

Jmenas Advocate III
Advocate III

Re: Information is needed in order to combine data error even with same Privacy Levels in Desktop/Se

Hi @adriansuteu,
I am having the same error. For the report refresh was working fine until this Friday. After I added a new data source, I keep getting this message. @v-lili6-msft do you know if there is anything in the March update that might have affected the data privacy settings with the reports? 

Best,

Jorge

venal Memorable Member
Memorable Member

Re: Information is needed in order to combine data error even with same Privacy Levels in Desktop/Se

@adriansuteu , @Jmenas 

Can you please follow the below steps and try to re-pro the issue.

1. Open the PBIX file in Power BI Desktop

2. File >> Options & Settings >> Clear Cache (Data , Q & A Cache Management).

3. Home >> Edit Queries >> Edit Queries >> Refresh Preview >> Refresh All >> Close & Apply.

4. Home >> Refresh >> Check the data in all visuals across the page levels.

5. File >> Save the PBIX File >> Publish.

Note:- Always use latest version of the on-premises data gateway. Use same privacy level in Desktop and Service.

 

If the issue is persists, please share the error message to investigate.

 

If you have any queries, please let us know.

 

If this post helps, then please consider Accept it as the solution to help the other members find it more
If this post was helpful may I ask you to mark it as solution and click on thumb symbol?

 

BR,

Venal.

adriansuteu Advocate I
Advocate I

Re: Information is needed in order to combine data error even with same Privacy Levels in Desktop/Se

Hello @venal 

 

I have followed your steps. Refresh worked fine, every visual shows the complete data.

 

I still get the same error.

 

I have used the same report, with the same table - PBI_Wages, from the same source type: Web (OneDrive Excel file) and query steps before and it worked fine. But this happend a while ago. PBI Service Refresh broke because other tables' structure changed. The report was not used a while (around 6 months). I downloaded the report, I changed the Data Source location (not type, just location from one sharepoint file to another - basically the same file copied in another place!) and made the required changes to make the other queries work in PBI Desktop - last version - the one with the fancy new ribbon.

 

This is the error:

There was an error when processing the data in the dataset.

Please try again later or contact support. If you contact support, please provide these details.

  • Data source error{"error":{"code":"ModelRefresh_ShortMessage_ProcessingError","pbi.error":{"code":"ModelRefresh_ShortMessage_ProcessingError","parameters":{},"details":[{"code":"Message","detail":{"type":1,"value":"Information is needed in order to combine data"}}],"exceptionCulprit":1}}} Table: PBI_Wages.
  • Cluster URIWABI-US-NORTH-CENTRAL-redirect.analysis.windows.net
  • Activity IDff02f260-104c-4e4b-b78a-54bf9f94f4d1
  • Request IDca2cf925-4e5a-eb61-02a6-23952f5c3834
  • Time2020-03-16 20:04:08Z
Highlighted
sxt173 Advocate II
Advocate II

Re: Information is needed in order to combine data error even with same Privacy Levels in Desktop/Se

I was able to resolve this error using the following steps:

  • Open .pbix report in Power BI Desktop
  • File - Options & Settings - Data Source Settings --> Clear All Permissions
  • [not sure if this does anything] File - Options and Settings - Option --> Clear Cache in "Date Cache Management" and "Q&A Cache Options"
  • Home - Refresh --> keep track of how you log into each data source. In my case it was 3 sources, all Organizational privacy levels
  • Save and Publish the report
  • Go to data source in the PBI service, and re-login to each of the data sources under Data Source Credentials --> make sure you are using the same privacy level as desktop app, in my case it was all Organizational

Btw, this started with the latest version of Power BI Desktop so there is definitely a bug that resets privacy levels.

adriansuteu Advocate I
Advocate I

Re: Information is needed in order to combine data error even with same Privacy Levels in Desktop/Se

Hi @sxt173

 

I followed your steps but I get the same error in PBI Service after republishing the report.


Thank you for the suggestion.

 

pongthep101
New Member

Re: Information is needed in order to combine data error even with same Privacy Levels in Desktop/Se

Thanks!! 👍 It's working for me after set the same privacy level as the desktop app.

Jmenas Advocate III
Advocate III

Re: Information is needed in order to combine data error even with same Privacy Levels in Desktop/Se

Hi all,
@adriansuteu  I could fix it. It is a reference problem that you might have. If you are appending or combining two or more tables you should do it in a new query instead of the main query. That solved the issue for me.

 

Best,

Jorge

Helpful resources

Announcements
Announcing the New Spanish Forum

Announcing the New Spanish Forum

Do you need help in Spanish? Check out our new Spanish community section.

MBAS Gallery 2020

MBAS Gallery 2020

Watch Microsoft Business Applications Summit sessions on-demand.

‘Better Together’ Integration Forum Launch

‘Better Together’ Integration Forum Launch

We've launched a how-to forum where you can learn about how Power BI integrates with other Power Platform products.