Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago
Solved

Unable to refresh Dynamic Data Sources

We are building a Power BI report and need the biographies of Congressional officials. However, because this is a dynamic data source, we cannot schedule refreshes in the Power BI service. M query is...
Need Help
  • ibarrau's avatar
    ibarrau
    5 years ago

    There you go. Always try to keep best web.contents best practices made by Chris Webb. You can check an example here:

    https://blog.ladataweb.com.ar/post/630597294839955456/powerquery-buena-práctica-para-un-web-request

    If you change your function like this, it should recognize the data source. Be sure to make all data sources with the same privacy levels (it's recommended to use organizational)

    (PageStart as text) => 
let
    Source = Xml.Tables(Web.Contents("https://bioguideretro.congress.gov/", [RelativePath= "Static_Files/data/"&PageStart&".xml"]))
in
    Source

    I hope that helps.

ibarrau's avatar
ibarrau
Super User
5 years ago

Hi. I don't think there is a problem with that xml. That should work pretty good. Can you show us the function fxBIO() ? that one is the responsable for the issue.

Let's see if we can find a solution together