Used Dynamics 365 as source (Odata API 9) in SSAS tabular model

Question

I'm trying to create a new SSAS tabular model with Dynamics 365 as source.
When I try the connection with Odata API 9.0 or 9.1 in Visual Studio, it's not working (see file in attached for the error message)

----------

Everything is working fine with version 8.1/8.2.
Url used looks like :
https://mytenant.crm4.dynamics.com/api/data/v9.0

Is it a limitation in SSAS or can i consider this as a bug ?

Moreover, trying the same connection (with Odata API 91) works fine in Power BI Desktop.

I try to do that with :

• Visual Studio 2017 (version 15.9.21) and Analysis Services extension (version 2.9.6)
• Visual studio 2019 (vrsion 16.5.4) and Analysis Services extension (version 2.9.8)

With version 8.2, there are no problems and the things are working well

Answer 1

Hi,

SQL Server Analysis Services (SSAS) is currently not supported in the Q&A forums, the supported products are listed over here https://learn.microsoft.com/en-us/answers/products (more to be added later on).

You can ask the experts in the dedicated SSAS forum over here:
https://social.msdn.microsoft.com/Forums/sqlserver/en-US/home?forum=sqlanalysisservices

(Please don't forget to accept helpful replies as answer)

Best regards,
Leon