Combine Same Set of Data from Different URL

[kolturra]

Hi Everyone,

I was asked this question in my interview, which I couldn't able to answer because I never got an opportunity to do this activity but after coming home I was doing the same activity with the example of what they have given to do in the interview.

They gave me URL as an example  https://www.moneycontrol.com/india/stockpricequote/A and this URL has data till Z. Only change the URL is the last letter. if you click on A you will get A URL details, if you click on B you will get B URL details likewise till Z. Somehow I am successful in combining data from A to Z URL in Power Query but I am not able to load this in Power BI UI. I am getting the below error. Is there any specific reason why I am not able to load it. Please help me.

I have kept my file in below link

https://1drv.ms/u/s!AlYy4z7ZT6i2gaYOCxdbLA0fZoEA4Q?e=Pr6r8L

Thanks,

K Raghavender Rao

[v-lid-msft]

Hi @kolturra ,

Based on my research, the html viewer custom viewer need use the html code , such as the text result of Web.Contents(URL), We test with sample code as following, but we got the same error as you, it works before when save tables, we will confirm with others and update here soon.

let
    Source = Table.FromRows(Json.Document(Binary.Decompress(Binary.FromText("i45WclTSUcooKSkottLXT8rMS9dLzs9VitWJVnJCkkjPz0/PSYVIxQIA", BinaryEncoding.Base64), Compression.Deflate)), let _t = ((type text) meta [Serialized.Text = true]) in type table [ID = _t, URL = _t]),
    #"Changed Type" = Table.TransformColumnTypes(Source,{{"ID", type text}, {"URL", type text}}),
    #"Added Custom" = Table.AddColumn(#"Changed Type", "Content", each Web.Contents([URL])),
    #"Transformed Column" = Table.TransformColumns(#"Added Custom",{{"Content", Text.FromBinary}})
in
    #"Transformed Column"

Best regards,

[kolturra]

Thanks for your message, we will wait for your response.

Thanks,

K Raghavender Rao