Forum Discussion

Hussard's avatar
Hussard
Frequent Visitor
8 years ago
Solved

SQL Query to Power BI

Hi all,   At first I made a view in SQL SERVER, and all is OK.   Now I want to create directly into Power BI the same query I've done in SQL Server but from the whole tables.   Here is the SQL ...
Need Help
  • zoloturu's avatar
    zoloturu
    8 years ago

    DirectQuery is not the best mode to get to know Power BI. It is better to work with Import in this case.

     

    How to implement such task via Power BI:

    1. Go to an advanced editor of a blank query.

    2. Reference the first table and filter it as you mentioned in SQL:

        ISNULL(pp.tariff, 0) <> 1 AND pc.version<> - 1 and pc.Status<>2

    3. Repeat the previous action to last two tables.

    4. Use merge to join 1st and 2nd.

    5. Merge result of the previous action with 3rd.

    6. Do grouping

    7. Do ordering

     

    Regards,

    Ruslan

zoloturu's avatar
zoloturu
Memorable Member
8 years ago

DirectQuery is not the best mode to get to know Power BI. It is better to work with Import in this case.

 

How to implement such task via Power BI:

1. Go to an advanced editor of a blank query.

2. Reference the first table and filter it as you mentioned in SQL:

    ISNULL(pp.tariff, 0) <> 1 AND pc.version<> - 1 and pc.Status<>2

3. Repeat the previous action to last two tables.

4. Use merge to join 1st and 2nd.

5. Merge result of the previous action with 3rd.

6. Do grouping

7. Do ordering

 

Regards,

Ruslan

webportal's avatar
webportal
Impactful Individual
6 years ago

Hi all,

I came across a similar issue and this post has helped me,

However, I'll try an R script to grab all the static data into a .csv (cheaper than Excel) and build a flow from that.

Then, in Power BI Desktop, I'll import the most recent data, as of a certain date and keep that refreshed every day.