Import/refresh data from azure blob storage too slow

[user2jenny]

Hello all,

I have problem of importing data(Json files) from Azure Blob storage, it's extremly slow whether i do changes in Power query or import data. And it's also extremly slow while i want to test with an incremental refresh.

Does anyone have a solution for this?

Best regards

[Gengar]

Hi @user2jenny 

Do you have a lot of data? Does this happen when you connect to other data sources, or does it happen in other network environments? There are many factors that could cause this problem.

Ganger

[user2jenny]

Hello Gengar,

Yes i do have a lot of data, but just loading 17 hours of data takes at least a day which seems to me a lot.

It's normal when i connect to other data sources and my network is good, i can't find cause .

Jenny

[Gengar]

Hello @user2jenny ，

You may need to check whether this is because your data is too complex, and consider optimizing it.

Ganger