Forum Discussion
Solved
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...
I see my view now, sorry to waste timw with this post
please disregard
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