Forum Discussion

Bets's avatar
Bets
New Member
6 years ago

SQL Server Connection Data Source wont clear permissions

Hi.    I Have been struggling to delete (clear permissions from) a data source from SQL Server under the File>Options and Settings>Data Source Settings>Data Sources in Current File. It doesnt go aw...
Need Help
DataZoe's avatar
DataZoe
Microsoft Employee
6 years ago

Bets It is probably in the global settings still. Go to data source settings, then look at the global permissions (at the top). Find your SQL server from before and and delete it there.  

Bets's avatar
Bets
New Member
6 years ago

Thank you  DataZoe . I checked there too and there are no data sources listed there either.

  • DataZoe's avatar
    DataZoe
    Microsoft Employee
    6 years ago

    Bets That is weird. When desktop is running a little wierd, I would check to make sure you have the most current version installed. What version of Power BI Desktop are you running? Is it Version: 2.79.5768.1082 64-bit (March 2020)?

    • Bets's avatar
      Bets
      New Member
      6 years ago

      DataZoeYes, its the latest version. Please see below. Weird indeed.

       

      Version: 2.79.5768.1082 64-bit (March/2020)

      • adolfoganavarus's avatar
        adolfoganavarus
        New Member
        6 years ago

        I also have the same problem!, need help to fix this problem urgently for a client. Bets