Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
7 years ago
Solved

Scheduled Refresh with Web Source Not Working

Hi all,   I have built a PBI report on PBI Desktop using SQL database and Web as data sources. The Web source is used to call http://useragentstring.com and the report passes user agent values in ...
Refresh
Report Server
scheduled refresh. web source
Matija's avatar
Matija
Frequent Visitor
7 years ago

I have the same issue. I get a message on the dataset in Power BI Service: Query contains unsupported function. Function name: Web.Contents. In Data Sorce settings in Power BI desktop, I see: “Some data sources may not be listed because of hand-authored queries”, even though I changed all data sources to Public as suggested in this blog.

 

Apparently, there is a Skip test connection function added recently which might solve this issue but I cannot find it in Power BI Service (or desktop for that matter).

 

Any thoughts Power people?

 

 

  • Matija's avatar
    Matija
    Frequent Visitor
    7 years ago

    Does anybody have an idea?

     

    Maybe there is a better way to fetch data from API, something I can use instead of Web.contents function?

    • dpombal's avatar
      dpombal
      Post Partisan
      7 years ago

      Hi all, I am having same problems with Scheduled refresh

      In content i am getting the contents of a excel file in sharepoint

       

       

      CUSTOM_FUNCTION

      (content) =>
      let
      Origen = Excel.Workbook(Web.Contents(content), null, true),
      #"ATR Contract Report_Sheet" = Origen{[Item="ATR Contract Report",Kind="Sheet"]}[Data],
      #"XXX" = Table.PromoteHeaders(#"ATR Contract Report_Sheet", [PromoteAllScalars=true]),
      #"XX"

       

       

      let
      Origen = SharePoint.Files("https://sharepoint.com/teams/XXXXX/", [ApiVersion = 15]),
      #"Filas filtradas" = Table.SelectRows(Origen, each Text.Contains([Folder Path], "Data/")),
      #"Otras columnas quitadas" = Table.SelectColumns(#"Filas filtradas2",{"Content", "Name", "Folder Path"}),
      #"Columna duplicada" = Table.DuplicateColumn(#"Otras columnas quitadas", "Name", "Name - Copia"),
      #"Valor reemplazado" = Table.ReplaceValue(#"Columna duplicada","ATRContract_Report_","",Replacer.ReplaceText,{"Name - Copia"}),
      #"Columnas con nombre cambiado" = Table.RenameColumns(#"Valor reemplazado",{{"Name - Copia", "Fecha"}}),
      #"Primeros caracteres extraídos" = Table.TransformColumns(#"Columnas con nombre cambiado", {{"Fecha", each Text.Start(_, 8), type text}}),
      #"Tipo cambiado" = Table.TransformColumnTypes(#"Primeros caracteres extraídos",{{"Fecha", type date}}),
      #"Columnas reordenadas" = Table.ReorderColumns(#"Tipo cambiado",{"Fecha", "Name","Folder Path", "Content"}),
      #"Personalizada agregada" = Table.AddColumn(#"Columnas reordenadas", "Personalizado", each CUSTOM_FUNCTION([Folder Path]&[Name])),
      #"Columnas quitadas" = Table.RemoveColumns(#"Personalizada agregada",{"Folder Path", "Content"}),

       

       

       

      Thanks in advance