Power BI Embedded Report Not Showing Data – Lakehouse Model + DirectQuery Attempt

[kueekiz]

Hello,

We are embedding a Power BI report into our web application. The report is built on a semantic model connected to a Microsoft Fabric Lakehouse.

The report displays correctly in the Power BI Service. However, when embedded into our application, the visuals remain fail to load data.

"Error fetching data for this visual
Couldn't retrieve the data for this visual. Please try again later"

We tried converting the model from Direct Lake to DirectQuery and republishing from Power BI Desktop to a Premium workspace, but the issue persists.

We have reviewed Microsoft documentation, which states:
"Using Power BI Embedded with datasets that include a DirectQuery connection to a Power BI dataset or Azure Analysis Services model is not currently supported."
Given this limitation, what is the recommended approach or workaround to ensure data visibility in an embedded dashboard that uses a Lakehouse-backed semantic model? Is there an alternative solution to make the embedded report display data correctly?

Any advice, official guidance, or best practices would be greatly appreciated. Thank you in advance!

[v-sdhruv]

Hi @kueekiz ,

Just wanted to check if you had a chance to review the suggestions provided and whether that helped you to resolve your issue?

[v-sdhruv · Accepted solution]

Hi @kueekiz ,

Embedded reports backed by Lakehouse Model should work because it directly accesses tables in OneLake, enabling real-time data updates and analysis. If your requirement is not real-time processing then I would suggest you to use import mode. But if you require real-time processsing, then go for Direct lake.

Check out-
Introducing Power BI Embedded with Direct Lake Mode
Direct Lake

Hope this helps!

[kueekiz]

Hi,

Yes , it worked. Thank you so much for the support! 🙂

[MasonMA]

Since it's been specified by MS... and you have tried with DirectQuery, one of the remaining options for moment would be switch the semantic model to Import mode:)