PowerBI Service: Information is needed in order to combine data

[Anonymous]

The automatic refresh in PowerBI does not work for me. The local refresh in PowerBI Desktop works.

Verarbeitungsfehler: Information is needed in order to combine data
Cluster-URI: WABI-WEST-EUROPE-redirect.analysis.windows.net
Aktivitäts-ID: 7e14e8d5-472f-4d4b-900c-120ecea18464
Anforderungs-ID: 3b9f7f57-b23b-40ec-9356-63ea0ab3c26b
Zeit: 2022-01-21 05:26:46Z

I´ve already set all security levels to organizational, reloaded the data and uploaded a new report, also in a new workspace. Nothing works. Please help me.

[Anonymous · Accepted solution]

Hey Charlotte, Hey Ibendlin! 

Thanks for your replies. Unfortunately, I made the mistake of setting the privacy levels in the PowerBi file in PowerBI Desktop and not in the online service. After I switched the privacy levels to organizational for the automatic update in PowerBI Service, it worked.

Best regards, Alex

[v-zhangti]

Hi, @Anonymous 

When I made an internal inquiry, ICM 252542527 showed that the reason was similar:
"Issue is caused due to a regression when a feature switch'EimInformationProtectionExcelDataSourceInheritance,EimInformationProtectionExcelDataSourceInheritanceForPremium' was enabled."

Now the function has been disabled and can be used normally.

This is the relevant document, hope to help you: 

https://community.powerbi.com/t5/Service/Information-is-needed-in-order-to-combine-data/m-p/574058 

https://www.meanttobi.com/power-bi-refresh-error-unable-to-combine-data-workaround/ 

Best Regards,

Community Support Team _Charlotte

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[lbendlin]

which data sources are you combining in your Power Query?  Is that something you can do in the data model instead?