No Table Pagination Support. Tried paginated report, but it does not work with BigQuery.

[Anonymous]

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 ?  🙂

[Anonymous]

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

[Anonymous]

Hi Xiaoxin,

Is this solution working with "DirectQuery" mode?  I had problem before while adding index column into a table which uses "DirectQuery" mode.  At the time to add index column in Power Query Editor, it asks to switch all tables to Import mode.

Thanks,

Yong

[Anonymous]

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