Forum Discussion
Dataset missing when connecting to it from Excel
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.
Can you check these settings in your Power BI Admin portal? This has to be done by the global admin.
5 Replies
- amustafaSolution Sage
Can you try using the "Analyse in Excel" option from PBI service Semantic model?
- MVenablesAdvocate II
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?
- MVenablesAdvocate II
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-to-Users/idc-p/3861488#M104097 - amustafaSolution Sage
Can you check these settings in your Power BI Admin portal? This has to be done by the global admin.
- MVenablesAdvocate II
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