Power BI - Consumption of a table from Web URL where no of column changes

[Anonymous]

Hello All,

We have a requirement to consume a table from web url into Power BI. The challenge in consuming the table is that columns are not static. it will change, sometimes it may have 5 columns, sometimes 4 or only 3 columns . When data is not available for a particular column, Table in the Web will not show that column.

For Example:

In the above picture, you can see first table showing 4 columns, 2nd table showing 5 columns, & 3rd showing 5 columns. We are ok to pass null or blank if column is not there. But we are not able to achive it in power BI.

When we build the data transformation then it will take the mapping of that time column but later column changes. so transformation failed. Cretae table from Example in Get data from Web also has same issue.

Kindly suggest how to solve the issue.

Thanks,

PBI V2

[Anonymous · Accepted solution]

Hi @Anonymous ,

It depends on the data structure of the site's source table, usually powerbi will automatically fill in the blanks, you can refer to the specifics:Tutorial: Import and analyze data from a webpage - Power BI | Microsoft Learn

Hope it helps!

Best regards,
Community Support Team_ Scott Chang

If this post helps then please consider Accept it as the solution to help the other members find it more quickly.

[Anonymous]

Hello @Anonymous ,

Thanks for your response. I am sorry that I forget to mention one important point which may helps in resolving the issue. Below is the detail:

1) We have a table say ServerMaster which contains server Name & its URL
2) Created a parameter to pass Server URL
3) We have created a custom function in which we pass the URL from table (ServerMaster ) & Get the server details from the web. Total 10 columns
4) Somtimes when we pass the url and Web does not contain a particular column which is available in fucntion definition then it will fail e.g web contains only 8 or 9 columns

Wanted to check the possibility of below:
1) Is it possible to create a function that will return all the columns regardless of how much columns a web is returning e.g total 10 columns
2) if we get fewer columns then function will return remaining columns as NULL or blank

3) Is it possible to store all the columns values into variable or parameter then we create a table so that we can handle columns which are not coming.

Thanks,

PBI V2

[Anonymous]

Hi @Anonymous ,

In powerbi, the first method is more applicable.

Best regards,
Community Support Team_ Scott Chang