Forum Discussion

KARE's avatar
KARE
New Member
9 years ago

PowerBI and Dynamics AX Integration - filter by data record selection in Dynamics AX

Hi,   all examples concerning the integration of PowerBI  in Dynamics AX show as starting point only totals! So if I would start in a workspace for customer- the PowerBI report show e.g. the turnov...
Anonymous's avatar
Anonymous
Not applicable
9 years ago

Hi KARE,

Yes. Within the content pack, we have less control. Please use Power BI Desktop to connect to Dynamics AX  and filter data based on  your needs.

Thanks,
Lydia Zhang

retailguy's avatar
retailguy
Advocate I
8 years ago

Hi Lydia, 

I am currently using the ODATA feed for Dynamics AX online.  We have been told that the tables cannot be filtered using parameters with the ODATA url and so whenever a refresh occurs we must extract ALL rows and ALL columns before filtering on the PowerBi side.  This takes ages and on the service results in timeouts.

Is there a way to filter with parameters as part of the ODATA URL?  I've looked at documentation - https://docs.microsoft.com/en-us/dynamics365/unified-operations/fin-and-ops/  -  this says filtering is possible, but this one says it isn't supported https://blogs.msdn.microsoft.com/axsa/2015/02/20/power-bi-and-dynamics-ax-part-2-extract-and-transform/

 

Would yo able able to clarify for me?

 

thanks