Forum Discussion
Slow initial load
Hello! I've created a PowerBI report that I previously had some performance issues with. I've now corrected all of those performance issues and have < 7 seconds of waiting time on each report pag...
Goofr
Advocate IV
Advocate IVHi, I had the same problem with my Direct Query Reports.
You can solve this with the Value.NativeQuery:
let
Source = Sql.Database(Server, Database),
Data = Value.NativeQuery(
Source,
"
select column...
from tabel
",
null,
[EnableFolding = true]
)
in
Data
I hope this helps.
Frank