Power Query Datasource Privacy Settings

Hi,Anonymous . 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.