If your report uses a Live Connection to Analysis Services this is easy to do using either SQL Server Profiler, Azure Analysis Services’s diagnostic logging feature or XEvents. If you’re using a ...

Read: How to share Excel Insights with Power BI Publisher for Excel 4] Power BI: Connection to SQL Server from Excel failed When trying to import tables or data from SQL Server into Power BI ...

The ability to derive insights from diverse sources can differentiate a business. With the help of Microsoft tool, Power BI Desktop, analysts and data professionals may integrate several data sources ...

Something I do all the time when performance tuning Power BI is use SQL Server Profiler to monitor query and refresh activity. There’s a handy external tool that lets you open up Profiler with a ...

Helping & empowering business owners for over 15 years, helping them to understand how to protect own interests, build bridges to amplify joint ventures, adapting new business practices and solutions.

We use an external company to manage the hosting of our Sage 50c data on an Azure server. We want to convert the Sage files to an SQL database and connect Power BI to a mySQL server so we can ...