Forum Discussion
Use pbix model in Paginated Report
shyammayhs : Please see my response below
If the .pbix dataset has multiple tables, measures etc. How do I approach this? because in Paginated reports, the query was loading the data as one table?
You can connect to PowerBI Dataset and all the tables that are available on PowerBI dataset will be available for you in the paginated report through 'Report builder'. You can pick and choose what you want in your paginated reports. You can also add any additional measure or columns if you want or you can simply use all the measures and column that get imported from dataset.
If you have multiple tables in your PowerBI Dataset, all of them will be available for you (see the pic below)
is this okay to do? and how is the data model managed then?
The data model (Dataset) can still be maintained using Power BI Desktop to keep the source consistent. However you will have flexibility to add certain things using report builder as well. In short, you can simply maintian using Power BI Desktop which will support for Power BI report and Paginated Report.
If this post helps, then please consider Accepting it as the solution, Give Kudos to motivate the contributors.
shyammayhs : Please see my response below
If the .pbix dataset has multiple tables, measures etc. How do I approach this? because in Paginated reports, the query was loading the data as one table?
You can connect to PowerBI Dataset and all the tables that are available on PowerBI dataset will be available for you in the paginated report through 'Report builder'. You can pick and choose what you want in your paginated reports. You can also add any additional measure or columns if you want or you can simply use all the measures and column that get imported from dataset.
If you have multiple tables in your PowerBI Dataset, all of them will be available for you (see the pic below)
is this okay to do? and how is the data model managed then?
The data model (Dataset) can still be maintained using Power BI Desktop to keep the source consistent. However you will have flexibility to add certain things using report builder as well. In short, you can simply maintian using Power BI Desktop which will support for Power BI report and Paginated Report.
If this post helps, then please consider Accepting it as the solution, Give Kudos to motivate the contributors.
Thanks ponnusamy I will have a look into your solution and let you know if it worked for me.