Synapse Serverless with Oledbsql provider

Chang Stephane 1 Reputation point
2021-03-17T18:09:35.317+00:00

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
Azure Synapse Analytics
An Azure analytics service that brings together data integration, enterprise data warehousing, and big data analytics. Previously known as Azure SQL Data Warehouse.
4,369 questions
0 comments

1 answer

Sort by: Most helpful
Most helpful Newest Oldest
  1. PRADEEPCHEEKATLA-MSFT 77,081 Reputation points Microsoft Employee
    2021-03-18T06:41:00.63+00:00

    Hello @Chang Stephane ,

    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.