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

Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started

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

July 2024 Power BI Update

Power BI Monthly Update - July 2024

Check out the July 2024 Power BI update to learn about new features.

July Newsletter

Fabric Community Update - July 2024

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