cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
michalpoterek
Frequent Visitor

Cant print report with selected filters Power BI Embedded

Hi, We are using Power Bi Embedded. We developed webapp where we can manage and present reports for our customers. It's multi tenant app.  Printing  is possible only for standard/default/stored  filter values which are set during report creation.

 

How (what kind of function can be used) to print/export report  with current filter values  (similar like it is done in Power Bi service)?

Is there is any chance to have possibility to print/export custom charts created in R or Py?  

 

I found out if I use browser option print it printing with current filter values and  printing R and Py charts but  it print only one Tab from report (this one which is selected during pressing print).

 

I will be appreciated for help as our developers cannot find solution for that.

6 REPLIES 6
v-luwang-msft
Community Support
Community Support

Hi @michalpoterek ,

It is a current limitation.  Try using page level bookmarks instead.

And you could these filters into the URL string as the url filter document mentions.

Reports - Export To File#exportfilter 

Filter a report using query string parameters in the URL 

 

And the below similar question ,somebody provided a way  to got it working with Identities and Roles.Refer the similar question:

Export to file - Power BI Report with Filters / Parameters

Export report with multiple filters as parameter

 

 

Did I answer your question? Mark my post as a solution!


Best Regards

Lucien

Dear Sir, I'm appreciated your answer.  I would like to place here my comment -  Power BI it's a great tool but does not have the possibility to print it in the way which customers see it - that's a real shame. That's really basic functionality and I cannot imagine how product managers allow issuing this kind of product. It's like having excel where you can print a grid table without text and its content!

Hi @michalpoterek ,

I find  a preview feature about export report to file(And The report you're exporting must reside on a Premium or Embedded capacity),it may be want you want,It depends on your actual application environment and situation, you can refer to it and try it. The changes described in this section will be deployed to Premium Gen2 and Embedded Gen2 capacities in stages, over the following weeks. If these changes are not yet implemented in your Gen2 capacity, wait for the deployment to reach it.

 

Before using the API, verify that the following admin tenant settings are enabled:

  • Export reports as PowerPoint presentations or PDF documents - Enabled by default.
  • Export reports as image files - Required only for .png and disabled by default.

This section describes the operation of the following supported features:

Bookmarks can be used to save a report in a specific configuration, including applied filters and the state of the report's visuals. You can use the exportToFile API to programmatically export a report's bookmark, in two ways.

Using reportLevelFilters in PowerBIReportExportConfiguration, you can export a report in a filtered condition.

To export a filtered report, insert the URL query string parameters you want to use as your filter, to ExportFilter. When you enter the string, you must remove the ?filter= part of the URL query parameter.

The table below includes a few syntax examples of strings you can pass to ExportFilter.

 

And it with the below limitations:

vluwangmsft_0-1642643397159.png

To learn more details ,refer:

https://docs.microsoft.com/en-us/power-bi/developer/embedded/export-to 

 

 

Best Regards

Lucien

Dear Lucien, thank you for the information.  In my case, I would like to print reports in which filters/slicers are set by the user once the user is using them. So I guess first you need to get report filters/slicers state and then pass the state of these filters once we would like to trigger report print. How it's possible to get the reports filter/slicer state once some user browses that report?

michalpoterek
Frequent Visitor

Dear Sir, we have created a web application which allows people to log in and give them access to online reports.  We are using Microsoft Power BI Embedded for this purpose.   In the web application, we have a print button and when we use it and we print reports it's not stored filter/slicer settings so report in print with default slicers/filter settings.  We need to have a possibility to print it exactly how a customer sees it (with all slicers/filters).

AnkitKukreja
Super User
Super User

Hi @michalpoterek 

Are you taking about printing the visuals in Desktop? Then it's not possible as far as I know.
It is possible in service only using the export option

 

AnkitKukreja_0-1642175799348.png

 

 

 

Thanks,
Ankit Kukreja
www.linkedin.com/in/ankit-kukreja1904

Helpful resources

Announcements
Power BI Show Episode 10 Recap

The Power BI Community Show

Watch the playback when Amit Chandak, a Power BI Super User, demos how to use Field Parameters to make reports more dynamic.

Health and Life Sciences Power BI User Group

Health and Life Sciences Power BI User Group

Power BI specialists at Microsoft have created a community user group where customers in the provider, payor, pharma, health solutions, and life science industries can collaborate.

Ignite 2022

What's Next at Microsoft Ignite 2022

Explore the latest innovations, learn from product experts and partners, level up your skillset, and create connections from around the world.

Top Solution Authors
Top Kudoed Authors