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.

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!!