1

I have a dilemma.

I'm picking up data from this page where I can have a clear view of all lithium companies listed on the Australian market. So this means that the data source is... web!

enter image description here

I save and publish the dashboard on my Power BI account and because the source is Web I would like Power BI to automatically refresh the data every few hours.

But apparently it doesn't work like that.

My Power BI account is asking me to install a Gateway connection, thig that you usually do for an on-prem data source:

enter image description here

You don't have any data gateways. We didn't find any suitable data gateways to connect to the data sources that this dataset uses. Either install an on-premises data gateway and add the data sources that this dataset uses to it, or install a data gateway in personal mode to connect this dataset to its data sources

This is so idiotic.

The data are coming from the web, there is no point to install any gateway connection whatsoever.

I've seen that other folks are having the same problem:

Please, tell me I'm absolutely wrong and there is an easy way out of this.

Thank you

EDIT: @ffffrank tried to help me out but the solution isn't working.

Plus I believe the root cause is something else:

enter image description here

Last refresh failed: Fri Apr 22 2022 10:41:47 GMT+0200 (Central European Summer Time)
Scheduled refresh has been disabled.Hide details
Data source error:  Scheduled refresh is disabled because at least one data source is missing credentials. To start the refresh again, go to this dataset's settings page and enter credentials for all data sources. Then reactivate scheduled refresh.
Francesco Mantovani
  • 10,216
  • 13
  • 73
  • 113

1 Answers1

1

Go to Power Query and Advanced editor. Your first line hopefully looks something like this:

Source = Web.BrowserContents("https://www.marketindex.com.au/commodities/lithium")

Switch it to:

Source = Web.Contents("https://www.marketindex.com.au/commodities/lithium")

Now it should work without a gateway.

ffffrank
  • 514
  • 4
  • 11
  • Thank you @ffffrank, I'm checking it out and I will let you know in a few days. – Francesco Mantovani May 15 '22 at 19:26
  • Hi @ffffrank, your solution is not working. I edited my question. I think the problem is about the schedule refresh – Francesco Mantovani May 17 '22 at 09:10
  • Hello @FrancescoMantovani yes, that is expected. Now you should go to your datasets Settings and under Data Source Credentials, configure the dataset to use anonymous credentials for connecting. – ffffrank May 17 '22 at 19:04
  • Data source credentials is grayed out – Francesco Mantovani May 18 '22 at 07:38
  • 1
    It seems like this may be an issue with the specific website that is being connected to. – Matt Kocak Jun 24 '22 at 17:59
  • @ffffrank , I can confirm you that your suggestion doesn't work: https://imgur.com/INxEfsW . In this example I'm using the NBA ranking page as example form here: https://www.nba.com/standings . There might have been a day when switching from `Web.BrowserContents` to `Web.Contents` would have made the tick but that day has long done and probably the majority of the pages out there are nowadays incompatible with this solution. But thank you so much for trying to help. Many times easy problems have hard solutions.... – Francesco Mantovani Jun 25 '22 at 21:41
  • @MattKocak I tested now with https://www.nba.com/standings page and the problem is the same, switching from `Web.BrowserContent`s to `Web.Contents` doesn't work. Any page you can suggest to use as test? – Francesco Mantovani Jun 25 '22 at 21:44
  • Maybe the following page has some solutions to the grayed out Data source credentials section. It’s not something that I have experienced. https://community.powerbi.com/t5/Service/Data-Source-Credentials-Greyed-out/m-p/519216 – Matt Kocak Jun 25 '22 at 23:10