Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
Regarding Azure Analysis Service, is it possible to obtain the data processing in real time and put in power bi?
I usually use SQL Server Profiler to monitor who is processing and what is processing.
But I wanted to create a report with this data in real time.
I have already investigated and I can create a streaming dataset with Stream Analytics in Portal Azure, but I don't know the query that can fetch this data.
Any suggestion ?
Hey,
you might consider to configure SQL Server Profiler to put the data into atable on Azure SQL DB:
Then you can use Power BI to connect to Azure SQL DB.
Maybe you can consider to use DMVs directly: https://docs.microsoft.com/en-us/analysis-services/instances/use-dynamic-management-views-dmvs-to-mo...
Regards,
Tom
If you want use current data for you report you must use direct query, but i haven't experience using direct query with azure, maybe this can help you:
https://docs.microsoft.com/en-us/power-bi/service-azure-sql-database-with-direct-connect
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
111 | |
94 | |
82 | |
66 | |
59 |
User | Count |
---|---|
151 | |
121 | |
104 | |
87 | |
67 |