This is best Fabric, Power BI, SQL and AI community event. How do we know? The last event sold out! Save €200 with code FABCMTY200.
Register nowThe Fabric community is now in read-only for platform upgrade. Learn more
I have a report page that is slow to load from PowerBi. There are 5 visuals on the page and using profiler each query takes 20+ seconds to load. If I suck out the DAX and execute with DAX Studio (using clear cache) the queries take less than 2 seconds.
It seems like the gateway slows down when there are more than a couple of queries executing at once. Does the Gateway multitask and run the queries in parallel or sequentially?
Are there any tweaks I can make to the gateway to speed up the queries? Our on-premise server has 32 CPU's and 760GB of fast memory.
Join us in Barcelona for FabCon and SQLCon, the Fabric, Power BI, SQL, and AI community event. Save €200 with code FABCMTY200.