Please try Microsoft account authentication

[mibu]

Hi Everyone,

SQL database was recently moved to Azure...

when I try to connect to it from Power BI...  I get the following error message:

Pls advise if you know how to "try Microsoft account authentication"

Thank you,

mibu

[v-lili6-msft]

hi, @mibu

When you connect to Azure SQL database, please choose Microsoft account option to sign in with your Azure Active Directory account. See: https://powerbi.microsoft.com/en-us/blog/power-bi-desktop-january-2018-feature-summary/#AADauth

Best Regards,

Lin

[mibu · Accepted solution]

Hey everybody,

The solution steps for this issue follow:

Open Power BI Desktop...

Select File menu...

Select Options and settings...

Select Data source settings...

Locate Clear Permissions icon...

Select Clear All Permissions...

Click Refresh icon...

Done.

mibu