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.
Objective:
The overall objective is to export data completely after query ran successfully.
Following scenario:
1. Ran query on AppInsights. It worked fine, resulted in data (say around 4L rows)
2. Exported same query to Power BI query using appInsights export tool
3. In PowerBI Desktop, pasted same query in Power Query advanced editor
4. It resulted in exporting partial data (say around 2.5L rows)
Points noted:
I've checked there is no issue of row limits/column limits and no storage issue (enough memory is available to accomodate data)
I've tried refreshing the data as well multiple times, the count increases but complete data is not getting exported .
I am looking for advice.
Thanks in advance.
Have you tried using the AzureDataExplorer data connector, instead of using the export to query option? To do this, go to Get Data (or New Sources) -> More... and search for "Azure Data Explorer (Kusto)". This way of loading the data is more supported.
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 |
---|---|
102 | |
53 | |
21 | |
12 | |
12 |