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 l...
Need Help
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.

       

      • Anonymous's avatar
        Anonymous
        Not applicable
        6 years ago

        Yes, the first attempt failed due to some wrong selection and that's probably why it didn't make the list. But it didn't stop the credentials being cached. Never mind, I have reverted to SQL server to store the tiny dataset.