While testing Tableau 10.1 with AX 2012 R3 Odata services,
I was unable to connect. Has anyone able to connect with Tableau ?
Basically it doesn't need Authentication, I tried both the ways.
No luck. Are there any wrinkles here ?
While the same works fine in Power-BI, Below is a Power-BI demonstration to show it successfully connects with AX.
In reply to Martin Dráb:
It displays following message
What is the version of Odata that comes with AX ? any idea !
In the following help URL, It is mentioned that Tableau connects to OData V2
In 2013 at the bottom of the blog one other person pradeep reported a similar issue connecting Odata with CRM
I am thinking this could be either due to the differences in odata version. There is no much help online.
In reply to Venkat Chaitanya Kanumukula:
Oh, you should have said that before - your picture above is misleading, because it doesn't belong to the error message. Your actual error says that the account doesn't have permissions to access the service. Give it permissions or use another account that already has them.
AX 2012 may be built using Odata V2 version but the protocol used is 1.0.
To find out the version of Odata and protocol version in AX 2012 ?
Here are the steps :
Browse the below URI in IE and check for <edmx:Edmx /> version
The green section highlighted in the image displays the version info.
For more info on Odata versions and documentation, you can reach here "http://www.odata.org/documentation/"
Here is my Experience/Conclusion :
Tableau Dashboard 10.1 cannot connect to AX 2012 Odata services with protocol 1.0 (DataServiceVersion) and this could well be a problem with other products too that have query options/interactive arguments.
Hard to figure out in the logs that has thousands of lines. So make sure to check the log file thoroughly.
Each software works differently, Finally I was able to resolve the issue.
Basically Tableau requires the feed/collection element name to be explicitly passed to the URI, It doesn't loop through all the collection/feed's available in the URI.
Very different from PowerBI and wasn't expecting this at all.
ex : http://<machine>:8101/DynamicsAx/Services/ODataQueryservice/ListofUSStates
I cannot mark it resolved, Since I was one who started this thread. But hope this resolution and discovery would help other users.
Final Conclusion : Tableau Dashboard 10.1 can connect to AX 2012 Odata services and works fine but need to pass on the feed/collection element explicitly to the URI.
I agree, Probably my search was specific to Dynamics AX Odata, hence didn't find any answers in their Forum. Thought this is broader Dynamics community and someone might know the answer.
But anyway, I confirm that it works with AX
The trick is not to specify the "root of a service reference in the URI" but pass a specific entity/serviceSet at the end of URI.
So typically if they need multiple entities then multiple datasources needs to be created and added to pages as shown in the sample.
Works with Dynamics CRM
and it works with Dynamics NAV,
Posting this info thinking it might be helpful to other dynamics users.