Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
Hi everyone...
I created an, "Analyze in Excel" connection to my Power BI workspace's Usage Metrics data. I have the new usage report turned on.
After pivoting on ReportName and SectionName to return the number of page views by report, I noticed there doesn't appear to be a relationship between those two items because I am seeing SectionNames aligned to the wrong reports.
Has anyone experienced the same and was able to resolve it?
Solved! Go to Solution.
@serpiva64 I found the following information within the Usage Metrics doc Microsoft published: Note that Excel PivotTables do not support drag-and-drop aggregation of numeric fields when connecting to a Power BI dataset.
I also read a few times throughout the doc that report views and page view are collected differently.
When I connect a Power BI report directly to the Usage Metrics data set though, the section names align with the report names, so I'm going to conclude that the misalignment is due to the Excel pivot table limitation noted.
Here are the pivot table fields I'm using.
Here's an example of how the report pages (SectionNames) don't align with ReportNames. Those sections do not belong to that report.
Hi,
can you post some images in order to undestand better?
@serpiva64 I found the following information within the Usage Metrics doc Microsoft published: Note that Excel PivotTables do not support drag-and-drop aggregation of numeric fields when connecting to a Power BI dataset.
I also read a few times throughout the doc that report views and page view are collected differently.
When I connect a Power BI report directly to the Usage Metrics data set though, the section names align with the report names, so I'm going to conclude that the misalignment is due to the Excel pivot table limitation noted.
User | Count |
---|---|
98 | |
87 | |
77 | |
67 | |
63 |
User | Count |
---|---|
110 | |
95 | |
95 | |
64 | |
58 |