Forum Discussion
Missing "Show data point as a table" in Power BI Service for a map visual
I have a report created in Power BI Desktop and published to the Power BI Service. The report contains a Bing map visual with bubbles sized by the number of wagons at various stations.
Issue:
In Power BI Desktop, when I right-click on a bubble, I see and can use the option "Show data point as a table."
However, in the Power BI Service (web version), this same right-click option is missing. The context menu does not show it at all.
Steps to Replicate:
Publish the report with the map visual to Power BI Service.
Open the report in a web browser.
Right-click on a bubble on the map.
Observe that the option "Show data point as a table" is absent.
Additional Context:
I have confirmed that this is not a report structure issue. When I download the same report from the service and open it in Power BI Desktop, the right-click option works correctly. I've also been told that this option was available in the service for this report in the past.
Question:
What could be the cause of this discrepancy, and is there a solution or a workaround to provide this functionality to web users? Is this a known limitation or a recent change in the service?
Hi olpololya
Common causes for this issue can contains:
Measures vs columns : The option only works when the visual’s values (e.g. bubble size) are based on columns, not measures. If your map uses a measure for size/count, the Service will hide that option.
Export/data settings: Tenant admin can disable Export data / Show data as table for users.
Report setting “Allow end users to export summarize data” can also block it.
Could you please try to check :
In Desktop, check the map visual: If Size (or any value) is a measure, replace it with a column and republish.
In Desktop: File > Options > Current file > Report settings > ensure “Allow end users to export summarize data” is ON, then republish.
Or
Ask your admin to confirm tenant settings for Export data / Show data as table are enabled for your users.
Do let us know if this works.🌟 I hope this solution helps you unlock your Power BI potential! If you found it helpful, click 'Mark as Solution' to guide others toward the answers they need.
💡 Love the effort? Drop the kudos! Your appreciation fuels community spirit and innovation.
🎖 As a proud SuperUser and Microsoft Partner, we’re here to empower your data journey and the Power BI Community at large.
🔗 Curious to explore more? [Discover here].
Let’s keep building smarter solutions together!
4 Replies
Hi olpololya
Common causes for this issue can contains:
Measures vs columns : The option only works when the visual’s values (e.g. bubble size) are based on columns, not measures. If your map uses a measure for size/count, the Service will hide that option.
Export/data settings: Tenant admin can disable Export data / Show data as table for users.
Report setting “Allow end users to export summarize data” can also block it.
Could you please try to check :
In Desktop, check the map visual: If Size (or any value) is a measure, replace it with a column and republish.
In Desktop: File > Options > Current file > Report settings > ensure “Allow end users to export summarize data” is ON, then republish.
Or
Ask your admin to confirm tenant settings for Export data / Show data as table are enabled for your users.
Do let us know if this works.🌟 I hope this solution helps you unlock your Power BI potential! If you found it helpful, click 'Mark as Solution' to guide others toward the answers they need.
💡 Love the effort? Drop the kudos! Your appreciation fuels community spirit and innovation.
🎖 As a proud SuperUser and Microsoft Partner, we’re here to empower your data journey and the Power BI Community at large.
🔗 Curious to explore more? [Discover here].
Let’s keep building smarter solutions together!
Thankyou grazitti_sapna for Addressing the issue.
Hi olpololya ,Thank you for reaching out to Microsoft Fabric Community Forum,
As we haven’t heard back from you, we wanted to kindly follow up to check if the solution provided for the issue worked? or Let us know if you need any further assistance?
Regards,Chaithanya
Thankyou grazitti_sapna for Addressing the issue.
Hi @olpololya ,Thank you for reaching out to Microsoft Fabric Community Forum,
As we haven’t heard back from you, we wanted to kindly follow up to check if the solution provided for the issue worked? or Let us know if you need any further assistance?
Regards,Chaithanya
As far as I know, "Show data point as a table" isn't supported consistently across all visuals in the Power BI Service, even if it works in Power BI Desktop. The Service and Desktop don't always expose the same context menu options, especially for map visuals.
If this worked previously for the same report, it's worth checking whether anything changed recently (for example, the visual type, tenant settings, or a recent Service update). If nothing in the report has changed, it could also be a regression in the Power BI Service.
As a workaround, you could consider using Drillthrough, a tooltip page, or a table visual filtered by the map selection, depending on the user experience you're after.
I'm curious whether others can still reproduce this in the current Service version.
