March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount! Early bird discount ends December 31.
Register NowBe one of the first to start using Fabric Databases. View on-demand sessions with database experts and the Microsoft product team to learn just how easy it is to get started. Watch now
Hi, the new service datamart include sqlserver. When Im trying to connect power bi desktop to import database link does not work
this is the link power bi service provide
This is what happening when I used in POWER BI DESKTOP, It freezes in 108 k rows. link is not importing data. Is something wrong with this?
@felocastri did you ever find a resolution to this issue? I am have the same problem
Mine also randomly freezes at X number of rows. If I restart the import, the number will be different.
Are you using the datamart connector in the new July update or trying to connect directly to the SQL DB?
Yes I have the last version power bi deskop and I tried both. Direct Query works but Import doesn't.
Table has 2 million of rows but maybe there is a conection problem because is in preview mode?
With the new connector you can choose to use the sql endpoint or the dataset, have you tried both?
Besides after 10 minutes of loading I got this warning from power Bi
Besides after 10 minutes I got this warning from power bi
March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount!
User | Count |
---|---|
36 | |
26 | |
19 | |
11 | |
8 |
User | Count |
---|---|
54 | |
43 | |
24 | |
13 | |
11 |