excel refresh with power bi connection

Question

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?

v-sihou-msft · Answer

rnoone
&nbsp;
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.
&nbsp;

&nbsp;
Regards,
&nbsp;
Regards,
&nbsp;
&nbsp;

karaoan · Answer

Simon, I am facing a similar problem as&nbsp;@rnoone&nbsp;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 &nbsp;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?&nbsp;Edit: Came across this as a feature request and it seems it is planned:&nbsp;https://ideas.powerbi.com/forums/265200-power-bi-ideas/suggestions/13690905-allow-excel-online-to-connect-to-a-power-bi-data-s#comments&nbsp;Martin&nbsp;Take you Power BI project to the next level --&gt; http://Powerbiexperts.com.au

Forum Discussion

excel refresh with power bi connection

2 Replies

Related content

Scheduling Excel Workbook Connection (Dataflow) Refresh

Auto Refresh Power Query in Excel with Web Content Connection

Fabric Warehouse Connection to Excel

Fabric Warehouse Connection in Excel

Auto Refresh Excel File Connected to Semantic Model with Analyze in Excel