cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
Regular Visitor

SQL server database views

I am connecting to sql server from power bi.

 

I see all the tables but would like to create views in my sql server environment and access the database views instead of the actual tables.

 

can I access sql server database views from power bi, so far I only see the tables?

 

I did a search and looks someone asked the same question and someone answered 'Yes', but I did not see any instructions on how to access the database views in the response.

 

Thank you in advance for any assistance

1 ACCEPTED SOLUTION

Accepted Solutions
Highlighted
Regular Visitor

Re: SQL server database views

I see my view now, sorry to waste timw with this post

 

please disregard

View solution in original post

3 REPLIES 3
Highlighted
Frequent Visitor

Re: SQL server database views

You can absolutely utilize your SQL views in Power BI.


Try to connect to it by entering your server and database name as you normally would, but then expand the "Advanced Options", and drop in a query to call upon that view 
    SELECT [Field List]
    FROM dbo_viewname

Highlighted
Regular Visitor

Re: SQL server database views

I see my view now, sorry to waste timw with this post

 

please disregard

View solution in original post

Highlighted
Frequent Visitor

Re: SQL server database views

You can absolutely utilize your SQL views in Power BI. When connecting to a SQL server, expand the "Advanced Options" button and drop in a query to call upon that view.

 

Something like 

Helpful resources

Announcements
Get Ready for Power BI Dev Camp

Get Ready for Power BI Dev Camp

Don't miss the Power BI Dev Camp this week!

August Community Highlights

Check out a full recap of the month!

August 2020 CYST Challenge

Check out the winners of the recent 'Can You Solve These?' community challenge!

Experience what’s next for Power BI

Join us for an in-depth look at the new Power BI features and capabilities at the free Microsoft Business Applications Launch Event.

Top Kudoed Authors