Forum Discussion

cte_crest's avatar
cte_crest
Icon for Helper I rankHelper I
6 years ago

Count mismatch in the data imported from Azure log analytics workspace through blank query

Hi,  I am using exported Power query in the Blank Query option of data collection to import the data from Azure Log Analytics Workspace. I am publishing this report to the Power BI service.   When...
Need Help
cte_crest's avatar
cte_crest
Icon for Helper I rankHelper I
6 years ago

v-diye-msft 

Actually I am respecting all the API limitations. In fact, the payload from the response is just 5 MB (vs 60 MB limit).

 

In addition, I am noticing a weird behaviour. If the count on azure workspace is 82647, then it's fetching 78310 in Power BI. If the count in azure workspace is 105k, then around 95k records are fetched. 

 

So, why am I experiencing these inconsistencies? Are there any other limitations also?

  • jim123211's avatar
    jim123211
    New Member
    2 years ago

    I encountered the same problem. Have you figured out a solution?