Forum Discussion
Creating Live Dashboard using Change detection
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 ...
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