Forum Discussion
Dynamic Web URL and On-Premise Gateway
Refresh issue is solved.
In addition to the m code, IT forgot to set the authentication method to anonymous for the web datasource.
Community SupportHi jimi_81 ,
Did you see the same error on the screen of settings?
If yes, you need add a new data source to the gateway via the hyperlink. It is a good idea to add corresponding data source paths to this gateway cluster for all your possible data sources. The gateway is like a bridge, you need to tell it where the data source is located because you are a dynamic data source. You only need to configure it once and you're done.
Refer:
Add or remove a gateway data source - Power BI | Microsoft Docs
Best Regards
Community Support Team _ chenwu zhu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Just an update, I have reworked the m code, after reading some documentation on Relative Path and Query:
Source = (pID as text) => let
Source = Web.Page(
Web.Contents(
"http://servername/sites/sharepointname/",
[
RelativePath = "_layouts/15/versions.aspx",
Query = [list="listname", ID = pID]
]
)
)I don't have access to diagnotics, but will try and have IT enable so that I can see what Power BI resolves the URL as.
After making the changes, the Power BI service will still not refresh the dataset. I am pretty confident that the m code is fine now.
Not having a setup screen to look at, if the gateway is configured for "http://servername/sites/sharepointname/", what settings or options need to be toggled for a standard mode gateway?
Refresh issue is solved.
In addition to the m code, IT forgot to set the authentication method to anonymous for the web datasource.