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.
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?
      • Anonymous's avatar
        Anonymous
        Not applicable
        7 years ago

        Hi GilbertQ,

         

        Thanks for your response,

         

        As an example, when I see the dashboard in PowerBI.com and click on 'more options' in the every tile I see the options to Export to Excel:

        Then I create the embed code to create the link and send in mail 

        And open in another page:

         

        Here doesn't exists the option 'more options' to export data to Excel

         

        Best regards