Map User Name on Gateway for SAAS in Workgroup Server
We can typically connect via the Gateway to Analysis Services installed on a server outside a domain. But I can not create a dataset. It would be great to be able to map the user to a user in the SERVER\user format. I do not understand why I can not use the gateway if Microsoft allows me to install SQL into Workgroup. This does not make sense because I can install SQL into Workgroup and normally access using other clients. We have hundreds of potential customers today to use a solution built with PowerBI but we will not be able to install as most use standalone servers.