SQL Query to Power BI

[Hussard]

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 statement:

SELECT pc.id ,count(*) cpt, p.state
FROM Product AS p INNER JOIN Prices AS pp ON p.Id = pp.IdProduct INNER JOIN Catalog AS pc ON p.IdCatalog = pc.Id
WHERE ISNULL(pp.tariff, 0) <> 1 AND pc.version<> - 1 and pc.Status<>2
group by pc.id, p.state
order by pc.id

I tried to merge queries in query editor and also create some fields but ... I don't know what is the best method to do that.

I think this issue is quite easy to solve but I don't know how.

Thanks !

Sébastien