Forum Discussion

ChristopheS's avatar
ChristopheS
Regular Visitor
5 years ago

Select mutiples tables

Hello,

 

When i use a SQL server database to import my datas on Power Bi, i wouldt like select multibles tables from my base (247/498).

Rather than select the tables 1 by 1, i try tu use the sql statement but i can't select mutliples tables.

Someone can help me?

 

Thanks you

 

Need Help

8 Replies

    • ChristopheS's avatar
      ChristopheS
      Regular Visitor
      5 years ago

      It's the same thing i have to click one by one the tables...

  • amitchandak's avatar
    amitchandak
    Super User
    5 years ago

    ChristopheS , I doubt you can do that in power bi import. But if you have created a relation between tables in databses you can drag related table in case of sql server

    • ChristopheS's avatar
      ChristopheS
      Regular Visitor
      5 years ago

      There is no relations between all the tables i want

      • themistoklis's avatar
        themistoklis
        Community Champion
        5 years ago

        ChristopheS 

         

        Well why dont you click all tables one by one. You wll do it once.

         

        Next time you can just use the same workspace which has all the tables