cancel
Showing results for 
Search instead for 
Did you mean: 

Fabric is Generally Available. Browse Fabric Presentations. Work towards your Fabric certification with the Cloud Skills Challenge.

Reply
db042190
Responsive Resident
Responsive Resident

i dont see an option to pin a paginated report to my dashboard

hi.  i created a dashboard and had no problem pinning my matrix based viz to it.  but when i went to pin my paginated report to the same dashboard, there doesnt even seem to be an option to do so.  i did click edit in report builder but got some weird message saying i hadnt downloaded the latest rb which i dont believe to be true but i gave up on that path.  this is where i got the idea this is possible...https://community.fabric.microsoft.com/t5/Service/can-paginated-reports-be-mixed-with-standard-pbi-v...  

couldntgetthistodashboard.png

7 REPLIES 7
db042190
Responsive Resident
Responsive Resident

not sure i understand Ibendlin.  By PBI standard I assume you mean non paginated visuals (eg matrix etc).  But the reason its paginated in the first place is because there is no way to develop this particular kind of report format any other way.  And can you explain "pin the entire page"?  Its the only report on the page.  I didnt see an option to pin an entire page.

Instead of (or after) using Report Builder you can choose to use Power BI Desktop and use a Paginated Reports visual inside a "standard"  Power BI report page.

 

lbendlin_0-1686657996117.png

 

db042190
Responsive Resident
Responsive Resident

sorry, i know i'm being dumb but here is a picture of the 2 dead ends i encountered in trying to do what you say.  In the first I am in the desktop locally hoping to point at my existing rdl created from rb.  In the second (just following the instruction shown in the first attempt) I am in the service hoping to add a paginated report i already have published.  I'm lost.  Is it possible that the only way I'll get away with this is to create/reuse pbi like (not rb/ssrs like) datasets? 

paginatedfromdesktop.pngpaginatedfromservice.png

 

 

Continue with the first picture. Sign in to Power BI as instructed.

db042190
Responsive Resident
Responsive Resident

this was pretty bizarre.  The best I can tell, 1) forget about adding a paginated report visual locally in desktop.  You have to be in the service and there is nothing gained by starting up the local instance of pbi desktop.  To me this means your rdl better be published already.  2)  in order to create a visual (paginated via report builder is something else and a different choice) in a report, you have to create or reuse a dataset in the service.   The weird thing is that rdls already have their own ssrs like datasets.   Nonetheless the dataset you choose seems like pbi wants to associate it with your report parameters.  Which would be weird if you dont have any report parameters.  If you choose an existing service dataset, MS automatically subscribes (at least it says it is doing so) you to a free 60 day trial of the "for pay" flavor of pbi.  3) ultimately you "connect" to an existing paginated report from the paginated report design visual.  And you can pin from there.  4) i dont know if this is always true but when i then ran the dashboard, the paginated tile just kept showing the spinning image.  Only when i clicked on it was i redirected to an immediate rendering of my paginated report. 

 

This is all pretty weird from a lot of angles.

when you click on a dashboard tile you will be taken to the underlying report page.  Bit of a red herring.

 

The spinny thing is likely the dashboard trying to re-render your paginated report and you being impatient 🙂

lbendlin
Super User
Super User

Quirky workaround: instead of pinning the paginated report put the paginated report in a visual in Power BI standard and pin it from there.  Or pin the entire page.

Helpful resources

Announcements
PBI November 2023 Update Carousel

Power BI Monthly Update - November 2023

Check out the November 2023 Power BI update to learn about new features.

Community News

Fabric Community News unified experience

Read the latest Fabric Community announcements, including updates on Power BI, Synapse, Data Factory and Data Activator.

Dashboard in a day with date

Exclusive opportunity for Women!

Join us for a free, hands-on Microsoft workshop led by women trainers for women where you will learn how to build a Dashboard in a Day!

Power BI Fabric Summit Carousel

The largest Power BI and Fabric virtual conference

130+ sessions, 130+ speakers, Product managers, MVPs, and experts. All about Power BI and Fabric. Attend online or watch the recordings.

Top Solution Authors