Forum Discussion

andyspa's avatar
andyspa
Helper I
4 years ago

Queries long to load

Hello everybody!   I've built a model that is getting data from different sources' types ".csv & web".   For each country folder I have the first query that is scrapping data from a web table. Th...
Need Help
v-jingzhang's avatar
v-jingzhang
Community Support
4 years ago

Hi andyspa 

 

As the data taken from the web are static and don't need a daily refresh, you can store the web data in a csv file, and load data from this csv file into your report. This would be faster. 

 

You can also create a dataflow in Power BI Service to hold data from the web and refresh the dataflow every six months. Then in your report, connect to this dataflow to get the web data. When you refresh the report, it will load data from the dataflow without needing to query the web.

 

Have a try!

 

Best Regards,
Community Support Team _ Jing
If this post helps, please Accept it as Solution to help other members find it.

andyspa's avatar
andyspa
Helper I
4 years ago

THanks my friend. You mean to create a table once and export as csv, and use that one as source in another file?

 

Regarding the dataflow, it looks like I don't have that option:

 

 

Thanks,

a.

  • v-jingzhang's avatar
    v-jingzhang
    Community Support
    4 years ago

    Hi andyspa 

     

    As you said the web data just needs to be refreshed every six months, so I think exporting it into a csv file might improve the loading speed. But you still need to test this. 

     

    For dataflow, it is not available in My workspace. If you have access to other workspaces, you can create a dataflow there. Creating a dataflow - Power BI | Microsoft Docs

     

    Jing