topic Re: Paginated Reports Power Query Builder in Report Server

Paginated Reports Power Query Builder

Anonymous — Mon, 01 Jul 2024 19:21:51 GMT

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

Re: Paginated Reports Power Query Builder

Anonymous — Tue, 02 Jul 2024 02:22:03 GMT

Hi, Anonymous

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.

Re: Paginated Reports Power Query Builder

Anonymous — Tue, 02 Jul 2024 13:47:19 GMT

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

Re: Paginated Reports Power Query Builder

d_gosbell — Wed, 03 Jul 2024 01:30:56 GMT

Anonymous 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