Forum Discussion

kennykhor's avatar
kennykhor
Icon for Advocate I rankAdvocate I
4 years ago

Cannot connect to LocalDB with Power BI Desktop

I manage to connect to LocalDB with SSMS as below, but encountered error with the same config applied in Power BI. Looking forward for a solution to connect to LocalDB   SSMS Config:   SQL ...
Need Help
GarethWatson's avatar
GarethWatson
New Member
1 year ago

I appreciate this issue is quite old but this is the first hit when searching for PowerBI and LocalDB.

 

I had this issue and managed to resolve it by downloading the latest SQL Server OBDC drivers from Microsoft.  With those installed I could use my EntraID (the new Azure AD thing) to auth against the DB.

 

I got this hooked up to PowerBI by creating a System Data Source and using my EntraID to authenticate.  Its called Integrated EntraID.... on the long list of authentication options.

 

Then I could use the ODBC connector in PowerBI and pick that data source.

 

For reference I am using the V18 version of the SQL Server ODBC driver.

 

Hope this helps someone.