Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more.
Get startedGrow your Fabric skills and prepare for the DP-600 certification exam by completing the latest Microsoft Fabric challenge.
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.
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.
Thanks @sturlaws for trying, unfortunately extracting the table didn't work. I'm getting the same error.
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
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.
@sbatool , refer if this can help
http://blog.datainspirations.com/2018/02/17/dynamic-web-contents-and-power-bi-refresh-errors/
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.
User | Count |
---|---|
80 | |
74 | |
62 | |
61 | |
45 |
User | Count |
---|---|
108 | |
97 | |
88 | |
81 | |
61 |