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, whe...
lbendlin
Super User
Super UserHello 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"