How do i create a paginated report in Power BI report builder?

[Dhruv_29]

I am facing an issue while creating a paginated report on the Power BI Report builder. I am unable to generate a report with an csv data of only 500 mb despite my laptop having an 8 GB Ram. The Power BI report builder application always shutdowns while creating the report. Someone Please help regarding with the following issue.

[olgad · Accepted solution]

@Dhruv_29 Please mark the answers if they helped you resolve the issue, thank you.

[olgad]

https://learn.microsoft.com/en-us/power-bi/paginated-reports/report-builder-shared-datasets

First, upload your csv file into power bi services. 

1. In the left navigation pane, select a workspace where you want to add the data (e.g., My Workspace or a shared workspace).
2. Click the + New button at the top right and select Upload a file.
3. Choose the file type: CSV
4. Select the file and click Open.
5. Power BI Service will process the file and create a dataset.   
   Then, open your report builder and 

Add a Power BI Dataset Connection

1. In the left Report Data pane:
   • Right-click Data Sources and select Add Power BI Dataset Connection.
2. A window will appear asking you to Sign in to Power BI Service:
   • Enter your Power BI credentials.
3. Once signed in, you will see a list of workspaces containing published datasets.

---

Select the Dataset

1. Navigate to the workspace where the desired dataset is located.
2. Select the specific dataset you want to connect to, and click OK.
   • This creates a connection to the dataset and adds it to the Data Sources section.

---

 Add a Dataset in the Report

1. In the Report Data pane, right-click Datasets and choose Add Dataset.

[v-sgandrathi]

Hi @Dhruv_29,

Thanks for connecting with the Microsoft Fabric Community Forum.

I trust the @olgad response is accurate and will address your issue.

In addition to that if you want to import data directly to power BI report Builder you can split the data into smaller chunks and import them, then you can be able to generate the paginated reports successfully.
If you have any further questions or updates regarding your issue, feel free to ask, and we will look into that.

Please Accept as solution If this post clears your issue and a Kudos would be appreciated.

Best Regards,
Sahasra.

[olgad]

Instead of importing the CSV directly into Power BI Report Builder:

• Load the data into a Power BI Dataset:

  • Use Power BI Desktop to create a dataset from your CSV file. Load and transform the data as needed, and publish it to the Power BI Service.
  • Connect Power BI Report Builder to the published dataset, reducing the resource load on your local machine.

[Dhruv_29]

Thank you for helping me out with this issue but could you please let me know exactly how i could upload a power BI dataset in the power BI report builder?

It would be very much appreciated.

[v-sgandrathi]

Hi @Dhruv_29,

Here I'm providing the snapshots of how to upload dataset in Report builder..

In Report builder go to Data pane and click datasource.

Then select PowerBI semantic model and click Build.

Here you can see the workspaces where you can select the workspace and dataset aslo

Click select and your dataset will reflect in Report builder.

If this post helps, please give us Kudos and consider Accept it as a solution to help the other members find it more easily.

Regards,
Sahasra.

[v-sgandrathi]

Hi @Dhruv_29,

May I ask if you have gotten this issue resolved?

If it is solved, please mark the helpful reply or share your solution and accept it as solution, it will be helpful for other members of the community who have similar problems as yours to solve it faster.

Regards,
Sahasra.