Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started

Reply
PowerDinosaur
Frequent Visitor

Paginated reports - stored procedures

Hi guys!

 

I am currently working in an enviroment with:

- PBRS

-import mode

- and an ODBC connector to a database that I'm not allowed to name.

The problem is that currently we have to load tables with 20-100 million rows of data and sometimes we have columns where 1 cell contains ~20 pages long strings. We were looking for solutions (unfortunatelly Direct Query is not an option with this database and connector) to make the import faster. I have come accross paginated reports and stored procedures. How is this really works with import mode ? The user can choose from parameters and the paginated report only imports the data that is filtered ? Or it imports firstly everything?

 

Thank you for your help in advance and have a nice day!

1 ACCEPTED SOLUTION
d_gosbell
Super User
Super User


@PowerDinosaur wrote:

I have come accross paginated reports and stored procedures. How is this really works with import mode ?


It does not work with import mode at all.

 

PBIRS supports 2 different types of reports:

  • Power BI - PBIX based reports 
  • Paginated reports

They are different styles of reports that are not really connected to each other.

 

Power BI reports are better suited to aggregate style reports where you a doing group bys and filters and are doing sum/avg/min/max over numeric columns.

 

Paginated reports are better suited to fixed output where you might have specific tables with a fixed list of columns and maybe some simple charting. If you have stored procedures where you want to pass in some parameter values and then produce the same fixed output each time then paginated reports are a good solution. The only downside is that they are not quite as easy to build and there can be a bit of a learning curve.

View solution in original post

2 REPLIES 2
v-henryk-mstf
Community Support
Community Support

Hi @PowerDinosaur ,

 

Whether the advice given by @d_gosbell  has solved your confusion, if the problem has been solved you can mark the reply for the standard answer to help the other members find it more quickly. If not, please point it out.


Looking forward to your feedback.


Best Regards,
Henry

d_gosbell
Super User
Super User


@PowerDinosaur wrote:

I have come accross paginated reports and stored procedures. How is this really works with import mode ?


It does not work with import mode at all.

 

PBIRS supports 2 different types of reports:

  • Power BI - PBIX based reports 
  • Paginated reports

They are different styles of reports that are not really connected to each other.

 

Power BI reports are better suited to aggregate style reports where you a doing group bys and filters and are doing sum/avg/min/max over numeric columns.

 

Paginated reports are better suited to fixed output where you might have specific tables with a fixed list of columns and maybe some simple charting. If you have stored procedures where you want to pass in some parameter values and then produce the same fixed output each time then paginated reports are a good solution. The only downside is that they are not quite as easy to build and there can be a bit of a learning curve.

Helpful resources

Announcements
July 2024 Power BI Update

Power BI Monthly Update - July 2024

Check out the July 2024 Power BI update to learn about new features.

PBI_Carousel_NL_June

Fabric Community Update - June 2024

Get the latest Fabric updates from Build 2024, key Skills Challenge voucher deadlines, top blogs, forum posts, and product ideas.

Top Solution Authors