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 that belong to it programmatically.
4 Comments
- fbcideas_migusrNew MemberThis will help in scenarios where a customer has to move tenants.
- James_BartlettNew MemberIt'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.
- nishalitNew Member
First comment - "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."
- fbcideas_migusrNew MemberStatus added:Completed
Recent ideas
Allow 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...tmihara5 hours agoNew MemberNew4Views0likes0CommentsSupport 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-bi8 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_K10 hours agoMicrosoft EmployeeNew24Views6likes0CommentsInvoke Pipeline Task - Workspace Identity Authentication
Currently, the Fabric Data Factory Invoke Pipeline task uses the user's credentials who saved the pipeline to then authenticate to the Azure Data Factory to execute the ADF pipeline. When that user'...dzebrowitz15 hours agoAdvocate IPlanned1.8KViews61likes5CommentsFabric Pipeline should run as workspace identity
Currently, Microsoft Fabric pipelines run under the identity of the last user who modified them, which can cause disruptions when tenant administrators make changes to security policies, such as enab...pellitteris15 hours agoAdvocate IINew1.4KViews27likes3Comments