Creating Live Dashboard using Change detection

[Anonymous]

Hello All,

Greetings!

I'm trying to create a Live Dashboard that I'm going to get embedded on a website. The source of the data is SQL tables and I'm fetching the data into the dashboard using a Direct Query connection and SQL table function. Even though the number of rows is less than 1000 and 8 columns it is taking a lot of time to fetch the data into the dashboard whenever a slicer option is selected. 

Can someone please guide me on how to make this work faster? 

Thanks in advance

Creating a live dashboard using SQL data 

[amitchandak]

@Anonymous , If it slow and direct query, we need use performance analyze to find time taking query and try fix it. It can be, add numeric join column, Create an index etc

https://docs.microsoft.com/en-us/power-bi/create-reports/desktop-performance-analyzer

You can use SQL profiler if needed

Power BI Premium - XMLA Endpoint - Using SQL Server profiler: https://youtu.be/Xz83LBgl0Cs