Forum Discussion
Web source for inflation and fx
Hi , mfc
I suspect this is because the website will only load part of the data in the beginning. When you continue to pull down the table, the website will continue to send queries to the background to load the rest data.
When you use "connect to web", the data storage mode is import .
Since it is so, it will be a better choice to download the data in excel and import it into powerbi.
Best Regards,
Community Support Team _ Eason
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Community Support, thanks for your answer, the problem I had and still have, is that for some reason the table get loaded only until Cuba. Any idea on why the table migth get loaded only partly? Thanks very much, I really appreciate your help`!
- v-easonf-msft
Hi , mfc
I suspect this is because the website will only load part of the data in the beginning. When you continue to pull down the table, the website will continue to send queries to the background to load the rest data.
When you use "connect to web", the data storage mode is import .
Since it is so, it will be a better choice to download the data in excel and import it into powerbi.
Best Regards,
Community Support Team _ Eason
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.