Power BI - Live connection - Summarized data - Export to excel Failed

[GShanmugam]

Hi Team,

I just need assistance in resolving the below issue.

One of our PowerBI team member trying to export an excel file from one of our dashboard using live connection -> Summarized report which throws the "OLEDB or ODBC data does not exist or not having permission to access it" I have attached the screenshot for your reference.

this used to be working for this user and this functionality works for all other users. not sure why this started happening.

The user had created a secondary profile in Microsoft teams for testing purpose- I thought it might causing interruption with permission and i have delete that profile. this is the only change that happened

could someone please assist me to resolve the issue?

[arvindsingh802 · Accepted solution]

Make sure the user have have Build permissions to the Power BI dataset or have at least a Contributor role in a Power BI workspace.
Refer General requirement section in https://powerbi.microsoft.com/en-us/blog/announcing-connected-excel-tables-from-power-bi/?cdn=disabl... 

[GShanmugam]

Hi Arvind,

Thanks for the above solution - am sure he got the contributor permission. Let me dobule check and come back to you.

[GShanmugam]

Hi Arvind,

The contributor permission - fixed the issue that was addressed earlier.

thank you for providing the solution.

[v-aatheeque]

Hi @GShanmugam ,

If our response addressed by the community member for your query, please mark it as Accept Answer and click Yes if you found it helpful.

Should you have any further questions, feel free to reach out.
Thank you for being a part of the Microsoft Fabric Community Forum!