Forum Discussion
How to start using SQL (SMSS) instead of importing whole tables for Power BI report
Hey Anonymous ,
sure, you can also save the SQL query in SQL Server. This is then called a view.
In Power BI you can just select that view and it behaves like a table. In SQL Server this view is a SELECT to the real table.
To create the view you have to create it in SQL Server. You can do that like this:
CREATE VIEW view_name AS SELECT * FROM table_name WHERE condition;And then you can just select the view in Power BI as table. You can also in SQL Server then query the view like this:
SELECT * FROM view_name WHERE conditionHere is a short introduction to views in SQL:
If you need any help please let me know.If I answered your question I would be happy if you could mark my post as a solution ✔️ and give it a thumbs up 👍Best regardsDenisBlog: WhatTheFact.biFollow me: twitter.com/DenSelimovic
Hi selimovd,
Thank you for your answer. I want to do it using SQL. Then the only way to do this is to paste the whole SQL statement i wrote in that text box you show? Is that the best way to do this?
Isn't there a way to create the table in SQL using SMSS and then simply import that (I have no idea if thats possible)? To avoid having to paste SQL statements in Power bi?
Most Valuable ProfessionalHey Anonymous ,
sure, you can also save the SQL query in SQL Server. This is then called a view.
In Power BI you can just select that view and it behaves like a table. In SQL Server this view is a SELECT to the real table.
To create the view you have to create it in SQL Server. You can do that like this:
CREATE VIEW view_name AS
SELECT *
FROM table_name
WHERE condition;
And then you can just select the view in Power BI as table. You can also in SQL Server then query the view like this:
SELECT * FROM
view_name
WHERE condition
Here is a short introduction to views in SQL: