Forum Discussion

Charles001's avatar
Charles001
Frequent Visitor
4 years ago

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 composite model, then I get errors on the service but not on the desktop.  If I remove the excel spreadsheet as a data source the errors disappear.

 

If I only add excel to direct query and remove the sql server using import, there are no errors.

 

Is it because PBI composite models only allow two data sources?

 

Many thanks.

Need Help

3 Replies

  • Anonymous's avatar
    Anonymous
    Not applicable
    4 years ago

    Hi Charles001 ,

     

    Please show more details. What data sources you are using and what is the error message.

    The following Live Connect tabular sources can't be used with composite models:

     

    Best Regards,

    Jay

    • Charles001's avatar
      Charles001
      Frequent Visitor
      4 years ago

      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.

      • 10246532's avatar
        10246532
        Advocate I
        3 years ago

        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.