Forum Discussion
Need Powershell Script to publish Power bi report to Web
Hi mahendran,
You requirement can be achieved completely because powershell module are usually be used to send data to power bi and do operations in visual level, in addtion, to use power shell in azure, you should register a power bi app in azure and install powershell module, in addtion, the power bi module can do things like follow, for details, refer to https://community.powerbi.com/t5/Community-Blog/Integrating-PowerShell-with-Power-BI-Part-1/ba-p/307712.
Connect-PowerBi
Switch-PowerBIContext
Add-PowerBIDataSet
Get-PowerBIDataSets
Get-PowerBITables
Update-PowerBITableSchema
Add-PowerBIRows
Remove-PowerBIRows
Get-PowerBIGroups
New-PowerBIDataSet
New-PowerBITable
New-PowerBIColumnHope it's helpful to you.
Jimmy Tao
I want to automate below task.
To find your publish to web URL:
- Open your report in Power BI Desktop.
- If you have not already done so, publish your report to the Power BI Service.
- Open the published report in the Power BI service. Select File > Publish to web.
http://community.powerbi.com/t5/Gallery-Forum/How-to-find-your-publish-to-web-URL/m-p/46358#M2
v-yuta-msftCommunity Support
Hi mahendran,
You requirement can be achieved completely because powershell module are usually be used to send data to power bi and do operations in visual level, in addtion, to use power shell in azure, you should register a power bi app in azure and install powershell module, in addtion, the power bi module can do things like follow, for details, refer to https://community.powerbi.com/t5/Community-Blog/Integrating-PowerShell-with-Power-BI-Part-1/ba-p/307712.
Connect-PowerBi
Switch-PowerBIContext
Add-PowerBIDataSet
Get-PowerBIDataSets
Get-PowerBITables
Update-PowerBITableSchema
Add-PowerBIRows
Remove-PowerBIRows
Get-PowerBIGroups
New-PowerBIDataSet
New-PowerBITable
New-PowerBIColumnHope it's helpful to you.
Jimmy Tao
Hi Jimmy Tao,
Thank you for your help. I will try this solution.
Thanks,
Mahendran Raman