One of the ways we're using Power BI is to export data from Azure Log Analytics (to M query) and use as a dataset to build reports. We then use a Premium workspace/app to share across the enterprise. We refresh the dataset the maximum allowed times for a Premium workspace: 48 times--or twice an hour. This works pretty well for us in general. However, we do have some use cases that require more frequent refreshes (and, as a result, more refreshes per day). I looked into using PowerShell and the Power BI REST API as potential options, but discovered that they suffer from the same refresh limitations: 8 for standard workspace, 48 for premium. We'd love to be able to either use some sort of streaming mechanism for Azure Log Analytics > Power BI, or more frequent refreshes so that we're closer to real time reports.
3 Comments
- Would love this, we collect performance stats from servers in to Azure Log Analytics. The dashboard in OMS isn't great and have developed a Power BI Dashboard, only problem is the data isn't live enough.
- We have the same issue, I create some dashboard for our client(which down the line will make them license of Power BI) but without auto refresh of Azure log analytics .... doesn't make sense to sign them up
- Status added:Needs Votes
