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 condition

Here is a short introduction to views in SQL:

SQL: Views - YouTube