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
K3ph4s , two more questions:
1) As i have not used Autodesk connector earlier, did you try to publish data only from this connector to Power BI Service? I've heard that some connectors work in desktop app, but not on Power BI Service
2) Power BI dataset A is published to Power BI Service. Now you have new Power BI file (new dataset) where you connect live to published dataset A and then you additionally add data from Autodeck, etc in that new dataset (you create local model)? Everything works fine locally until you publish it to Power BI Service.
Then you can see errors on reports because it requires dataset refresh.
What type of error do you get when you try to refresh that new dataset?
Cheers,
Nemanja Andic