Join the FabCon + SQLCon recap series. Up next: Power BI, Real-Time Intelligence, IQ and AI, and Data Factory take center stage. All sessions are available on-demand after the live show. Register now
I Loaded data from the Fabric Lakehouse to the Power Bi through python script. But data is loading in the Import Mode I want to load the tables data using Direct Query Mode using python script can we able to achieve this in power BI?
Solved! Go to Solution.
Hi @Manasa55
Thank you for reaching out microsoft fabric community forum.
DirectQuery mode is not supported for Python scripts in Power BI.Use Fabric Lakehouse SQL Endpoint for DirectQuery mode.You can load data into an SQL database via Python and then connect Power BI to it using DirectQuery.
If this solution helps, please consider giving us Kudos and accepting it as the solution so that it may assist other members in the community.
Thank you.
Hi @Manasa55
May I ask if you have resolved this issue? If so, please mark the helpful reply and accept it as the solution. This will be helpful for other community members who have similar problems to solve it faster.
Thank you.
Hi @Manasa55
Thank you for reaching out microsoft fabric community forum.
DirectQuery mode is not supported for Python scripts in Power BI.Use Fabric Lakehouse SQL Endpoint for DirectQuery mode.You can load data into an SQL database via Python and then connect Power BI to it using DirectQuery.
If this solution helps, please consider giving us Kudos and accepting it as the solution so that it may assist other members in the community.
Thank you.
Check out the April 2026 Power BI update to learn about new features.
If you have recently started exploring Fabric, we'd love to hear how it's going. Your feedback can help with product improvements.
A new Power BI DataViz World Championship is coming this June! Don't miss out on submitting your entry.
| User | Count |
|---|---|
| 10 | |
| 10 | |
| 10 | |
| 7 | |
| 7 |
| User | Count |
|---|---|
| 43 | |
| 33 | |
| 27 | |
| 20 | |
| 19 |