Forum Discussion
No Table Pagination Support. Tried paginated report, but it does not work with BigQuery.
Okay, PBI does not have table level pagenation, which most popular visualization tools do have it.
So tried to work around it with Paginated Report, but there are issues:
1. Paginated report does not support BigQuery!
2. Tried to use existing Power BI datasets created using PBI desktop tool, but based on https://docs.microsoft.com/en-us/power-bi/paginated-reports/report-builder-shared-datasets:
- You can't embed paginated reports that are based on Power BI shared datasets in the "App Owns Data" scenario.
So, it seems no way out unless customize the Power BI table ...
Anyone has any ideas how to get around it.
All I am asking is paginated table !
Is this too much to ask ? 🙂
3 Replies
Hi Anonymous,
If the pagination report features not suitable for your requirement, maybe you can try to use Dax formula to achieve your requirement.
Steps:
1. Get data from bigquery connector and add index field on query editor side.
2. Create a parameter table with numeric values and use its field to create a slicer.
3. Write measure expression to use selected parameter value to filter on visual with raw table records based on index.Table.AddIndexColumn - PowerQuery M | Microsoft Docs
Applying a measure filter in Power BI - SQLBI
Regards,
Xiaoxin Sheng
HI Anonymous,
Unfortunately, current these seem not able to achieve in directquery mode.
Perhaps you can try to use composite mode and change one data table connection or duplicate one of them with import mode for further data analysis.Use composite models in Power BI Desktop - Power BI | Microsoft Docs
Use storage mode in Power BI Desktop - Power BI | Microsoft Docs
Regards,
Xiaoxin Sheng