Forum Discussion

K3ph4s's avatar
K3ph4s
Regular Visitor
1 year ago
Solved

Error fetching data for this visual

Hi community, I have a huge issue I do not know how to solve: I have some BI models A,B,C A BI Model is databased, that is linked into B and C as the "powerBI Sematic Model"   In my B and C mode...
Need Help
  • nandic's avatar
    nandic
    1 year ago

    K3ph4s , addition to my previous reply.
    I created relationship between table from existing model with table from new source.
    And after dataset refresh on Power BI Service, it throwed me the same error as in your side.

    The issue is because i created relationship between table which is now in directquery model with table which is in import mode.

    Then i created new table via directquery and when i tried to add new column, it throwed me error when i tried to use "LookupValue" function.
    Which means this function doesn't work when using directquery mode.

    So in your case, i think it is easier to take pbix file that is already published for model A, duplicate it and then within this new pbix file to add tables for model B and model C.
    So not to have composite model (link to published dataset + new data sources), but to have all tables within new pbix file (new dataset).

    Cheers,
    Nemanja Andic

nandic's avatar
nandic
Resident Rockstar
1 year ago

Hi K3ph4s , i did test on my side.
Connected to existing semantic model, added locally additional table, created relationship, created same dax expression as above, everything works fine.

This is the warning that i get before publish:

As connection to published dataset becomes directQuery after adding locally new sources, maybe it hits some of these limitations: https://learn.microsoft.com/en-us/analysis-services/tabular-models/directquery-mode-ssas-tabular?view=asallproducts-allversions#limitations 

Additinaly, calculated tables are not supported, do you have any calculated tables in this composite model?

Finally, could you try rewriting DAX, to use Related instead of LookupValue or creating relationship?

Here is full text with composite model limitations: https://learn.microsoft.com/en-us/power-bi/transform-model/desktop-composite-models