Forum Discussion
Import data from web with changing the sources
Annur2001,
You can. But the table structure in the two webpages are different(for example, some column name contain space), when you expand the custom column, you will find the data are not combined properly.
Thus I provide you another method, by choosing different parameters in the dropdown, then you can get different tables of different webpages, and you can append them later. Please download modified PBIX file to check details.
Regards,
Lydia
Anonymous
Could you please explain about creating parameters in detail?
What I mean in my question previously was whether possible to create like a table of province name then when I want to call the data of province that I need, I just type in or choose in the table instead of using edit queries tab and paste the new sources from a website. So, is it possible to do the same thing as getting the data from the website by changing the year tabs? as on youtube link below
Annur2001,
You can. But the table structure in the two webpages are different(for example, some column name contain space), when you expand the custom column, you will find the data are not combined properly.
Thus I provide you another method, by choosing different parameters in the dropdown, then you can get different tables of different webpages, and you can append them later. Please download modified PBIX file to check details.
Regards,
Lydia
Anonymous
That was great. Thank you so much, it helps me a lot.
I will append the data even though the columns name have different name or format (some of them have space).