Forum Discussion
Pivot table (like excel) dashboard in Power BI?
End user is using excel pivot tables for dashboard so that he can dynamically select fields and rearrange the views. Now we are developing web based application and he wanted the exact same flexibility available in dashboard.
We are considering using power bi and have few question around it.
Primary information indicates exact same pivote functionality is yet not available. I may be incorrect hence wanted to understand specifics on how to make it happen so that end user can select the fields at runtime in view.
Other question is do we need to have server version of power bi if we are hosting an application.
You might have got that I am new to power bi.
Appreciate your inputs.
3 Replies
tanneraAdvocate II
1. Use matix vizualisation in PowerBI, it is the closest to the Pivot Table. Slicer visualization must be added separetely.
2. Embedded requires a Power BI Premium license (min. $5000 per month).
v-qiuyu-msftCommunity Support
Hi Sandeeepb,
1. Primary information indicates exact same pivote functionality is yet not available. I may be incorrect hence wanted to understand specifics on how to make it happen so that end user can select the fields at runtime in view.
In Power BI service, we can get data from Excel workbook use Connect, Manage, and View Excel in Power BI option, we can pin a range from the Excel to a dashboard, then share the dashboard with other users. They can interact with Excel workbook in Power BI service(select/remove fields from PowerPivot table/chart), but your colleagues won't be able to pin additional tiles from that workbook, or make changes to the Excel workbook from Power BI. See:
Refresh a dataset created from an Excel workbook on OneDrive, or SharePoint Online
Pin a tile to a Power BI dashboard from Excel
Share a dashboard that links to an Excel file in OneDrive
2. Other question is do we need to have server version of power bi if we are hosting an application.
This is a question related to Power BI developer. You can go through this article to know Embedding with Power BI, if you still have question, you can post a thread in Developer forum.
Best Regards,
QiuyunYu
PBIdashboardsPost Patron
The accepted solution is partially correct, but the landscape has changed significantly since 2017. For the specific requirement of end-users selecting fields at runtime in a published report (without Premium or Embedded), there's now a practical option:
Flexa Tables on AppSource adds true drag-and-drop pivot behavior to a published Power BI report users can swap rows/columns, add variance columns, and restructure the layout themselves in Power BI Service. No Premium license required, works with standard Pro licenses.
For the embedded web app scenario: Flexa Tables works with Power BI Embedded as long as the visual is added to the report in Desktop first. The end-user pivot interaction is preserved in the embedded view.
Free trial