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

Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!

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
April AMA free

Microsoft Fabric AMA Livestream

Join us Tuesday, April 09, 9:00 – 10:00 AM PST for a live, expert-led Q&A session on all things Microsoft Fabric!

March Fabric Community Update

Fabric Community Update - March 2024

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