SQL server import query run 2 times

[Anonymous]

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.

[lbendlin]

Chris Webb's BI Blog: Why Is Power BI Running My SQL Query Twice? (crossjoin.co.uk)

[Anonymous]

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"

[lbendlin]

Don't run a custom query, or mask it with a view.

[Anonymous]

I don't get it 😬. Could you details more please?

[lbendlin]

Let Power Query connect to a view in your SQL database.

[Anonymous]

Okay I understand but in my query I have some parameters so I couln't use a view from SQL database.

[lbendlin]

Not sure I understand.  Power Query doesn't know that it is talking to a view. Your parameters will work regardless.