Forum Discussion
Error when loading SharePoint List merged with OnPremises data
When you merge SQL + SharePoint in the same query, the Service evaluates this as cross-source data combination, and the mashup engine blocks it unless the privacy rules line up perfectly.
Option 1: Keep SharePoint loaded, hide it
What you already did, but clean it up:
Load the SharePoint list
Create relationships
Hide the SharePoint table from report view
Optionally move it to a “_Helper” display folder
Option 2: Use a Dataflow (clean architecture)
Ingest SharePoint + SQL in a Dataflow
Do the merge there
Consume the single output table in Power BI
This avoids Service mashup issues entirely.
Thank you for the explanation, v-sshirivolu
This means that the current implementation, which loads both tables in Power BI with relationships between the tables, is correct.
Thank you again.
Regards
Salvatore
Hi SalvaC ,
Yes, that’s correct.
Loading the SQL and SharePoint data as separate tables and using relationships between them is the supported and recommended approach in the Power BI Service.
This avoids cross source mashup issues that occur when attempting to merge the sources in a single query.