Forum Discussion
felipecastri
4 years agoRegular Visitor
SQL SERVER FROM DATAMART
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 i...
itchyeyeballs
Impactful Individual
4 years agoAre you using the datamart connector in the new July update or trying to connect directly to the SQL DB?
- felipecastri4 years agoRegular Visitor
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?- itchyeyeballs4 years ago
Impactful Individual
With the new connector you can choose to use the sql endpoint or the dataset, have you tried both?