Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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
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,
Thanks for your message, we will wait for your response.
Thanks,
K Raghavender Rao
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
106 | |
105 | |
79 | |
69 | |
62 |
User | Count |
---|---|
143 | |
104 | |
103 | |
82 | |
70 |