Help with Power BI Incremental refresh and Auto Refresh

Job ID: 36720839

Budget: $10 – $30 CAD

I built my Power BI with multiple sources which are simply CSV documents from a web URL and in some data soucre, i add some steps which builds an URL and query a web API to get results.

I need to get incremental refresh because it takes 3 hours + to update my data and i would like it updated like 2 times a day in the web services.

Never managed to make Incremental working + Online when i want to schedule update i get this error:

You can't schedule refresh for this dataset because the following data sources currently don't support refresh:
Data source for Query1

If invermental cant work, i can live with only on daily update on the Power BI service website . Since i cant share data and i want to learn, we can do this work together on Any Desk.

let
Source = Csv.Document(Web.Contents("https://www.domain.ca/folder/filename.csv"),[Delimiter=",", Columns=10, Encoding=1252, QuoteStyle=QuoteStyle.None]),
#"En-têtes promus" = Table.PromoteHeaders(Source, [PromoteAllScalars=true]),
#"Type modifié" = Table.TransformColumnTypes(#"En-têtes promus",{{"Line Code", type text}, {"Line Name", type text}, {"Part Number", type text}, {"Part Description", type text}, {"Net Sales Units", Int64.Type}, {"Order Point", Int64.Type}, {"Date Of Last Sale", type date}, {"Store Number", Int64.Type}, {"Store Short Name", type text}, {"Replacement Cost", type number}}),
#"Personnalisée ajoutée" = Table.AddColumn(#"Type modifié", "Part Number Clean", each Text.RemoveRange([Part Number],0,4)),
#"Requêtes fusionnées" = Table.NestedJoin(#"Personnalisée ajoutée", {"Line Code"},brands, {"LINE CODE"}, "Personnalisée ajoutée", JoinKind.LeftOuter),
#"Personnalisée ajoutée développé" = Table.ExpandTableColumn(#"Requêtes fusionnées", "Personnalisée ajoutée", {"BRAND CODE"}, {"BRAND CODE"}),
#"Personnalisée ajoutée1" = Table.AddColumn(#"Personnalisée ajoutée développé", "URL", each "https://strapi.gamcar.ca/api/getAllFitVehicle2/" & [BRAND CODE] & "/" & [Part Number Clean]),
#"Personnalisée ajoutée2" = Table.AddColumn(#"Personnalisée ajoutée1", "Anas", each Web.BrowserContents([URL])),
#"Personnalisée ajoutée3" = Table.AddColumn(#"Personnalisée ajoutée2", "Buyers Guide", each Text.BetweenDelimiters([Anas],"{","}")),
#"Lignes filtrées" = Table.SelectRows(#"Personnalisée ajoutée3", each ([URL] <> null)),
#"Colonnes supprimées" = Table.RemoveColumns(#"Lignes filtrées",{"Anas"}),
#"Type modifié1" = Table.TransformColumnTypes(#"Colonnes supprimées",{{"Store Number", type text}}),
#"Valeur remplacée" = Table.ReplaceValue(#"Type modifié1","1","ST-HUBERT",Replacer.ReplaceText,{"Store Number"}),
#"Valeur remplacée1" = Table.ReplaceValue(#"Valeur remplacée","2","ST-JEAN",Replacer.ReplaceText,{"Store Number"}),
#"Valeur remplacée2" = Table.ReplaceValue(#"Valeur remplacée1","3","CHÂTEAU",Replacer.ReplaceText,{"Store Number"}),
#"Type modifié2" = Table.TransformColumnTypes(#"Valeur remplacée2",{{"Date Of Last Sale", type datetime}})
in
#"Type modifié2"
Related categories: Power BI Microsoft PowerBI