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 PBI community, have to seek help for this one.
So i need to set up a call to this api.
https://data.xotelo.com/api/rates?hotel_key=g297930-d305178&chk_in=2021-03-25&chk_out=2021-03-26
After changing with a function all relevant parts in order to obtain data what the api returns is something like this:
it should be a sort of JSON format response however the format seems not suitable to be fetched by power bi:
I also tried to use the "add table based on example" however it says that it canìt find any CSS selector for example values.
Hence it's impossible to get any data out of this.
Do you know any way I can work out a solution?
thank you
Alberto
Solved! Go to Solution.
Hi @abartozzi
Download example PBIX with the following code
The JSON returned from the API is valid. To get it you can wrap the Web.Contents function in Json.Document like this
let
Source = Json.Document(Web.Contents("https://data.xotelo.com/api/rates?hotel_key=g297930-d305178&chk_in=2021-03-25&chk_out=2021-03-26")),
result = Source[result],
#"Converted to Table" = Record.ToTable(result)
in
#"Converted to Table"
Regards
Phil
Proud to be a Super User!
Hello, I found a web page that contains some data that interests me but is visualized with power BI. How do I get that data and upload it to my power BI?
Hi @abartozzi
Download example PBIX with the following code
The JSON returned from the API is valid. To get it you can wrap the Web.Contents function in Json.Document like this
let
Source = Json.Document(Web.Contents("https://data.xotelo.com/api/rates?hotel_key=g297930-d305178&chk_in=2021-03-25&chk_out=2021-03-26")),
result = Source[result],
#"Converted to Table" = Record.ToTable(result)
in
#"Converted to Table"
Regards
Phil
Proud to be a Super User!
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 |
---|---|
112 | |
100 | |
77 | |
74 | |
49 |
User | Count |
---|---|
146 | |
108 | |
106 | |
90 | |
62 |