Forum Discussion
Composite Model Error
Hi All When I create a composite model with a data source using direct query and a data source using import I dont get errors. However, if I add an excel spreadsheet as a data source to the c...
Thanks for the reply.
I am using Direct Query and sql server(import) in the composite model, this works perfectly.
If I add an excel spreadsheet to the composite model, I receive the following error:
"Couldn't load the data for this visual".
If I remove the excel spreadsheet as a data source, the composite model works as intended.
We have a similari problem, too.
We definendo a composite model with a locale dummy table and direct query on 2 power bi datasets of the same workspace.
It works fine on desktop and service.
When se add import from excel file on sharepoint folder it works fine on desktop, it design not work on service.
Paradoxically, on service, we se data from excel bit get error for data from datasets.