Forum Discussion

mscomp's avatar
mscomp
Regular Visitor
8 years ago
Solved

Get Data from SQL without function Table

hi  i have problem in power bi desktop when connect to my software SQL server. in this software we have 500 Data table and 23000 function . when i want connect to this SQL Server , power bi get tot...
  • WillemC's avatar
    WillemC
    8 years ago

    Is the following not an option:

    Get Data --> SQL Server datbase -->

    fill in the server and database.

    And if you like, create a basic sql statement that should be executed (select * from [database])

    Or create a more explicit sql statement, which retrieves only the data you want.

WillemC's avatar
WillemC
Resolver I
8 years ago

Is the following not an option:

Get Data --> SQL Server datbase -->

fill in the server and database.

And if you like, create a basic sql statement that should be executed (select * from [database])

Or create a more explicit sql statement, which retrieves only the data you want.