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
nandic thanks... this is something it must be reported to Microsoft.
So i have done everythin correct.
The solution is to add the data base of the Model A into every other moderls B, C....
Thanks
K3ph4s yes, you have done everything as it should be (from developer view).
However, Microsoft is pretty much aware that a lot of DAX functions do not work in DirectQuery. They mention it always when presenting directquery.
And yes, i agree with you that if they allow us to combine live data and imported data in desktop app, it should be fine on Service. On the other hand, if it was easy, they would make it work.