Check your eligibility for this 50% exam voucher offer and join us for free live learning sessions to get prepared for Exam DP-700.
Get StartedDon't miss out! 2025 Microsoft Fabric Community Conference, March 31 - April 2, Las Vegas, Nevada. Use code MSCUST for a $150 discount. Prices go up February 11th. Register now.
Within paginated reports, I have a query where I am pulling data from sharepoint online and Azure SQL database. Within the power query editor, I can combine the data and get the data output just fine. When I try and render that report in power bi service it says I need to specify a privacy level for all connections. I have a privacy level defined for SQL but I can't find where that is supposed to be set to give one to the Sharepoint connection
Solved! Go to Solution.
Thanks for the suggestions, there appears to be a bug and/or missing feature in the power query editor in the paginated (RDL) report writer program as I do not have any abilites to edit the datasource settings from within the editor as you've shown in the screenshots. The solution was to go to the Manage Connections and Gateways page in power bi service and edit the connection from there to set the privacy level
Thanks for the suggestions, there appears to be a bug and/or missing feature in the power query editor in the paginated (RDL) report writer program as I do not have any abilites to edit the datasource settings from within the editor as you've shown in the screenshots. The solution was to go to the Manage Connections and Gateways page in power bi service and edit the connection from there to set the privacy level
@srduval wrote:
there appears to be a bug and/or missing feature in the power query editor in the paginated (RDL) report writer program as I do not have any abilites to edit the datasource settings from within the editor as you've shown in the screenshots.
This is not a bug or missing feature. Report Builder is using the connections defined on the service therefore you need to edit the privacy settings in the service. It does not have local connections like Power BI Desktop
Hi, @srduval
You can add a level of privacy to your SharePoint data sources in Power Query:
For a detailed tutorial explaining the privacy levels, you can refer to the following official documentation:
Understand Power BI Desktop privacy levels - Power BI | Microsoft Learn
In Power BI service, you can specify the privacy level when you add a SharePoint connection:
You'll need to set up a cloud connection for your Azure SQL database, sharepoint, and set the privacy level when you connect, and then configure those connections for your semantic model.
Best Regards
Jianpeng Li
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount! Prices go up Feb. 11th.
Check out the January 2025 Power BI update to learn about new features in Reporting, Modeling, and Data Connectivity.