Dataset missing when connecting to it from Excel

[MVenables]

Hi,

I have been trying to connect to a dataset through Excel as per below

There is a certain dataset that i can not see, but last week it was working for me and i could connect to it. 

I am set as admin in the workspace and i have cleared my cache data, signed out. Revoked my PBI Pro license then set it back up again and the certain dataset i am looking for is not appearing still. My collegues can see it and still connect to it and all the access and permissions are the same. Any help or ideas would be great thanks.

[amustafa · Accepted solution]

Can you check these settings in your Power BI Admin portal? This has to be done by the global admin.

[MVenables]

HI, these are enabled as per above. We are looking internally some more now as it maybe a security measure in place. We just don't understand why its specifically this dataset it is affecting. Thanks, Michael

[MVenables]

I found an old post from last year, stating that this was a bug that needed fixing before. Could it be thats it has happened again?
https://community.fabric.microsoft.com/t5/Issues/Bug-Excel-Power-BI-Datasets-is-showing-Blank-pane-t... 

[amustafa]

Can you try using the "Analyse in Excel" option from PBI service Semantic model?

[MVenables]

Hi, it looks like i can access it this way, thank you for that. I have tried again by going through Excel and it still isn't on there this way. Any idea why this would be?