Forum Discussion

azadthakur's avatar
azadthakur
Frequent Visitor
1 year ago

Issue with Exporting Data from Power BI Service

Hi Team,

I’m encountering an issue while exporting data from Power BI Service using the Summarize Data option, as we have more than 500 rows. Although I’m able to download the file, an error appears when I try to open it. This issue started last week and was working fine for all users until then.

I’ve attached snapshots of the Summarize option and the error for your reference. Could you please look into this and help resolve the issue?

Thank you in advance for your assistance.

Azad

Need Help

3 Replies

  • davidperry2's avatar
    davidperry2
    Frequent Visitor
    1 year ago

    Not sure if related but we are also suddenly seeing Export with summarised data/live connection give an error today, when was working previously. Get an error below.

     

     

  • Anonymous's avatar
    Anonymous
    Not applicable
    1 year ago

    Hi, azadthakur 

    I am glad to help you.

     

    Is the account you use to log into Power BI Service (Export data account) the same account you use to log into Excel?

     

    In my tests, if the two accounts are the same, it is possible to get the data:

     


    But when both accounts are different, you will get the error in your screenshot:

     

     

     

    I hope my suggestions give you good ideas, if you have any more questions, please clarify in a follow-up reply.
    Best Regards,
    Fen Ling,
    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

    • azadthakur's avatar
      azadthakur
      Frequent Visitor
      1 year ago

      Hi, I am using same account in both Power BI and excel, It was working fine but suddenly it stopped working for all users suddenly including me.