Connecting Power BI to Lakehouse in Import Mode and Setting Up Scheduled Refresh

[VenuBollineni]

Scenario:

I have a semantic model in the Lakehouse. When I try to connect from Power BI Desktop to the Lakehouse and the semantic model, the connection mode defaults to DirectQuery.

Question:

I need to connect in Import mode and set up a scheduled refresh. What is the right approach to achieve this?

***The main goal is to ensure that the data does not display incorrectly while it is loading in the Lakehouse.

[uzuntasgokberk · Accepted solution]

Hello @VenuBollineni,

You can follow below images if you'd like to connect as import mode in lakehouse.

When you copied SQL CS.

Best Regards,
Gökberk Uzuntaş

LinkedIn: https://www.linkedin.com/in/g%C3%B6kberk-uzunta%C5%9F-b43906198/

Medium: https://medium.com/@uzuntasgokberk

İf this post helps, then please consider Accept it as solution and kudos to help the other members find it more quickly.