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.

      • themistoklis's avatar
        themistoklis
        Community Champion
        5 years ago

        ChristopheS 

         

        I understand your requirement. 

        PowerBI is a visualisation tool though which only uses a small subset of the database.

         

        I dont know if there is any value of adding all tables to a BI tool. What is the purpose for doing that?

        Are you planning to create a Data Model based on all tables?