Forum Discussion
How to create paginated report using Power BI dataset optimized for report server
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.
Hi, tmhalila
You can start by publishing a report with a lot of transformations in Power Query to the Power BI service.
Then open Power BI Report Builder. Sign in to your Power BI account. In the report data pane, select New > Power BI semantic model connection. Search for and select the Power BI dataset you want to use.
Use Report Builder to design your reports. You can add elements such as tables, matrices, charts, etc., as needed.
Once you've designed your report, you can export it directly from Report Builder to a Lux, Exel, or Pudfu format.
Or publish to a Power BI report server.
You can learn more from the following link:
Create a paginated report based on a Power BI shared dataset - Power BI | Microsoft Learn
How to Get Your Question Answered Quickly
Best Regards
Yongkang Hua
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
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.