Dynamic Web URL and On-Premise Gateway

Hi v-chenwuz-msft

Thank you for the reply

Below is the screenshot

The 1st item is the SharePoint list, the last item is the URL for the sharepoint version history.  

The SharePoint itself is 2013 and I believe uses AD for user permissions.  I had to put in an permission request for the IT power bi user, to access the web URL.  that has apparently taken place, yet the gateway still will not refresh.  I keep getting the same processing error: "Please make sure your data gateway (personal mode) is installed and configured properly."

Is there any guidance with setting up Web datasources?  The URL I have setup in the m code is essentially the URL for the sharepoint site, i.e. http://servername/sites/.../.../sharepointname/  .  If I were to click on the URL, it would bring me to the SharePoint site.  I am now wondering how the Power BI service wants to see the URL, and if I need to change the URL to be http://servername/sites/.../.../sharepointname/_layouts/15/, and then handle the versions.aspx, GUID and ID in the relativepath, as the function i have setup has ~ 180 unique URLs.

Appreciate the help

Dan

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?