SQL SERVER FROM DATAMART

[felipecastri]

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?

[nbs33]

@felocastri did you ever find a resolution to this issue? I am have the same problem

[Alomholdt]

Mine also randomly freezes at X number of rows. If I restart the import, the number will be different. 

[itchyeyeballs]

Are you using the datamart connector in the new July update or trying to connect directly to the SQL DB?

https://powerbi.microsoft.com/en-us/blog/power-bi-july-2022-feature-summary/#post-19945-_Toc10809984...

[felipecastri]

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?

[itchyeyeballs]

With the new connector you can choose to use the sql endpoint or the dataset, have you tried both?

[felocastri]

Besides after 10 minutes of loading I got this warning from power Bi

[felocastri]

Besides after 10 minutes I got this warning from power bi