Forum Discussion
Problem when export data to excel in embedded (Error 401 in request)
I have some Power BI projects embedded and yesterday the users call me to say that "Export Data" does not working anymore:
English:
Query execution for the Export Data operation resulted in an error.
I can export data from Power BI Desktop and from Power BI Web, but in embedded not.
If I check de Network tab in Developer Console, I can see some itens:
I think the information about "X-PowerBI-CannotAccessV2WorkspaceAsV1" is important, but what it this?
If I check the this Workspace in Power BI Web, indeed it is "different" than others Workspace that I have (and export data continue working fine in newest workspaces).
This Workspace is very old, since 2017 (so so) and has some different options that others, for example:
Is that true that exists Workspace V1 and Workspace V2?
Anyone know what this problem would be when exporting data?
Hi gluizqueiroz ,
This issue has been submitted internally.
Internal ICM ID: 277109021.
Please be patient to wait for fixing. If there is any news, I will update it here.
Best Regards,
Jay
6 Replies
Hi gluizqueiroz ,
This issue has been submitted internally.
Internal ICM ID: 277109021.
Please be patient to wait for fixing. If there is any news, I will update it here.
Best Regards,
Jay
Hey Anonymous
Thanks for help!
I create a new workspace, publish all my reports in the new workspace, create a new e-mail account to this client, register a new APP in "dev.powerbi.com", granted the permissions in Azure AD (same as my other clients where export work fine), change all the parameters that I use in Javascript Embedded and still does not working.
I am waiting some news.Thanks!
Hi gluizqueiroz!
We had the same issue for our embedded reports within Teams, but adding/removing the Power BI tabs seemed to resolve the issue. I'm not sure what caused it, we did rope in Microsoft Support (the functionality to add a new tab in Teams wasn't working for me before today) but I don't know if they'll look into it any further now we've found a solution.
Hi sonja_aberdeen
Glad to hear you can solve this problem. When you said "adding/removing the Power BI tabs", did you mean delete and create again this tabs?:
I have tried create another new tab and put a simple table to try, but it does not work.Hi gluizqueiroz
Apologies my wording was a bit confusing! I mean removing/readding the reports through Teams, so right clicking on the Teams "tab" and removing, then adding back again:
The issue also effects the sharepoint embedding, removing and adding the report fixes this.
