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

Level up your Power BI skills this month - build one visual each week and tell better stories with data! Get started

Power Query in Semantic Model Web Editor: privacy settings don't allow the combining of data

Loading data...

(!) Processing queries and validating semantic model.

An error has occured.

Show details...

Underlying Error Privacy settings don't allow the combining of data from multiple sources in the same query. \n\r To refresh this dataflow you can either edit the queries or you can allow combining data from multiple sources in the Edit queries Options settings.

Activity ID....

Time....

Continue editing | Cancel


I got the error above after adding a table to an import mode semantic model, using Transform data in the Semantic Model Web Editor. I clicked Save, which closes the Power Query online window and starts validation of the queries. That is when the error prompt appears.

Other tables were added using Power BI desktop, before I published the semantic model to the Service. I have refreshed the semantic model successfully multiple times. But got this error when trying to add another table using the online power query experience.

 

I don't find an option to allow combining data from multiple sources in the semantic model's online Web Editor. Also the privacy settings auf each data sources are aligned to "Orgainization".

 

How to fix this?

Thanks in advance!

Status: New