topic Re: Can report viewers access Power Query parameters? in Developer

Can report viewers access Power Query parameters?

Anonymous — Mon, 27 Mar 2023 11:04:55 GMT

Hi all,

I have stored client credentials (client_id & client_secret) as Power Query parameters. ()

Client credentials are currently stored as power query parameters. As I know, disabling the “Enable load” option will stop loading parameters into the report. So, these parameters are not visible to the report viewers.

Is my understanding true? Is it possible to report viewers to read power query parameters any how? (even we disabled this option)

Re: Can report viewers access Power Query parameters?

nandukrishnavs — Mon, 27 Mar 2023 12:06:44 GMT

@Anonymous : If the user permission is "Viewer", then they can't download the report and also they can't view the parameters.

Re: Can report viewers access Power Query parameters?

Anonymous — Mon, 27 Mar 2023 13:33:45 GMT

Thanks for the reply @nandukrishnavs

Other than settings page (shows in the image) any other place a user can see the Power Query parameters in Power BI Service? (in the report or the dataset, even for a user having edit access)

Re: Can report viewers access Power Query parameters?

nandukrishnavs — Mon, 27 Mar 2023 14:47:17 GMT

@Anonymous People with edit access can view parameters in Power BI parameter section. Also, they can download the report and see the parameter.