Tell programmatically or otherwise if a query is being run on the Service or Desktop

[Griffin_BI]

I have a pbix file that runs some Python at the end of a Power Query data refresh. I don't want the Python to run if I'm doing dev work on the file. Is there any way to prevent this from happening? Is there any way to tell programmatically or otherwise if a query is running on the desktop or on the service?

Thanks!

[selimovd · Accepted solution]

Hello @Griffin_BI ,

yes, you can set a parameter in Power Query, lets say "Platform".

This parameter you can set to the value "Desktop" and then not run the python script if "Platform" = "Desktop".

On the Power BI Service you can change the value of the parameter to "Service" and then the python script should run.

Check the following tutorial, here they just change the data source for Desktop and Service, but you will get how it works:

Change the Source of Power BI Datasets Dynamically Using Power Query Parameters - RADACAD

If you need any help please let me know.

If I answered your question I would be happy if you could mark my post as a solution ✔️ and give it a thumbs up 👍

Best regards

Denis

Blog: WhatTheFact.bi

Follow me: twitter.com/DenSelimovic

[Griffin_BI]

@selimovd thanks for the reply. That is a decent solution and workable. I could put the parameter in the Python string in the formula box in Power Query.

Ideally the solution would be able to tell without any manual input whether the .pbix is refreshing on the desktop or service, but if no one else replies I will mark this as a solution.