Skip to main content
cancel
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

Reply
Anonymous
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!

1 REPLY 1
v-lili6-msft
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,

Lin

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

Announcements
Europe Fabric Conference

Europe’s largest Microsoft Fabric Community Conference

Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.

Power BI Carousel June 2024

Power BI Monthly Update - June 2024

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

RTI Forums Carousel3

New forum boards available in Real-Time Intelligence.

Ask questions in Eventhouse and KQL, Eventstream, and Reflex.

Top Solution Authors