Don't miss your chance to take the Fabric Data Engineer (DP-600) exam for FREE! Find out how by attending the DP-600 session on April 23rd (pacific time), live or on-demand.
Learn moreNext up in the FabCon + SQLCon recap series: The roadmap for Microsoft SQL and Maximizing Developer experiences in Fabric. All sessions are available on-demand after the live show. Register now
I connect a local Excel workbook to the Power BI service. I create a pivot table and a slicer and I want to make it available for consumption in the browser. But the Excel slicer will not work in Excel Online or even within Power BI because unable to refresh data connections.
Is this something that might work anytime soon?
In Power BI, when importing Excel workbook, it will load all data, other objects to filtering data will not be loaded. In this scenario, I suggest import your workbook into Power BI Desktop, create a slicer in Power BI Desktop. Then publish this .pbix onto Power BI Service.
Regards,
Regards,
Simon, I am facing a similar problem as @rnoone that it seems impossible to refresh a PBI data conecction in Excel Online. Your answer doesn't address the question if there are ways already or if it is planned to be available any time soon/ever to refresh a Power BI connection (preferably with taking into account PBI RLS!) in Excel Online?
Edit: Came across this as a feature request and it seems it is planned: https://ideas.powerbi.com/forums/265200-power-bi-ideas/suggestions/13690905-allow-excel-online-to-co...
Martin
Take you Power BI project to the next level --> http://Powerbiexperts.com.au
If you have recently started exploring Fabric, we'd love to hear how it's going. Your feedback can help with product improvements.
A new Power BI DataViz World Championship is coming this June! Don't miss out on submitting your entry.
| User | Count |
|---|---|
| 11 | |
| 11 | |
| 9 | |
| 8 | |
| 8 |
| User | Count |
|---|---|
| 30 | |
| 29 | |
| 20 | |
| 15 | |
| 15 |