Replace Excel Workbook Dataset in power bi via Powershell

[Anonymous]

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!

[v-lili6-msft]

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,

Lin