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

WEB source

 

I noticed that on a computer that had the latest version of power BI installed, the link http://www.imdb.com/chart/top would not open.

 

I receive an error that states :

 

We have encountered an error while trying to connect.

 

Details: The supplied URL must be a valid "http" or "https" URL

 

The funn thing is that all other websites work. (I tried a few random ones). The issue is only with IMDB. I restarted my system, opened a new power BI project, but it still doesn't work.

 

When I opened the same link on another system that had the older version, it worked just fine.

 

Any Ideas as to what is going on??


Another user also faced a similar issue : http://community.powerbi.com/t5/Desktop/Web-Data-Sources-connection-problem/m-p/160466#M69750

PS: I am new to power BI, so would really appreciate the help

1 ACCEPTED SOLUTION
Sean
Community Champion
Community Champion

Version: 2.56.5023.1021 64-bit (March 2018) - March 19, 2018 - seems to have fixed this! Smiley Happy

 

Thank You! Smiley Happy

 

Update at:

https://www.microsoft.com/en-us/download/details.aspx?id=45331

 

View solution in original post

13 REPLIES 13
Reubenjac
New Member

Capture2.JPGCapture.JPGCapture3.JPG

Hi @Reubenjac,

 

As I said in my version (latest one is working) I already had also some issues that in my computer was not working but in other computer everything was ok.

 

Post this on the Issues forum you will get a contact from the developers to help you better.

 

Also post the link to this post in order for the developers check that other are not facing the same issue.

 

Regards,

MFelix


Regards

Miguel Félix


Did I answer your question? Mark my post as a solution!

Proud to be a Super User!

Check out my blog: Power BI em Português



Sean
Community Champion
Community Champion

I am encountering the same issue as described above with @Reubenjac's IMDB link

 

My actual issue is with a different https: url

My file updates every monday - last monday the 5th (before the update) all was fine Smiley Happy

but now 12th (after update) I  just got this message - the url must be valid etc.... Smiley Sad

Well the url is working - opens fine in any browser! (Firefox, Edge, Chrome)

 

Regretfully I just cleaned my Downloads folder and can't revert to any previous PBI versions to test in those

After last month's "&" ordeal I still deleted all older versions - should have kept at least 1 backup working PBI version

 

@MarcelBeug@ImkeFany ideas/suggestions as always will be greatly appreciated Smiley Happy

 

URL Must be Valid.png

 

In PBI this is what happens with @Reubenjac's link http://www.imdb.com/chart/top

 

URL Invalid PBI.gif

 

In Excel Power Query on the other hand all seems fine... with both my link and the IMDB link...

 

URL Valid Excel.gif

 

Thanks! Smiley Happy

 

 

Hi @Sean,

 

As I said my version works well.

 

If you want to revert to a previous version follow this link

 

Regards,

MFelix


Regards

Miguel Félix


Did I answer your question? Mark my post as a solution!

Proud to be a Super User!

Check out my blog: Power BI em Português



Hi @Sean,

this link works for me: http://www.imdb.com/chart/top (although it takes quite some time).

Please clear your cache and try again.

Cheers, Imke

Imke Feldmann (The BIccountant)

If you liked my solution, please give it a thumbs up. And if I did answer your question, please mark this post as a solution. Thanks!

How to integrate M-code into your solution -- How to get your questions answered quickly -- How to provide sample data -- Check out more PBI- learning resources here -- Performance Tipps for M-queries

Hi @Sean,

just recognized that I was using an old version. I'm now getting the same error as you, so it's pretty likely that this is a bug unfortunately.

Imke Feldmann (The BIccountant)

If you liked my solution, please give it a thumbs up. And if I did answer your question, please mark this post as a solution. Thanks!

How to integrate M-code into your solution -- How to get your questions answered quickly -- How to provide sample data -- Check out more PBI- learning resources here -- Performance Tipps for M-queries

Sean
Community Champion
Community Champion

@ImkeF- Thank You for confirming! Yes I've not been able to refresh in both March 2018 Versions they've released so far!

2.56.5023.861 - March 7 and

2.56.5023.942 - March 12

Both don't work and say URL is Invalid!

 

@MFelix- Thank you for the link!

Indeed I can confirm now that after downgrading to the Feb 2018 version I was able to Refresh the Data

(the link was to the PBI version that had the "&" Issue so I had to move the file to a temp folder and then open and refresh)

However the data refresh happens with no problem in the Feb 2018!

Then I updated again to the latest and Issue is again there but at least I got the newest data in the PBIX I needed!

 

Hope they fix this soon! Smiley Happy

I experience the same problem on all my computers with the latest PowerBI installed. Untill two weeks ago I had no problems loading two separate web links, now I get the "The supplied URL must be a valid 'http:' or 'https:' URL." error. 

 

Hope this gets fixed soon. 

BTW: This seems to be a problem of the Web.Page-function, as the Lines.FromBinary(Web.Contents.. -version works fine.

Imke Feldmann (The BIccountant)

If you liked my solution, please give it a thumbs up. And if I did answer your question, please mark this post as a solution. Thanks!

How to integrate M-code into your solution -- How to get your questions answered quickly -- How to provide sample data -- Check out more PBI- learning resources here -- Performance Tipps for M-queries

Sean
Community Champion
Community Champion

Version: 2.56.5023.1021 64-bit (March 2018) - March 19, 2018 - seems to have fixed this! Smiley Happy

 

Thank You! Smiley Happy

 

Update at:

https://www.microsoft.com/en-us/download/details.aspx?id=45331

 

Sean
Community Champion
Community Champion

Issue Created here

http://community.powerbi.com/t5/Issues/The-supplied-URL-must-be-a-valid-http-or-https-URL/idi-p/3747...

If you experience the same please VOTE at the above

Thanks! Smiley Happy

MFelix
Super User
Super User

Hi @Reubenjac,

 

I'm using the March 2018 updated 64bit version and everything is working ok on the link.

 

Did you try File | Options | Data source settings and clearing the permissions as there was in the post you mentioned.

 

Regards,

MFelix

 

 


Regards

Miguel Félix


Did I answer your question? Mark my post as a solution!

Proud to be a Super User!

Check out my blog: Power BI em Português



Thanks for the reply @MFelix. However, despite clearing the permissions in the data file settings, the problem persits 😞

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.