Data loading

[Sreesudha_OC]

Hi All,

I need your help.  I have extracted some data from using api " https://api.covid19india.org/districts_daily.json" and customized to my requirement. However when click on " close & apply" it is taking significant amount of time to load the data. I have cancelled this actvitiy many times and at the same time i have also given 5-6 hrs to load this information.  It still says WIP.  Any clue on reson behind this? Or how can we identify how long does this need to load the entire data.

Thanks

Sudha

[V-lianl-msft · Accepted solution]

Hi @Sreesudha_OC ,

If the data is large, you can consider importing the JSON file into the SQL Server database. Then connect to the database by using directlyquery mode.

https://docs.microsoft.com/en-us/archive/blogs/sqlserverstorageengine/bulk-importing-json-files-into... 

You can also refer to the operation steps

https://community.powerbi.com/t5/Desktop/load-performance-analyzer-data-json-into-power-bi/td-p/8547... 

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