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.

Kind Regards,
Gökberk Uzuntaş

📌 If this post helps, then please consider Accepting it as a solution and giving Kudos — it helps other members find answers faster!

🔗 Stay Connected:
📘 Medium |
📺 YouTube |
💼 LinkedIn |
📷 Instagram |
🐦 X |
👽 Reddit |
🌐 Website |
🎵 TikTok |