Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
2 years ago
Solved

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.

Need Help
  • amustafa's avatar
    amustafa
    2 years ago

     

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

     

5 Replies

  • amustafa's avatar
    amustafa
    Icon for Solution Sage rankSolution Sage
    2 years ago

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

    • Anonymous's avatar
      Anonymous
      Not applicable
      2 years ago

      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?

  • amustafa's avatar
    amustafa
    Icon for Solution Sage rankSolution Sage
    2 years ago

     

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

     

    • Anonymous's avatar
      Anonymous
      Not applicable
      2 years ago

      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