Forum Discussion

tmhalila's avatar
tmhalila
Resolver II
1 year ago
Solved

How to create paginated report using Power BI dataset optimized for report server

Hi everyone, I am required to create a report that can be exported in either CSV, Excel, or PDF. I usually achieve this by using paginated reports where the source is an external database.   For t...
"Need Help"
  • tmhalila's avatar
    tmhalila
    1 year ago

    Hi Anonymous 

    Thank you for the solution! However, our organization doesn't use Power BI Service at all. I discovered from Microsoft's documentation that the Power BI Report server can't utilize the Power BI dataset. Therefore, I have decided to redo all the transformations in the database using SQL.

Ankur04's avatar
Ankur04
Resolver II
1 year ago

Hi tmhalila ,

 

I read your response below regarding your organisation does not use Power BI service. If you have this requirement you can consider involving SSAS model and then create Power BI report as well as Paginaged report from SSAS model. this will help you reduce the efforts as well as one model can be used for multiple purpose.

 

Thanks,

 

Ankur