Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Grow your Fabric skills and prepare for the DP-600 certification exam by completing the latest Microsoft Fabric challenge.

Reply
sashokku
Regular Visitor

Automatic user selection on filter in Power BI & auto export the Power BI report as Excel

I have a Power BI report currently in Power BI desktop. The report has a filter for customer name field with 40 different customer names. Is there any way that only one customer is selected automatically from the filter and the respective report data has to be exported automatically as Excel and saved on to my local folder.

Instead of selecting customer name one by one. Is there a way that 40 customer name selected individually and the respective data has to be exported in Excel. Let me know if there are any ideas or closest workaround. Thanks in advance.

5 REPLIES 5
sashokku
Regular Visitor

Thanks everyone for the response. Its helpful.

 

Part of my requirement. If I try  to use filter a report using query string parametes in the URL. Is there any way to export that report automatically as CSV ?

 

Also, I tried other workaround to apply filter (with one customer) and use it as a bookmark. Same way I thought of boomarking all the 40 customers and subscriping it. But seems like there is no option to subscribe to bookmarks in Power BI. Any idea to export it automatically as CSV ?

@sashokku - Maybe see if Power BI Robots can do what you want because I don't see it happening with the native tools.


Follow on LinkedIn
@ me in replies or I'll lose your thread!!!
Instead of a Kudo, please vote for this idea
Become an expert!: Enterprise DNA
External Tools: MSHGQM
YouTube Channel!: Microsoft Hates Greg
Latest book!:
The Definitive Guide to Power Query (M)

DAX is easy, CALCULATE makes DAX hard...
amitchandak
Super User
Super User

@sashokku , If user export is scheduled from use login RLS enabled then it should give the report.

 

Also, see if you use this API with parameters you need

https://docs.microsoft.com/en-us/rest/api/power-bi/reports/exportreport

Greg_Deckler
Super User
Super User

@sashokku I thought there was a way to pass filters via the report URL and if that is the case, maybe you could do it via the REST API?


Follow on LinkedIn
@ me in replies or I'll lose your thread!!!
Instead of a Kudo, please vote for this idea
Become an expert!: Enterprise DNA
External Tools: MSHGQM
YouTube Channel!: Microsoft Hates Greg
Latest book!:
The Definitive Guide to Power Query (M)

DAX is easy, CALCULATE makes DAX hard...

@sashokku - Here is how to pass query string parameters to your report:

https://docs.microsoft.com/en-us/power-bi/collaborate-share/service-url-filters

 

However, unfortunately the REST API cannot be used for this from what I can see. The REST API commands for reports mainly only take the report id as a parameter, not a URL to the report. Thus, it does not look like you would be able to do that via the REST API's.

 

I also do not see a way to set your RLS role in the REST API's.

 


Follow on LinkedIn
@ me in replies or I'll lose your thread!!!
Instead of a Kudo, please vote for this idea
Become an expert!: Enterprise DNA
External Tools: MSHGQM
YouTube Channel!: Microsoft Hates Greg
Latest book!:
The Definitive Guide to Power Query (M)

DAX is easy, CALCULATE makes DAX hard...

Helpful resources

Announcements
RTI Forums Carousel3

New forum boards available in Real-Time Intelligence.

Ask questions in Eventhouse and KQL, Eventstream, and Reflex.

MayPowerBICarousel

Power BI Monthly Update - May 2024

Check out the May 2024 Power BI update to learn about new features.