cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
dataguy
Helper III
Helper III

SSAS Connection String for Tabular From Desktop is Formatted Incorrectly

Power BI Desktop version: Version: 2.71.5523.941 64-bit (July 2019)

 

Tabular connections (live connection) are now being created as Server\\tabular in the desktop when publishing a report.

When trying to use the dataset from the report, we are now getting a message "There is no gateway to access the data source XXX"

 

The gateway is configured correctly with Server\tabular and the test connection continues to work as expected. We also tried adding the Server\\Tabular but then it wouldn't connect - just to prove that the connection string should be this way.

Is this is known bug? Is there a fix or workarond?  Thanks!

1 ACCEPTED SOLUTION
dax
Community Support
Community Support

Hi dataguy

As you could see above, in my image, the datasource information will be server\\instance, but this will show correctly in gateway201.PNG

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.

View solution in original post

4 REPLIES 4
dax
Community Support
Community Support

Hi dataguy,

When you use premise datasource, you need to set gatewy way for this. If you didn't set gateway for this datasource, you might will get below error

202.PNG

Then when you click to "add to gateway", it will show like below(it will automatically change to server\instance)

200.PNG

Then you will get result like below

201.PNG

By thw way, to make refresh or get data correctly, you also need to make sure your effective name's mapping correctly

204.PNG

 You could refer to Manage your data source - Analysis Services for details.

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.

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?

dax
Community Support
Community Support

Hi dataguy

As you could see above, in my image, the datasource information will be server\\instance, but this will show correctly in gateway201.PNG

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!

Helpful resources

Announcements
Power Platform Conf 2022 768x460.jpg

Join us for Microsoft Power Platform Conference

The first Microsoft-sponsored Power Platform Conference is coming in September. 100+ speakers, 150+ sessions, and what's new and next for Power Platform.

Power BI Dev Camp Session 23 768x460.jpg

Check it Out!

Mark your calendars and join us on Thursday, June 30 at 11a PDT for a great session with Ted Pattison!

June 20 episode 7 with aka link 768x460.jpg

The Power BI Community Show

Join us on June 20 at 11 am PDT when Kim Manis shares the latest on Azure Synapse analytics, the Microsoft Intelligent Data Platform, and notable Power BI Updates from Microsoft Build 2022.

Top Solution Authors
Top Kudoed Authors