Amanjeet_Singh
8 years agoNew Member
Status:
Completed
PowerShell: Export and import Power BI reports and Workspaces
Currently, PowerShell has modules for exporting Power BI reports. It would be good to have new feature in PowerShell, so that one can export and import workspaces along with all the Power BI reports ...
James_Bartlett
5 years agoNew Member
It's already possible to do this using only existing PowerShell scripting techniques and pre-built Cmdlets from the MicrosoftPowerBIMgmt module. No API calls necessary. Backup: Use the Get-PowerBIWorkspace and Get-PowerBIReport Cmdlets to pull the lists of everything you need to back up, save your Workspace names (I recommend using file folders on your hard drive to represent the Workspaces you're backing up, and you can save a JSON file in each Workspace folder containing that Workspace's metadata if you need it), then use the Export-PowerBIReport Cmdlet to download the Reports. If you use my recommended file folder method, it makes storing and retrieving any given exported Report much easier, because you can just drop it into the folder whose name matches the Workspace it came from. Restore: Use the New-PowerBIWorkspace Cmdlet to create the new Workspaces, enumerate through them with Get-PowerBIWorkspace to match the new WorkspaceId GUIDs with their original names (you'll probably want to create a PS hashtable variable to store that lookup table in memory, so you don't have to re-run the Get-PowerBIWorkspace Cmdlet for each Workspace you restore), and then use the New-PowerBIReport Cmdlet to upload each Report to its respective Workspace.
Recent ideas
Make Copilot Approval status for semantic model available through API
In recent versions fabric allowed to mark a semantic model as approved for copilot to reduce AI adoption friction. However there is no specific way for external governance application to analyse whi...FrançoisD11 minutes agoFrequent VisitorNew1View0likes0CommentsClone a workspace, including its data, to a new workspace
Description: Today there's no way to fully clone a Fabric workspace: git sync and Deployment Pipelines move item definitions only, not the underlying data; Warehouse's zero-copy CREATE TABLE ... AS ...gclements1 hour agoHelper IINew6Views1like0CommentsAllow NotebookUtils getSecret() to authenticate with Workspace Identity
Current behavior In Microsoft Fabric, notebookutils.credentials.getSecret() authenticates against Azure Key Vault using the identity of the user who executes the notebook. This behavior appli...tmihara6 hours agoNew MemberNew7Views0likes0CommentsSupport Synonyms in Fabric Warehouse
Microsoft SQL Server has a very powerful feature by the way of "synonyms." It allows users and DBAs to do all sorts of powerful magic such as rewiring objects under the hood (e.g. run the code agains...matthias-bi10 hours agoRegular VisitorNew1.3KViews18likes2CommentsExpose Refresh Warnings and Informational Messages via Notifications and API
When a Power BI semantic model refresh completes successfully, the status shows Completed, even when the refresh details contain warnings or informational messages that require attention. Please pro...Jashwanth_K12 hours agoMicrosoft EmployeeNew27Views7likes0Comments