Forum Discussion

EVEAdmin's avatar
EVEAdmin
Post Patron
7 years ago
Solved

Import tables or write SQL query? The debate

Please share your opinions on this subject. I successfully connected to my remote MSSQL Server and can import those tables necessary to generate reports.  When I import tables, I can hide/delete co...
Need Help
  • Mark_Timson's avatar
    Mark_Timson
    7 years ago

    Using direct query can help if your table is too large to import. From what I can tell trying to import using params in power bi is pretty difficult. I tend to create a sql view with ctes to act as params and use another cte to bring it altogether in view to only return and smaller data subset and then import in with power bi. 

     

    The import is fairly quick for tables under 30 million rows.

Mark_Timson's avatar
Mark_Timson
Helper I
7 years ago

Using direct query can help if your table is too large to import. From what I can tell trying to import using params in power bi is pretty difficult. I tend to create a sql view with ctes to act as params and use another cte to bring it altogether in view to only return and smaller data subset and then import in with power bi. 

 

The import is fairly quick for tables under 30 million rows.