Importing data from Azure Blob storage is too slow

Hi saurabhabh 

When importing data from Azure Blob storage, it is slow generally.

Some tips you may have a try:

1. Disable "Backgroud data" and "parallel loading of tables" in current files under options. 

2. If you files have many columns of date/time type, you can disabled Data Load -> Auto Date/Time, so behind the scenes it doesn't create a date table automatically, which takes time.

3. Please disable load query.

Disabling Load doesn’t mean the query won’t be refreshed, it only means the query won’t be loaded into the memory. 

4. You can filter your resource table and just retain the neccesary data before you load all the data into model.

Change JSON Blob data during import

In addtion, you can follow those two articles to optimize data model to improve the performance:

Data Import Best Practices in Power BI
Power BI Performance Tips and Techniques

Best Regards
Maggie

Community Support Team _ Maggie Li
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.