Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more.
Get startedGrow your Fabric skills and prepare for the DP-600 certification exam by completing the latest Microsoft Fabric challenge.
Hello, I have an issue with Power bi who runs 2 twice a request from sql server.
The time (duration) of importation data from sql server is very long.
In my case I have a request in SQL server, when I run it the duration is 1min30.
When I do the importation in Power Bi desktop, it run the query 2 times (it took 3min in total).
Do you know how to resolve this.
Thanks in advance.
Hello lbendlin,
I try it but it doesn't work. In SQL it's turn in 1min30 but in power bi it took 3min
This is my query:
let
Source = Sql.Database("A", "B", [Query=".........."]),
OverrideZeroRowFilter = Table.View(null,[GetType = () =>type table
[cpcpte = Decimal.Type]
, GetRows = () => Source, OnTake
= (count as number) => if count = 0
then #table(GetType(), {})
else Table.FirstN(Source, count)]
),
#"Col rename" = Table.RenameColumns(Source,{{"cpcpte", "cpt"}})
in
#"Col rename"
Don't run a custom query, or mask it with a view.
I don't get it 😬. Could you details more please?
Let Power Query connect to a view in your SQL database.
Okay I understand but in my query I have some parameters so I couln't use a view from SQL database.
Not sure I understand. Power Query doesn't know that it is talking to a view. Your parameters will work regardless.
User | Count |
---|---|
86 | |
83 | |
69 | |
67 | |
55 |
User | Count |
---|---|
125 | |
100 | |
90 | |
84 | |
66 |