Forum Discussion

Meghmala's avatar
Meghmala
Regular Visitor
7 years ago
Solved

Export Power BI report template from a desktop report using powershell

I would like to know how to export Power BI template from a Power BI desktop report using power shell?

or perform this action using a C# application

 

I found this link on th web. But it seems like it is only for exporting reports .

https://docs.microsoft.com/en-us/powershell/module/microsoftpowerbimgmt.reports/export-powerbireport?view=powerbi-ps 

 

Even using this give me the following error-

 

New-PowerBIReport : The term 'New-PowerBIReport' is not recognized as the name of a cmdlet, function, script fil

operable program. Check the spelling of the name, or if a path was included, verify that the path is correct and

again.

At line:1 char:1

+ New-PowerBIReport -Path 'C:\abc\pqr\Lending  ...

+ ~~~~~~~~~~~~~~~~~

    + CategoryInfo          : ObjectNotFound: (New-PowerBIReport:String) [], CommandNotFoundException

    + FullyQualifiedErrorId : CommandNotFoundException

 

Could anybody please steer me in the correct direction?

Need Help
Show and Tell
Tips and Tricks
Tutorial Requests
  • Anonymous's avatar
    Anonymous
    7 years ago

    HI Meghmala ,

    As document mentioned, this script require objectid to export specific contents. I think you need to use report id to instead.

     

    Spoiler

    Parameters

    -Id

    ID of the report to export.

    Type: Guid
    Aliases: ReportId
    Position: Named
    Default value: None
    Accept pipeline input: True (ByPropertyName)
    Accept wildcard characters: False
    -OutFile

    Output file to save the exported report to. Path must not already exist.

    Type: String
    Position: Named
    Default value: None
    Accept pipeline input: False
    Accept wildcard characters: False
    -WorkspaceId

    ID of the workspace containing the Power BI report to export.

    Type: Guid
    Aliases: GroupId
    Position: Named
    Default value: None
    Accept pipeline input: False
    Accept wildcard characters: False

     

    In addition, did this report create on power bi service? Current export not works on online report.

    Export a report from Power BI service to Desktop (Preview)

    Regards,

    Xiaoxin Sheng

2 Replies

  • Anonymous's avatar
    Anonymous
    Not applicable
    7 years ago

    HI Meghmala ,

    As document mentioned, this script require objectid to export specific contents. I think you need to use report id to instead.

     

    Spoiler

    Parameters

    -Id

    ID of the report to export.

    Type: Guid
    Aliases: ReportId
    Position: Named
    Default value: None
    Accept pipeline input: True (ByPropertyName)
    Accept wildcard characters: False
    -OutFile

    Output file to save the exported report to. Path must not already exist.

    Type: String
    Position: Named
    Default value: None
    Accept pipeline input: False
    Accept wildcard characters: False
    -WorkspaceId

    ID of the workspace containing the Power BI report to export.

    Type: Guid
    Aliases: GroupId
    Position: Named
    Default value: None
    Accept pipeline input: False
    Accept wildcard characters: False

     

    In addition, did this report create on power bi service? Current export not works on online report.

    Export a report from Power BI service to Desktop (Preview)

    Regards,

    Xiaoxin Sheng

    • yandra's avatar
      yandra
      Regular Visitor
      7 years ago

      Hi,

       

      I am exploring the same similar feature "Export Power BI report template using PowerShell schript", but I couldn't find out the solution posted in this thread. Help me with the solution. Thank you!