question

CdricFodouopKamologne-6881 avatar image
0 Votes"
CdricFodouopKamologne-6881 asked CdricFodouopKamologne-6881 commented

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

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)9757-screenshot-1.png




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





azure-analysis-services
screenshot-1.png (28.3 KiB)
5 |1600 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

LeonLaude avatar image
0 Votes"
LeonLaude answered CdricFodouopKamologne-6881 commented

Hi,

SQL Server Analysis Services (SSAS) is currently not supported in the Q&A forums, the supported products are listed over here https://docs.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

· 4
5 |1600 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.

Hi @LeonLaude, my problem is about creating the model. As it's the same tool (visual studio) for Azure Analysis services or SQL Server Analysis Services, this mean that i alwo have the issue for Azure analysis Services. Do I miss Something ?


Regards Cedric


1 Vote 1 ·
LeonLaude avatar image LeonLaude CdricFodouopKamologne-6881 ·

Azure Analysis Services in built on SSAS, so the problem might be there as well, however if you're currently not using Azure Analysis Services then the SSAS forum is the place to ask :)

0 Votes 0 ·
SaygnAte-5848 avatar image SaygnAte-5848 CdricFodouopKamologne-6881 ·

@CdricFodouopKamologne-6881 did you figure out solution?


0 Votes 0 ·

Hi @SaygnAte-5848 i did'nt figure out a solution. I continue to use version 8.2. I sent an email to the team in charge of the plug-in (ProBIToolsFeedback@microsoft.com) but no feedbacks yet.


Regards
Cedric


0 Votes 0 ·