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

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.

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
Microsoft Fabric Learn Together

Microsoft Fabric Learn Together

Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City

PBI_APRIL_CAROUSEL1

Power BI Monthly Update - April 2024

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

April Fabric Community Update

Fabric Community Update - April 2024

Find out what's new and trending in the Fabric Community.