Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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
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.
Image source: https://whitepages.tygraph.com/2021/03/its-time-to-stop-using-power-pivot/
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.