Credentials for a Python data source

[rnian18]

Hi guys,

I have a Python transformation in my PowerBI desktop before publishing the report onto PowerBI Services.

In PowerBI Desktop, the credentials and everything are working perfectly.  However, when I publish it to PowerBI Services, it says that the credentials do not work.  I read somewhere that Python data sources cannot be used for PowerBI Services.  I am wondering if this is true, and if not, how do I solve this credentials issue?

Just to add again, everything is working perfectly on the desktop version.  The issue only appears when I go into service.  I have installed that package from Github already.

Please see below for the issues.

[v-yalanwu-msft · Accepted solution]

Hi, @rnian18 ;

Based on this document, It is not supported to implement schedule refresh via on premise Data Gateway (Enterprise Gateway) for Python in Power BI Service currently .

• To enable scheduled refresh of your Python dataset, you need to enable Scheduled refresh and have a Personal Gateway installed on the computer that houses the workbook and the Python installation. 
• For the Python scripts to work properly in the Power BI service, all data sources need to be set to public.
• Nested tables (table of tables) are currently not supported.

Install the Personal Gateway - you need a Personal Gateway installed on the machine where the file is located, and where Python is installed.

Best Regards,
Community Support Team_ Yalan Wu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[rnian18]

Hi Yalan,

Thanks a lot for the reply.  I downloaded the personal gateway and set all the data sources (the Web API and the Python data source) to public, however, I am still getting the Python installation error shown below:

I really feel like somehow, PowerBI can only use the base Anaconda virtual environment when in PowerBI services.  I may try to find a spare computer and download Python 3.6 and try it there.  I used to get this same error on PowerBI Desktop running any Python virtual environment above Python 3.6.8 (I tried it from Python 3.7 to Python 3.9).  Except the Desktop version allows me to set the Python interpretor as a created virtual environment (instead of the base), so it was a lot easier for me to test.

[rnian18]

After some digging, it appears that the wireless gateway is using the default python environment (as seen from the error logs), which is Anaconda Python 3.8.  I have tested many scripts, and PowerBI does not support anything above Python 3.6 from my tests.  In my PowerBI desktop version, I configured PowerBI to use a virtual environment I built strictly for PowerBI using Python 3.6. 

Does anybody know why PowerBI Services is not taking that into account?  Also, does anyone know how I can change where the wireless gateway is looking when executing the PowerBI Python script?