Yes.That was my though. But there is no direct link between Power BI (Power Query) and SQL.

I was thinking (beside using API) to:

1. Import in Power Query

2. Load to...

Thanks. But I need something that is Free.

BR, Borut

Thank you. I will try to get out what I need.

I have tried your solution just to see how it is working, now I have to implement this in...

hm, ok.

But what if I have dynamic day from - day to and I am doing dynamic filter on my factsales. Because of that once I will have day...