Forum Discussion

Sam's avatar
Sam
Regular Visitor
9 years ago
Solved

how to export data to excel from Power BI Published Report

Hello,

I apologise in advance as I am very new to PowerBI, so I may not be making sense but I will do my best.

We were given a report through email, it shows up as a web link. When we click on it, it opens in a regular web browser window (not in the PowerBI webapp). I think this means it's a published report. We would like to export info this to excel, but I don't see the 'eclipse' where the export option is as it's not opening in PowerBI. The establishment that sent us the report says it will export to Excel, but they won't tell me how, they want to charge is $160/hr for 4 hours for some training. This seems ridiculous, we are not going to pay that rate. Is there a way to take the link sent and open it in PowerBI webapp or Desktop? We have a Pro account. I tried using the get data from web feature in the Desktop version and it did not display properly, we could only see a few of the column titles but no data. I read on user forums that it is not possible to export published reports to Excel, but they are very insistent that it will work. How can I confirm that this is actually a published report? I get the feeling these guys are out to lunch and would like to confirm. Please let me know if I need clarify things, I know this is pretty scattered. 

Thanks,

Sam

  • If this was published via "Publish to Web" then I believe that functionality does not exist.

  • Anonymous's avatar
    Anonymous
    9 years ago

    Hi Sam

    The only way to export data to excel is from within the PBI Service.

    If the report is published to the web, it won't work.

     

5 Replies

  • Greg_Deckler's avatar
    Greg_Deckler
    Community Champion

    If this was published via "Publish to Web" then I believe that functionality does not exist.

  • Anonymous's avatar
    Anonymous
    Not applicable

    Hi Sam

    The only way to export data to excel is from within the PBI Service.

    If the report is published to the web, it won't work.

     

  • Sam's avatar
    Sam
    Regular Visitor

    Thanks guys,

    I just had a reply from the report creator and apparently they had sent me the wrong link!

    Once I opened the correct link I was asked to sign into our PowerBI Pro account and the report opened in PowerBI webapp which has the eclipse.

    Now it's saying that the information is gone and to contact the creator, but that's a new issue and I am currently dealing with it.

    Thank you all for your replies!

    Good thing I didn't take them up on the overinflated training fees!

     

    Sam

    • Anonymous's avatar
      Anonymous
      Not applicable

      Hi Sam,

      You would need to ask the report author that if the report works well on his side and if he has shared the dashboard to you. 

      Thanks,
      Lydia Zhang

  • joseco's avatar
    joseco
    Regular Visitor

    2019 and still waiting for this answer, anyone knows if is possible by now?