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

  • Anonymous's avatar
    Anonymous
    Not applicable
    5 years ago

    This is the function. We used it to make the text look better in the report.

     

    (PageStart as text) => 

let
    Source = Xml.Tables(Web.Contents("https://bioguideretro.congress.gov/Static_Files/data/"&PageStart&".xml"))
in
    Source

     

    This is the error I get in the service. I have narrowed the refresh problems down to the XML queries. I really do appreciate your help!!

     

    You can't schedule refresh for this dataset because the following data sources currently don't support refresh:
Data source for Query1
    • Anonymous's avatar
      Anonymous
      Not applicable
      5 years ago

      Thanks!!  It appears to be working. I am going to schedule a refresh to run in about 30 mins to make sure the auto refresh works and will reply back to the thread. Thank you so much! 

      • Anonymous's avatar
        Anonymous
        Not applicable
        5 years ago

        Scheduled refresh worked perfectly! Thanks!!