Forum Discussion
SQL server import query run 2 times
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.
7 Replies
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.
