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

Power BI- Convert SQL query to power bi

Basically i have to do on the power bi the same as the query that i do below.

 

selecT [Artigo] ,avg([uster]) AvgUster from (
          selecT *, Rank()
          over (Partition BY Artigo
          order by artigo asc, data desc) AS Rank_
FROM [Mundifios_DW].[dbo].[FACT_Laboratorios] b
where Fornecedor = '0013' --- Condições da query
) rs
where RANK_ <=5
group by [Artigo]
GO

I cannot understand the steps that i have to do to sucefully do that query on the power bi report that im doing. Can you please help me?

 

Best Regards

2 REPLIES 2
Super User
Super User

Re: Power BI- Convert SQL query to power bi

When you connect to your SQL database in the Query Editor, use "Advanced" and just paste in your SQL.


I have book! Learn Power BI from Packt


Did I answer your question? Mark my post as a solution!

Proud to be a Datanaut!

v-yulgu-msft Super Contributor
Super Contributor

Re: Power BI- Convert SQL query to power bi

Hi @BernardoPedroso,

 

You can create a calculated table in Power BI with below similar DAX formula:

New table =
VAR TOP5table =
    TOPN (
        5,
        FILTER ( FACT_Laboratorios, FACT_Laboratorios[Fornecedor] = "0013" ),
        FACT_Laboratorios[artigo], ASC,
        FACT_Laboratorios[data], DESC
    )
RETURN
    GROUPBY (
        TOP5table,
        [Artigo],
        "AvgUster", AVERAGEX ( CURRENTGROUP (), [uster] )
    )

Reference: 

TOPN
Nested grouping using GROUPBY VS SUMMARIZE

 

For more advice, please refer to this link to provide necessary sample data and expected result which can achieved by above SQL code.

 

Best regards,

Yuliana Gu

Community Support Team _ Yuliana Gu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Helpful resources

Announcements
Can You Solve These Challenge

Challenge: Can You Solve These?

Find out how to participate in the first Power BI 'Can You Solve These?' challenge.

Community News & Announcements

Community News & Announcements

Get your latest community news and announcements.

Virtual Launch Event

Microsoft Business Applications October Virtual Launch Event

Join us for an in-depth look at the new innovations across Dynamics 365 and the Microsoft Power Platform.

Community Kudopalooza

Win Power BI Swag with Community Kudopalooza!

Each week, complete activities and be qualified in the drawing for cool Power BI Swag.

Users Online
Currently online: 134 members 1,865 guests
Please welcome our newest community members: