Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Grow your Fabric skills and prepare for the DP-600 certification exam by completing the latest Microsoft Fabric challenge.

Reply
Anonymous
Not applicable

Typing probleme during Getting IP Address Details from IP Address

Hello After using this fn to Getting IP Address Details from IP Address

 

Flootifloo_0-1632927121106.png

tuto : "https://community.powerbi.com/t5/Desktop/IP-address-mapping/m-p/138436"

 

I have this result :

 

Flootifloo_1-1632927207867.png

 

with this error message :

Flootifloo_2-1632927229231.png

"DataSource.Error: The downloaded data is of type HTML, which is not the expected type. The URL may be wrong, or you may not have provided the correct credentials to the server."

I looked at all the other forum topics about this and it seems to work for everyone, I don't understand where the problem could come from.
Waiting for an answer. Thks

 

 

 

1 ACCEPTED SOLUTION
Anonymous
Not applicable

@amitchandak  thx for your your help,

 

I know where is the problem, from
"Source = Json.Document(Web.Contents("http://freegeoip.net/json/" & #"IP Address")),"
I tryed to change http://freegeoip.net/json/ -> http://freegeoip.net/html/ , but not worked.

And I tryed some others issus but same error message ...

I dont know how import data in JSON or change expecting data in html.

View solution in original post

3 REPLIES 3
Anonymous
Not applicable

@amitchandak  thx for your your help,

 

I know where is the problem, from
"Source = Json.Document(Web.Contents("http://freegeoip.net/json/" & #"IP Address")),"
I tryed to change http://freegeoip.net/json/ -> http://freegeoip.net/html/ , but not worked.

And I tryed some others issus but same error message ...

I dont know how import data in JSON or change expecting data in html.

Hi @Anonymous  Have you solved this problem? I had the same error message when mapping ip address.

amitchandak
Super User
Super User

@Anonymous , It was expecting a JSON and it is getting HTML.

 

Can you try to take it as web and try

Helpful resources

Announcements
RTI Forums Carousel3

New forum boards available in Real-Time Intelligence.

Ask questions in Eventhouse and KQL, Eventstream, and Reflex.

MayPowerBICarousel1

Power BI Monthly Update - May 2024

Check out the May 2024 Power BI update to learn about new features.