Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
7 years ago
Solved

Export data to Excel from Embed code link

Hi all,

 

I would like to know if there is a way to export data to Excel from a dashbard that have been sent with Embed code link

 

Best regards

Need Help
  • GilbertQ's avatar
    GilbertQ
    7 years ago
    Hi there

    That is using Publish to Web and as part of using Publish to Web one of the limitations are that you cannot export the data.

    https://docs.microsoft.com/en-us/power-bi/service-publish-to-web
    Limitations
    Publish to web is supported for the vast majority of data sources and reports in the Power BI service, however, the following are not currently supported or available with Publish to web:

    Reports using row level security.
    Reports using any Live Connection data source, including Analysis Services Tabular hosted on-premises, Analysis Services Multidimensional, and Azure Analysis Services.
    Reports shared to you directly or through an organizational content pack.
    Reports in a group in which you are not an edit member.
    "R" Visuals are not currently supported in Publish to web reports.
    Exporting Data from visuals in a report, which has been published to the web
    ArcGIS Maps for Power BI visuals
    Reports containing report-level DAX measures
    Single sign-on data query models
    Secure confidential or proprietary information
    The automatic authentication capability provided with the Embed option doesn't work with the Power BI JavaScript API. For the Power BI JavaScript API, use the user owns data approach to embedding. Learn more about user owns data.

7 Replies

  • shawntbenson's avatar
    shawntbenson
    New Member
    6 years ago

    This is the number one complaint about Power BI that I get from our end users... inability to export report contents to Excel from embedded links. Of all possible enhancements, this is the ones that would be the biggest game changer for my organization.

  • GilbertQ's avatar
    GilbertQ
    Super User
    7 years ago

    Hi Anonymous 

     

    Do you mean export data from a dashboard tile?

     

    If so you can do it by clicking on the Ellipses

     

    • Anonymous's avatar
      Anonymous
      Not applicable
      7 years ago

      Hi GilbertQ

       

      Thank you for your response 

       

      I mean using the Embed code link (not in the PowerBI.com portal) I haven't the option to export data of a tile to a .csv or excel files 

       

      Best regards

       

      • GilbertQ's avatar
        GilbertQ
        Super User
        7 years ago
        Hi there

        I think that this might be possible if you are referring to Power BI Embedded?
  • ferzfeld's avatar
    ferzfeld
    Advocate II
    7 years ago

    I think I might have the exact same question?

     

    When using the generated embed link ("Securely embed this report in a website or portal"), the user is not presented with the dialogue to choose wether to Export as Excel or CSV (Picture 1)

     

    Instead, after a few seconds of time the user can download the data as .CSV (Picture 2) - no possibility to choose between Excel or CSV or any other options.

     

    Any way to have that option Excel-File or CSV when using the embed-link?

     

    Thank you!