PowerBI Dataverse Query - SLOW

[Anonymous]

Hi There,

I'm trying to build PowerBI reports to visualise data in a dataverse instance that contains a set of contacts, accounts and results of Customer Voice surveys. The thing is, I've always found Dataverse connections to be unusably slow - taking over an hour to load a single table with a simple query that should return about 162k rows. 

This is NOTHING in the grand scheme of things, so I don't understand why it takes so long. It's nothing to do with the link speed - I get the same result whether I'm on a 20Mbs link or on a 900Mbps one. Does anyone have any idea why I'm unable to work effectively with supposedly the top of the range cloud service?

[Idrissshatila]

Hello @Anonymous ,

You could first remove columns that you don't need in your analysis and you could use sharepoint online list and check if it would be faster for your case.

If I answered your question, please mark my post as solution, Appreciate your Kudos 👍

Follow me on Linkedin