Forum Discussion

andyspa's avatar
andyspa
Icon for Helper I rankHelper 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
andyspa's avatar
andyspa
Icon for Helper I rankHelper 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
Icon for Community Support rankCommunity 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