Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago
Solved

Direct Query Best Practise DB Views

Greetings, I'm using Direct Query for a Proof of Concept for a PBI Embedded Dashboard and Report I'm building. One of the major challenges I'm facing is formatting and joining data together and give...
Need Help
  • aj1973's avatar
    aj1973
    5 years ago

    Hi Anonymous 

    If I understood your question correctly then the answer is Yes, you can create your Views in the DB and Import/DirectQuery them to Power BI. Know though that these Views can be avoided if you Import directly your tables to Power Bi and Model them.

     

v-xulin-mstf's avatar
v-xulin-mstf
Community Support
5 years ago

Hi Anonymous,

 

You can use your SQL views in Power BI.
Try to connect to it by  your server and database name , and then expand the "Advanced Options", and drop in a query to call upon that view.

SELECT [Field List]
FROM dbo_viewname

Take SQL Server and Oracle DB for example:

 

 

Best Regards,

Link