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.

luisrh's avatar
luisrh
Responsive Resident
1 year ago

I am making some assumptions here in my answer.   If your data source is able to be accessed from within Power BI Report Server thru a database connection, the best way to do this is to use materialized views on your source.   Essentially that layer becomes your transformation layer.  Some of those views can be created through stored procedures, etc.   I assume your need is to use PBI Report server hosted on premises or at Azure or AWS.   Again, hope this was somewhat helpful.  I didn't really get a clear picture of the requirements, thus the assumptions.    

Regards.