Forum Discussion

AaronS_PB's avatar
AaronS_PB
Regular Visitor
8 years ago
Solved

Adding additional data sources

I am using data from an azure database to create reports. However, when I connect to the database as my data source, I no longer have the option to add data from other sources. I have successfully loaded multiple tables from excel and csv files into a single report but there appears to be a restriction when using the database. Any ideas what may be causing this?

  • Hi AaronS_PB

     

    I'm pretty sure that means you are locked to a single data source.  If you'd like to build a data model using multiple sources, you'll need to switch to import mode (which is pretty good), or get your other data into your SQL DB.

4 Replies

      • Phil_Seamark's avatar
        Phil_Seamark
        Microsoft Employee

        Hi AaronS_PB

         

        I'm pretty sure that means you are locked to a single data source.  If you'd like to build a data model using multiple sources, you'll need to switch to import mode (which is pretty good), or get your other data into your SQL DB.