Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
ISSUE:
A report created with PBI Desktop that uses a Fabric lakehouse as its datasource in DirectQuery mode has experienced the following error when navigating from one page to the one you see in the screenshot. In other words, when you navigate to a page for the first time, as here was the case, PBI Desktop needs to load the data from the lakehouse. Some data comes through as some visuals populate, but not others. All data for all the visuals come from the same lakehouse table.
The error message is:
The M code for the model table is as follows:
let
Source = Sql.Database("45asfd5s4f6.datawarehouse.fabric.microsoft.com", "LH_RWS"),
dbo_FACT_RWS_M15 = Source{[Schema="dbo",Item="FACT_RWS_15M"]}[Data]
in
dbo_FACT_RWS_M15
Then after dismissing the dialog, navigating away and back to the page, the error went away and the remaining viz loaded properly.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi @Element115
Based on the above information, if you are a Power BI Pro licensee, you can create a support ticket for free and a dedicated Microsoft engineer will come to solve the problem for you.
The link of Power BI Support: https://powerbi.microsoft.com/en-us/support/
For how to create a support ticket, please refer to https://community.powerbi.com/t5/Community-Blog/How-to-create-a-support-ticket-in-Power-BI/ba-p/6830...
Best Regards,
Community Support Team _ Ailsa Tao