Error message importing Data from Dataverse

Hi,

This timeout is typically not something that can be increased from within Power BI. It usually indicates that the Dataverse query is taking too long to complete or is returning a very large volume of data.

A few things you can try:

• Filter the data at the source in Power Query (for example, only import the required date range or active records) so less data is retrieved.
• Select only the columns you need instead of importing the entire table.
• If possible, enable Incremental Refresh so only new or changed data is refreshed after the initial load.
• Ensure the Dataverse table has appropriate indexes on the columns used for filtering.
• If you're connecting through TDS (SQL endpoint), consider using the Dataverse connector instead, as it's optimized for Dataverse workloads.
• For very large datasets, consider exporting the data to Azure Data Lake, Fabric Lakehouse, or Synapse and connect Power BI to that instead of querying Dataverse directly.

To better understand the cause, could you share:

• Approximately how many rows are in the Dataverse table?
• Are you using the Dataverse connector or connecting via the Dataverse TDS (SQL) endpoint?
• Does the timeout occur during the initial load or only during refresh?

That information will help determine the most appropriate solution.

Hope this helps.

Thanks!