Forum Discussion
Data Privacy Level Error
Hi Krit7900,
Thank you for reaching out to the Microsoft fabric community forum.
This error is coming because Power BI is treating your sources as different connections. Even though your files are from SharePoint and OneDrive, internally Power BI sees SharePoint Folder, Web, and OneDrive Excel as separate connectors.
When you merge tables that come from different connectors, Power BI checks the privacy levels before allowing the data to combine. If it feels the sources should not be combined, it blocks the refresh and shows error.
Since you already aligned the privacy levels and tried the ignore option, I would suggest keeping the connection type same for all files if possible. For example, if all files are stored in SharePoint OneDrive, try using only the SharePoint Folder connector instead of mixing Web and Excel connectors. Also check in Data Source Settings whether Power BI is showing multiple separate entries for what looks like the same location.
Hope the above provided information help you resolve the issue, if you have any further concerns or queries, please feel free to reach out to us.Regards,
Community Support Team.
Hi Krit7900,
Thank you for reaching out to the Microsoft fabric community forum.
This error is coming because Power BI is treating your sources as different connections. Even though your files are from SharePoint and OneDrive, internally Power BI sees SharePoint Folder, Web, and OneDrive Excel as separate connectors.
When you merge tables that come from different connectors, Power BI checks the privacy levels before allowing the data to combine. If it feels the sources should not be combined, it blocks the refresh and shows error.
Since you already aligned the privacy levels and tried the ignore option, I would suggest keeping the connection type same for all files if possible. For example, if all files are stored in SharePoint OneDrive, try using only the SharePoint Folder connector instead of mixing Web and Excel connectors. Also check in Data Source Settings whether Power BI is showing multiple separate entries for what looks like the same location.
Hope the above provided information help you resolve the issue, if you have any further concerns or queries, please feel free to reach out to us.
Regards,
Community Support Team.
- Thank you for your suggestion. I was able to resolve the issue by updating the source to match the SharePoint folder. If you have any additional recommendations, please let me know.
