Dataverse Connector | Direct Query | The type of Current Preview value is too complex to display

Hello Mira_Ghaly ,

In response to the question you raised, I think you can solve it from the following aspects

• Simplify queries

If possible, try to simplify the query. For example, a specific field of data is returned, rather than the entire record

• Increase the number of preview rows

In Power Query's options, you can adjust the number of rows for the preview. Trying to increase or decrease this number may help solve the problem

• Check the data type

Make sure that the data type returned by your query is appropriate for display in the Power Query editor. Some complex data types, such as nested records or tables, can be difficult to preview

• Distribute load data

Try to distribute the load data, load some of the data to confirm that the query is correct, and then load all of the data

• Check the Power Query version

Make sure you're using the latest version of Power Query, as Microsoft is constantly updating and improving its features

• Check out the official documentation and forums

Troubleshoot Dataverse plug-ins - Power Apps | Microsoft Learn

Best Regards,

Jayleny

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.