Announcing Connected Excel Tables from Power BI (Public Preview) - you don't have the right permissi

[daamruth]

Hi community, 

I just wanted to try out the new Connected Excel tables. I am admin of the workspace, "Allow XMLA endpoints and Analyze in Excel with on-premises datasets" is enabled for the whole org. We are running on P1 and I personally have a Pro license. 

When I try to export data the new feature is greyed out with the following tooltip. 

Any idea what setting I missed? Does this feature work on your side? I tried several reports and datasets. 

Thanks

Daniel  

"you don't have the right permissions to use this feature"

[daamruth · Accepted solution]

Hi @mohancsg , 

sorry to hear. I just tried it again and it suddenly works. I haven't touched any settings on our tenant or on the workspaces. It seems to me that the feature took some time to be rolled out by MS.

Keeping my fingers crossed otherwise open a ticket. 

Regards

Daniel  

[mohancsg]

@daamruth I have raised a ticket in community

https://community.powerbi.com/t5/Service/Connected-Excel-Tables-from-Power-BI-Public-Preview-you-don...

Lets see if anyone has a solution for this.

[mohancsg]

@daamruth Hey, I am also facing the same issue.

I have power bi pro license with admin rights on the workspace where I have publised my reports.

When i check this option it is disabled and saying the message same as you.

Did you find anything on this.

Could you please share if you get anything.

Thanks,

Mohan V.