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
Invoke 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'...dzebrowitz12 minutes 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...pellitteris21 minutes agoAdvocate IINew1.3KViews27likes3CommentsBring Back separating Power BI artifacts on a per web page basis
Previously, the ability to have different artifacts open on different web tabs was enabled. This was beneficial if you wanted to differentiate what environments you were in, working across three diff...zoe-dean1 hour agoNew MemberNew46Views8likes0CommentsREST API Should expose credentials used in connections
When a consultant leaves a client, it's important to clean up any connections that may have the consultants credentials embedded within. I'm able to use the Fabric CLI to get the managed connections ...PeterDaniels1 hour agoAdvocate IIINew18Views6likes0CommentsExpose full activity-level error details in Workspace Monitoring Eventhouse
Microsoft Fabric Workspace Monitoring exposes activity-level pipeline telemetry in FabricDataPipelinesActivityRunsLogs, including PipelineRunId, OperationId, ActivityIterationCount, ActivityName, Act...MarcoOnnis2 hours agoNew MemberNew2Views0likes0Comments