Loading Data in Direct Query Mode

[Manasa55]

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? 

[Anonymous]

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.

[Anonymous · Accepted 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.