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

Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.

Reply
Anonymous
Not applicable

Passing an Parameter from BI to Excel

HI Team, 


I want to pass a parameter from power bi service to excel as url ,so whatever i filter in power bi service same result should get reflect in excel.
I tried connecting excel with Power bi dataset creating a Pivot table but its not working.

Can i anybody please helpout to crack this issue 


 

1 REPLY 1
AlexisOlson
Super User
Super User

If I'm understanding correctly, I don't think this is possible (at least not without crazy workarounds).

 

You can connect Excel to an online Power BI dataset and create a pivot table based on that dataset. However, the only thing that will change the Excel pivot table is changing the dataset itself, not any slicers or filters you use in a Power BI report connected to the same dataset.

AlexisOlson_1-1659150689028.png

Image source: https://whitepages.tygraph.com/2021/03/its-time-to-stop-using-power-pivot/

Helpful resources

Announcements
LearnSurvey

Fabric certifications survey

Certification feedback opportunity for the community.

April Fabric Community Update

Fabric Community Update - April 2024

Find out what's new and trending in the Fabric Community.

Top Solution Authors