Forum Discussion
Dynamic Web URL and On-Premise Gateway
- 4 years ago
Refresh issue is solved.
In addition to the m code, IT forgot to set the authentication method to anonymous for the web datasource.
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.