Refresh the Python Script in Power Bi Service ask a credentials

[evgenyg]

Refresh filed with following message:

"""

Scheduled refresh is disabled because at least one data source is missing credentials. To start the refresh again, go to this dataset's settings page and enter credentials for all data sources. Then reactivate scheduled refresh.

"""

I am using python script from Microsoft docs.

https://docs.microsoft.com/En-us/power-bi/connect-data/desktop-python-scripts

Why it ask a credentials?

[GilbertQ · Accepted solution]

Hi there

You have to use the Power BI Personal mode gateway in order to refresh Python scripts

Here are more details: https://www.google.com/url?sa=t&rct=j&q=&esrc=s&source=web&cd=&cad=rja&uact=8&ved=2ahUKEwja7fSo_PjsA...

[evgenyg]

Hi GilbertQ,

thank you for you answer. 

Do I understand correctly that the Power BI Service runs python on the local computer through a gateway, and not somewhere in the cloud?

[v-shex-msft · Accepted solution]

Hi @evgenyg,

Yes, the R/Python script was processed in a sandbox instead of direct execute on the cloud server.
They should have a few limitations when you use on the cloudy server(i suppose they may be related to permission and security reasons), so you can only use a personal gateway to handle these scripts.

Power BI data sources 

Power BI Security

Python visualizations in Power BI Service 
Regards,

Xiaoxin Sheng

[GilbertQ · Accepted solution]

Hi there

You have to use the Power BI Personal mode gateway in order to refresh Python scripts

Here are more details: https://www.google.com/url?sa=t&rct=j&q=&esrc=s&source=web&cd=&cad=rja&uact=8&ved=2ahUKEwja7fSo_PjsA...