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.
Hi all,
I am pretty new to the PowerBI topic and already ran in to some issues.
I am trying to query a quiet large amount of data from my Log Analytics Workspace - Unfortunatley I am reaching the log analytics API limitations of 64000000 bytes for a single query.
https://dev.loganalytics.io/documentation/Using-the-API/Limits
Therefore I wanted to create some kind of ForEach Loop to split my large query into smaller ones and append all the data to a new Table.
For example: If I want to query the data for the past 3 days, I would like to modify the "TimeGenerated between(.....)" Kusto expression inside the loop to query the data blockwise for maybe 4 hours and afterwards append the data to the Table. The loop should run until I queried all the data for the 3 days.
Now my questions, is this possible to do with PowerBI?
Thanks in advanced and best regards
Hi did you find a solution for this problem?
Hi @Happy_Cloud
Not quite understand your requirement, you might raise it to the support team for better advice:
https://powerbi.microsoft.com/en-us/support/
If you'd like to import the results of an Azure Monitor log query into a Power BI, you can refer to:
https://docs.microsoft.com/en-us/azure/azure-monitor/platform/powerbi
But for the 64,000,000 bytes maximum enforced by the Log Analytics API, it's also applied in power bi. you can refer to the relevant thread:
https://community.powerbi.com/t5/Desktop/Missing-data-when-querying-Log-Analytics/m-p/674109
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 |
---|---|
110 | |
94 | |
82 | |
66 | |
58 |
User | Count |
---|---|
151 | |
121 | |
104 | |
87 | |
67 |