Forum Discussion
Issue with Python Data Source: Extension{"extensionDataSourceKind":"Python"} in Power BI Service
Extension{"extensionDataSourceKind":"Python","extensionDataSourcePath":"Python"}.
- Dependency on local hardware: It requires a specific user's computer to be powered on and connected.
- Scalability: It lacks the robustness and centralized management of the Standard (Enterprise) Gateway.
- Security and Maintenance: Maintaining individual Python environments on local machines is inefficient.
- Enabling Python execution support within the Standard (Enterprise) Gateway.
- Providing a native cloud environment for Python script execution within the Power BI Service/Fabric capacity.
Python is not necessary for this. Consider using the standard web connection and Power Query transforms instead.
6 Replies
This forum here is the wrong place for your comment. If this is important to you please consider voting for an existing idea or raising a new one at https://ideas.fabric.microsoft.com
Since you are asking on the Fabric Platform forum, what are you hoping to achieve with the Python scripts? Is it something that could actually be orchestrated in a fabric workspace beforehand which would speed up the report?
Thank you for your response!
To clarify: I'm using Python to connect to our ISO management platform (Kawak -
https://kawak.com.co), which provides an API for accessing non-conformities,
corrective actions, and audit findings data.**Current workflow:**
1. Python script authenticates to Kawak API (POST to /login endpoint)
2. Retrieves paginated data from /api/v1/accionesMejora endpoint
3. Consolidates all pages into a single dataset
4. Power BI Desktop consumes this as a table for our compliance dashboard**The challenge:**
The script works perfectly in Power BI Desktop, but fails in Power BI Service
due to Python data source limitations. The data needs to refresh daily to track
overdue corrective actions across multiple ISO certifications (9001, 14001,
45001, etc.).Python is not necessary for this. Consider using the standard web connection and Power Query transforms instead.
