question

ChangStephane-4696 avatar image
0 Votes"
ChangStephane-4696 asked ·

Synapse Serverless with Oledbsql provider

Hello,
I try to create an Azure analysis services cube in SSDT by using oledbsql connector with synapse serverless. The Database connection is ok, i can browse all the tables but when i select a table and get it into my tabular cube, i get this error OLE DB NO_BROWSETABLE is not supported for SET. How can i resolve this issue ?

Thanks for you help

azure-synapse-analytics
10 |1000 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

1 Answer

PRADEEPCHEEKATLA-MSFT avatar image
0 Votes"
PRADEEPCHEEKATLA-MSFT answered ·

Hello @ChangStephane-4696,

Welcome to the Microsoft Q&A platform.

Unfortunately, Azure Synapse Serverless doesn't support NO_BROWSETABLE.

From this document, it shows as not supported and from this document it applicable only for SQL Servers and Azure SQL Database.

79061-image.png.

Hope this helps. Do let us know if you any further queries.


Please don’t forget to Accept Answer and Up-Vote wherever the information provided helps you, this can be beneficial to other community members.




image.png (8.5 KiB)
· 2 ·
10 |1000 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

Hello @ChangStephane-4696,

Just checking in to see if the above answer helped. If this answers your query, do click Accept Answer and Up-Vote for the same. And, if you have any further query do let us know.

0 Votes 0 ·

Hello @ChangStephane-4696,
Following up to see if the above suggestion was helpful. And, if you have any further query do let us know.
Take care & stay safe!

0 Votes 0 ·