Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
While testing out the new DirectQuery for Power BI Datasets preview feature, I receive an error that prevents me from using it. I have the preview feature enabled and am using Power BI Desktop version 2.88.802. My coworker has the latest version and has the same issue.
I have no measure tables, only some tables that have had all non-measures hidden.
First, within Power BI Desktop, I connect to a Power BI dataset as normal, which creates a live connection to it. Next, I try to bring in another Power BI dataset. It asks me to convert the existing connection to DirectQuery, I click OK. I also click OK on the privacy warning. It appears to successfully bring in the 2nd Power BI dataset. However, now all of the explicitly defined measures in both models have a variation of the following error message and can't be used: "Something's wrong with one or more fields: (Spend Measures) Addressable Spend: Cannot find data source 'DirectQuery to AS - Spend & Savings Data Model' in function 'EXTERNALMEASURE'."
I found that all measures get this error message even if the 2nd data source I attempt to bring in is an imported Excel or text file, it makes no difference.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.