Forum Discussion
Dynamics 365 Related Table Filtering
It seems that I have hit a bit of a limitation on the current implementation of REST API 9. The other forum didnt quite help but kindly presented enough information for me to find an alternative.
Instead of using a $filtering, I have referenced an existing system view in Dynamics 365. I know the report is at risk of any changes to the system view, but the approach offloads the query to Dynamics, which then is pulled in to Power BI.
let
Source = OData.Feed("https://<tenant>.api.crm4.dynamics.com/api/data/v9.0/invoices?savedQuery=00000000-0000-0000-0000-000000000000", null, [Implementation="2.0"])in
Source
The savedqueryid was found in the savedqueries table.
I hope this can be of use to someone.
Mark_Holtham,
This issue is more related to Dynamics 365, please post the question in Dynamics 365 forum to get correct OData URL, then use it in Power BI Desktop.
Regards,
Lydia
A Microsoft engineer asked me to transition to the API 9.0 URL. Can you claify which one I should be using?
I have posted in the other forum but I'm sure other users would appreciate a solution here. The Power BI forums is a great resource point.
It seems that I have hit a bit of a limitation on the current implementation of REST API 9. The other forum didnt quite help but kindly presented enough information for me to find an alternative.
Instead of using a $filtering, I have referenced an existing system view in Dynamics 365. I know the report is at risk of any changes to the system view, but the approach offloads the query to Dynamics, which then is pulled in to Power BI.
let
Source = OData.Feed("https://<tenant>.api.crm4.dynamics.com/api/data/v9.0/invoices?savedQuery=00000000-0000-0000-0000-000000000000", null, [Implementation="2.0"])in
Source
The savedqueryid was found in the savedqueries table.
I hope this can be of use to someone.
Mark_Holtham,
Glad to here the issue is solved, you can accept your reply as answer to close this thread.
Regards,
Lydia