https web datasource error

[sbatool]

Hi team,

I have been unsuccessful in connecting to a https website from the Power BI desktop when connecting through Web source. I am getting the following error:

I have tried the following m code to get the URL from a parameter (because we want the year to be different in the URL):
let
URL = __lpt_TimeDateURL & __lpt_TimeDateYear & __lpt_FileType,
Source = Web.BrowserContents(URL)
in
Source

I get the following message to edit credentials, for which I use Anonymous.

Then I get the following error again:

I have cleard data load cache, increased the limit of cache, cleared the permissions for this source in Data source settings and saved Anonymous again. I have added this URL in the Trusted sites in my Internet Explorer too but all with no avail.
Please let me know if I am missing something.

[sturlaws]

Hi @sbatool 

I am not able to recreate your issue. This code works fine when I test it:

What might be missing in your m code is the selection of which table you want to extract from the web page.

[sbatool]

Thanks @sturlaws for trying, unfortunately extracting the table didn't work. I'm getting the same error.

[v-deddai1-msft]

Hi @sbatool ,

Did you set the type for your parameter _year in your case to text?

Would you please show us the m query for it?

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Best Regards,

Dedmon Dai

[sbatool]

Hi @v-deddai1-msft, yes I used text as the Type for year. It seems it's my work network that's blocking the https because I had no issues using the same method in my personal laptop.

[amitchandak]

@sbatool , refer if this can help

http://blog.datainspirations.com/2018/02/17/dynamic-web-contents-and-power-bi-refresh-errors/

[sbatool]

Thanks @amitchandak for sharing the link. The link refers to the refresh issues whereas in my case I am unable to connect to any https at all in power bi desktop from my work laptop. I can connect to this link with no issues from my personal laptop. I am unsure if I am missing any security settings.