There should be a way to use the SSAS Tabular Connector without AD Sync, e.g. by using CustomData on the connection string.
I do not know for sure whether my problem is the same but I suspect so. I have done the following: 1. Set up a demo SSAS Tabular database in an Azure VM that is standalone (not connected with my company domain). 2. Made the demo SSAS Tabular database available externally by making its port static, opening up that port for inbound traffic, and creating an Azure endpoint. 3. Tested the connectivity from SQL Management Studio (which has to be opened using a "run as" command, e.g. runas /netonly /user:<>\<> “C:\Program Files (x86)\Microsoft SQL Server\110\Tools\Binn\ManagementStudio\Ssms.exe”) 4. In Power BI, tried to create a SSAS Tabular data connection. On (4), I ran into a blank screen. There appears to be no way to do, from Power BI, what I was able to do from SQL Management Studio - that is, to connect to this Azure-VM-hosted SSAS database. We had thought the combination of an Azure VM (not domain connected) and some Power BI dashboards would be a perfect, easy and safe way to demonstrate our product to external users, without exposing our home network to hacking, etc. But this looks like it is going nowhere at the moment. Can you comment on whether my problem is the same as what others here are seeing? And can anything be done about it? Thanks.
