Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago

Bizzare Data source credentials issue

Hi,

 

I have attempted to connect to an Excel file on Onedrive using the recommended "Web" option. As usually, it failed on the first time as I wasn't sure which one to choose. Since then, I have lost the privilige to change the credential. I have tried to clear or edit permission in the data source. But sarcastically, it doesn't even appear in the data source list, not in the local and not in the global. So I am really stuck - need to clear permission but no item to clear however the credential does get stored but just hidden. Please make Power BI a more sensible product to use.

Need Help

6 Replies

  • v-eachen-msft's avatar
    v-eachen-msft
    Community Support
    6 years ago

    Hi Anonymous ,

     

    You can click "Edit Query" option in the home navigation bar to open the data source settings.

    Then you could edit/remove your permissions in current file or global desktop.

    If you think this option is too hidden, you could post an idea here to improve Power BI.

     

    • Anonymous's avatar
      Anonymous
      Not applicable
      6 years ago

      No, it's not the option is hidden. I have no difficulty finding it. It's the file not shown in the data source list but the credential has already been cached. So you see the dilemma. You can't clear permission because it's not recognised as a "data source" but it does get cached. I have even tried "clear all permission" but it simple removed existing one not the hidden one. What can I do? 

      • v-eachen-msft's avatar
        v-eachen-msft
        Community Support
        6 years ago

        Hi Anonymous ,

         

        Do you mean that you could't find the data source you have configured in these two lists?

        You could try to re-install Power BI and check if this problem will happen.