Forum Discussion

Annur2001's avatar
Annur2001
Regular Visitor
8 years ago
Solved

Import data from web with changing the sources

Hi,   I want to import data from Wikipedia regarding the name of a province that each of it has suburbs or villages name. There are 34 provinces that I need to import and each province will have mo...
Need Help
Show and Tell
Tutorial Requests
  • Anonymous's avatar
    Anonymous
    8 years ago

    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's avatar
Anonymous
Not applicable
8 years ago

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

Annur2001's avatar
Annur2001
Regular Visitor
8 years ago

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).