Forum Discussion

mak's avatar
mak
Helper I
9 years ago
Solved

How to add more tables from database

When creating my desktop file, I selected few tables, now since its working good, I would like to add more tables   ? How to add more tables to the project from the datasource already selected
Need Help
Tips and Tricks
  • Phil_Seamark's avatar
    Phil_Seamark
    9 years ago

    There are two modes for getting data into Power BI Desktop.  

     

    1) Import

    2) Direct Query

     

    You can't mix and match, so all queries need to be 1) or all 2).

     

    There are pros and cons to both.  If your dataset is small then I'd recomment Import.  If your dataset is large (and frequently changing) then perhaps Direct Query is better - particulary if your source is MS SQL or SSAS

  • Anonymous's avatar
    Anonymous
    9 years ago

    Hi mak,

    In DirectQuery mode, all tables should come from same database. If you add tables of different database into the current Power BI Desktop file, you will get the above warning which indicates that you can switch to import mode.

     

    Thanks,
    Lydia Zhang

mak's avatar
mak
Helper I
9 years ago

Hi

 

The problem was more with how you defined the Azure query string, your Azure SQL url should be well qualified and begin with

tcp:yourdb.database.windows.net;1433

 

that resolved the issue

Anonymous's avatar
Anonymous
Not applicable
4 years ago

Hey mak,  Do you ever get the feeling that these 'helpers' on such forums just paste in answers to questions that you DIDN'T ask?....  Cuz they don't know the answer you need. ;-(