Showing results for 
Search instead for 
Did you mean: 

Fabric is Generally Available. Browse Fabric Presentations. Work towards your Fabric certification with the Cloud Skills Challenge.

Not applicable

Replace Excel Workbook Dataset in power bi via Powershell

Hi All,


I'm hoping to get some help around replacing an excel workbook in Power BI online via PowerShell. Right now I can go into Power BI online and replace a current Excel workbook data source by going through these steps: Create -> Dataset -> Files -> Local File -> (select file) -> replace. I want to be able to do all this via PowerShell so the process can be automated. 

I already have code to refresh data sources, so I have code to establish the connection to my workspace, just not to do this replace step. 


For some context we already have a process in place that refreshes this excel file and creates a user friendly copy in our network drive. The way the graphs are all laid out is the way everyone prefers it and the data is in a very complex state so they're not looking to transition this report to Power BI, just display it there as an excel graph so it can live with all the other reports. 


Please let me know if I can clarify anything, and thank you in advance for all your help!

Community Support
Community Support

hi, @Anonymous 

According to my knowledge, I'm afraid it may difficult achieve in power bi for now.

For your case, I would suggest you create a support ticket in Power BI Support to get further help.


Best Regards,


Community Support Team _ Lin
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Helpful resources

PBI November 2023 Update Carousel

Power BI Monthly Update - November 2023

Check out the November 2023 Power BI update to learn about new features.

Community News

Fabric Community News unified experience

Read the latest Fabric Community announcements, including updates on Power BI, Synapse, Data Factory and Data Activator.

Power BI Fabric Summit Carousel

The largest Power BI and Fabric virtual conference

130+ sessions, 130+ speakers, Product managers, MVPs, and experts. All about Power BI and Fabric. Attend online or watch the recordings.

Top Solution Authors
Top Kudoed Authors