Forum Discussion
SSAS Connection String for Tabular From Desktop is Formatted Incorrectly
Hi dataguy
As you could see above, in my image, the datasource information will be server\\instance, but this will show correctly in gateway
So I think your problem should be that not mapping to correct gateway.If you have same datasource connection string which exist in gateway, you could map this to corresponding datasource in gateway, like my above image(I map this to tabular). You could try this to see whether it work or not.
Best Regards,
Zoe ZhiIf this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
We have the definition in the gateway just fine. This has worked for us for over a year.
Recently new published reports cannot access the dataset.
If you go into the Settings for the Dataset, it shows the list of possible Gateways.
Then when you expand one to see why it is not working, it shows - AnalyServices{"server":"myserver\\tabular","database":"MyDatabase"} Add to Gateway
So as you can see it thinks the connection string needs a \\ which is incorrect. The connection string exists on a gateway and has for over a year as myserver\tabular and has been working.
So any more thoughts?
Hi dataguy
As you could see above, in my image, the datasource information will be server\\instance, but this will show correctly in gateway
So I think your problem should be that not mapping to correct gateway.If you have same datasource connection string which exist in gateway, you could map this to corresponding datasource in gateway, like my above image(I map this to tabular). You could try this to see whether it work or not.
Best Regards,
Zoe Zhi
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Thank you!