Hi, I connected my file to an SQL database on Azure and chose the DirectQuery option. The preview shows up OK; I see the added table in the relationships view; I see the data when I go into edit...
Hi v-haibl-msft,
Thanks for you effort.
Actually I was able to reproduce this on 2 separate occasions on different versions whenever I added the port number to the SQL database host name in the connection settings when using a DirectQuery.
The funny thing is that putting the port number didn't interfere with anyhting when using the import option, but with DirectQuery there was this bug.