Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
2 years ago
Solved

Paginated Reports Power Query Builder

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...
Data Protection
Need Help
  • Anonymous's avatar
    Anonymous
    2 years ago

    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

Anonymous's avatar
Anonymous
Not applicable
2 years ago

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.