Forum Discussion
Error fetching data for this visual
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
Hi K3ph4s ,
As the issue is on Power BI Service side (not on Power BI Desktop app), could you make sure you added all credentials needed on Power BI dataset settings?
If that is not the case, could you share mode details, example of models A and B?
How are they connected?
How are these calculated columns created (via DAX or Power Query)?
Are these calculated columns user then for some other calculations?
It may be that calculated columns is created via DAX, but it used as a Key to connect some tables in Power Query so it is confused.
The order of operations is important, in this case it seems that some part of data is not fetched successfully which leads to error because it should be used on another place in data model.
Cheers,
Nemanja Andic