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 s...
Need Help
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

      • ChristopheS's avatar
        ChristopheS
        Regular Visitor
        5 years ago

        Because i work for a software editor and we propose power bi to our customers, si i have to select every tables for all my customers who wants Power BI, that why i want to "automate" the action.