Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
Overview: Import Azure Monitor Log data into PowerBI Desktop.
Problem Statement: Importing Azure Monitor Log data into Power BI Desktop result into wrong number of resultset. There is a difference in number records in Azure portal and Power BI Desktop.
Process: Following steps are followed to get the data from azure portal into PowerBI Desktop
Step 2 – Find Out How Many Records Available (1,149,984)
Step 3 (Run Query)
Step 4 (Export M Query from Azure Portal )
Step 5 : In PowerBI Desktop use Blank query option to get the data
Step 6: Copy Paste the exported M Query into PowerBI and Click on Done.
Step 7 : Apply changes and click OK.
Step 8 : Create visual to get count of rows
Issue – Number of Records are different in both Azure and Power BI Desktop.
Hi @deepakb18 ,
In your scenario, I would suggest you opening a ticket at https://powerbi.microsoft.com/en-us/support/. Please follow the following steps:
Best Regards,
Teige
User | Count |
---|---|
125 | |
106 | |
99 | |
63 | |
62 |
User | Count |
---|---|
135 | |
116 | |
101 | |
71 | |
61 |