Forum Discussion
Snowflake data source - Python Pandas - Working Desktop / Not working on Workspace
- Anonymous1 year ago
Hi Pawel_1990 ,
Thank you for reaching out to the Microsoft Community Forum.
Some of the issues listed below:1. Verify Python Installation: Ensure that Python is installed on your machine and that the path to the Python executable is correctly set in the environment variables.
https://learn.microsoft.com/en-us/power-bi/connect-data/service-python-packages-support
2. Python scripts only work with personal gateways. Please refer the below thread
3. Additionally, as Akash_Varuna suggested try running the Python transformations outside Power BI.
If my response has resolved your query, please mark it as the Accepted Solution to assist others. Additionally, a 'Kudos' would be appreciated if you found my response helpful.
Thank you
Hi Pawel_1990 As you said the excel is working fine it is likely because of the connection to Snowflake it actually requires Gateway ..... some of the likely issues are listed please check these and see if it solves your issue
Gateway Requirement – Power BI Service needs an on-premises data gateway for Snowflake. Ensure it's installed and configured.
Authentication Issues – Check Dataset Settings → Data source credentials and confirm your Snowflake login is correctly set.
DirectQuery and Python Conflict – If some tables use DirectQuery, Python transformations may fail. Try switching all Snowflake tables to Import mode and republish.