Power BI Paginated Report Builder

[Delrameau]

Hi,

I'm trying to create a paginated report with Power BI Report Builder, but I'm having l lot trouble loading it.

Power BI report builder takes a really long time to load when I click run, and when the report finished loading all of the values in the report's visualizations are blank. 

Does anyone know what is causing this to happen?

[himuengg]

Hi,

I pulled one model from PBI desktop into PBI Report Builder and then ran this DAX TOTALMTD(SUM('FACT_TABLE'[Sales]),'DATE_TABLE'[Date]) and it worked as expected but when I tried to calculated MTD for same period last year with SAMEPERIODLASTYEAR DAX command, its not giving values. I used TOTALMTD(SUM('FACT_TABLE'[Sales]),SAMEPERIODLASTYEAR('DATE_TABLE'[Date])). Can somebody help please?

[v-yuta-msft]

@Delrameau ,

Please refer to limitations and considerations below:

Here are some other features that aren't supported in the initial release:

• Pinning report pages or visuals to Power BI dashboards. You can still pin visualizations to a Power BI dashboard from an on-premises paginated report on a Power BI Report Server or Reporting Services report server. See Pin Reporting Services items to Power BI dashboards for more information.
• Interactive features such as document maps and show/hide buttons.
• Subreports and drillthrough reports.
• Shared data sources and shared datasets.
• Visuals from Power BI reports.

Community Support Team _ Jimmy Tao

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[Delrameau]

@v-yuta-msft,

What do you mean by shared datasets?

I am able to query the dataset, create paremeters, etc. I've pretty much build the entire report. 

The only problem is that the report won't show any values besides the column header when I click run. 

It also takes a really long time to load after I click run, and I don't know why. 

I don't know what to do.

---

@v-yuta-msft wrote:

@Delrameau ,

Please refer to limitations and considerations below:

Here are some other features that aren't supported in the initial release:

• Pinning report pages or visuals to Power BI dashboards. You can still pin visualizations to a Power BI dashboard from an on-premises paginated report on a Power BI Report Server or Reporting Services report server. See Pin Reporting Services items to Power BI dashboards for more information.
• Interactive features such as document maps and show/hide buttons.
• Subreports and drillthrough reports.
• Shared data sources and shared datasets.
• Visuals from Power BI reports.

Community Support Team _ Jimmy Tao

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

---

[nirvana_moksh]

@Delrameau - I would clear the columns and calc. columns and then just drop one field from the data set and then try running it and see if it even renders that column or not on the Run.

[Delrameau]

I made a dummy table in a csv file to test report builder. Do you know how to connect report builder to local files? 

Can you show me a guide to do this?

Thank you. 

Would it work if I typed the data here?

[Delrameau]

bump

[Delrameau]

@nirvana_moksh 

Thanks

This a a good trouble-shooting idea.