CODEWITHSUNDEEP
sql-serverpowerbi
Nurbek Kuantyrov
Nurbek Kuantyrov

Reputation: 177

Unable to connect to SQL Server database (error 25) in PowerBI

I've tried to connect to a SQL Server database (to get data) via DirectQuery and got an Error 25:

Connection String is not valid.

But when I tried to import data from that server, it was successful and I was able to visualize it. However working with a large set of data (700k-1mln rows and 10+ columns) it would be more logical to connect via DirectQuery. Is there anything you can suggest?

Has anyone experienced this issue before and if yes, how did you resolve it?

Edit: I have corrected typo with row count, sorry my bad. Regarding your comments, DQ is a must have requirement.

Error 25

Upvotes: 2

Views: 2485

Answers (1)

Nurbek Kuantyrov
Nurbek Kuantyrov

Reputation: 177

FYI: **Solution: for DQ in Powerbi, you should put "," instead of ":" in front of a port as a server . e.g. servername,port

But for import, semicolon works fine.**

References: Solution from PowerBI community

Upvotes: 4

Related Questions