Create power bi dataset by using powershell

[avadhuts123]

I have to create power bi dataset by using powershell script. My datasource is excel file which is in OneDrive.
Or is there any way to create dataset by other kind of scripting?

[aj1973]

Hi @avadhuts123 

You have an Excel file located in OneDrive, why don't you use Power BI desktop to create your Dataset? Why Powershell?

[avadhuts123]

Hi @aj1973 

In my project requirement I have to create datasets outside the power bi desktop. That's why I need any kind of scripting, which will create dataset by using OneDrive excel as datasource.

[aj1973 · Accepted solution]

Well, you better look for solution in Powershell community then

https://techcommunity.microsoft.com/t5/powershell/ct-p/WindowsPowerShell