cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Flootifloo
New Member

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
Flootifloo
New Member

@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
Flootifloo
New Member

@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 @Flootifloo  Have you solved this problem? I had the same error message when mapping ip address.

amitchandak
Super User
Super User

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

 

Can you try to take it as web and try



!! Microsoft Fabric !!
Microsoft Power BI Learning Resources, 2023 !!
Learn Power BI - Full Course with Dec-2022, with Window, Index, Offset, 100+ Topics !!
Did I answer your question? Mark my post as a solution! Appreciate your Kudos !! Proud to be a Super User! !!

Helpful resources

Announcements
May 2023 update

Power BI May 2023 Update

Find out more about the May 2023 update.

Submit your Data Story

Data Stories Gallery

Share your Data Story with the Community in the Data Stories Gallery.

Top Solution Authors