Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
I am building a CRM Reporting dashboard using Power BI with OData connectors to Dynamics 365.
One of the queries is not allowing me to edit. The query connects to the systemusers table (via OData) in Dynamics 365 as follows:
= OData.Feed("https://hsconnect-uk.crm4.dynamics.com/Api/data/v8.1")
When trying to edit the query, it presents me with the following error message:
Preview.Error: The type of the current preview value is too complex to display.
Details:
I have other queries connecting to other tables in the same data source and they all work fine, but I cannot figure out why this particular query is not allowing me to edit. I’ve tried deleting any relationships in case these were constraining or adding “complexity”, but the error persists.
Any idea why this is happening and how I can get around it?
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.