Power Query Datasource Privacy Settings

[srduval]

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

[v-jtian-msft · Accepted solution]

Hi,@srduval . I am glad to help you.

According to your description, you want to set the data source privacy level on the service.
You can configure the privacy level of the data source on the power BI service (set to None, Public or Private) when setting up the gateway, or you can set the privacy level of the data source on the power desktop via the "Options and Settings" button.
On power desktop, you can configure the privacy level of the data source through the "Options and Settings" button.

Here is the documentation, hopefully it will help you.
url:Understand Power BI Desktop privacy levels - Power BI | Microsoft Learn

Note that Ignore the Privacy Levels and potentially improve performance is not supported on service.

Here is my test:
In Power BI Desktop

in Power BI Service

After testing, the data source privacy level set in Desktop will not be passed to the service, so after you upload to the service, no matter whether you set the privacy level in ddektop or not, you have to reset it on the service, and set the privacy level of the data source in the gateway settings.
I also tested when a report contains multiple data sources (in mixed mode)
You need to configure multiple gateways for the report and set the data source privacy level separately.

Therefore, you need to configure multiple gateways for the report while setting each privacy level on the service.
The gateway connection settings:

I hope my suggestions give you good ideas, if you have any more questions, please clarify in a follow-up reply.

Best Regards,

Carson Jian,

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.