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 = [login to view URL]([login to view URL]("[login to view URL]"),[Delimiter=",", Columns=10, Encoding=1252, QuoteStyle=[login to view URL]]),
#"En-têtes promus" = [login to view URL](Source, [PromoteAllScalars=true]),
#"Type modifié" = [login to view URL](#"En-têtes promus",{{"Line Code", type text}, {"Line Name", type text}, {"Part Number", type text}, {"Part Description", type text}, {"Net Sales Units", [login to view URL]}, {"Order Point", [login to view URL]}, {"Date Of Last Sale", type date}, {"Store Number", [login to view URL]}, {"Store Short Name", type text}, {"Replacement Cost", type number}}),
#"Personnalisée ajoutée" = [login to view URL](#"Type modifié", "Part Number Clean", each [login to view URL]([Part Number],0,4)),
#"Requêtes fusionnées" = [login to view URL](#"Personnalisée ajoutée", {"Line Code"},brands, {"LINE CODE"}, "Personnalisée ajoutée", [login to view URL]),
#"Personnalisée ajoutée développé" = [login to view URL](#"Requêtes fusionnées", "Personnalisée ajoutée", {"BRAND CODE"}, {"BRAND CODE"}),
#"Personnalisée ajoutée1" = [login to view URL](#"Personnalisée ajoutée développé", "URL", each "[login to view URL]" & [BRAND CODE] & "/" & [Part Number Clean]),
#"Personnalisée ajoutée2" = [login to view URL](#"Personnalisée ajoutée1", "Anas", each [login to view URL]([URL])),
#"Personnalisée ajoutée3" = [login to view URL](#"Personnalisée ajoutée2", "Buyers Guide", each [login to view URL]([Anas],"{","}")),
#"Lignes filtrées" = [login to view URL](#"Personnalisée ajoutée3", each ([URL] <> null)),
#"Colonnes supprimées" = [login to view URL](#"Lignes filtrées",{"Anas"}),
#"Type modifié1" = [login to view URL](#"Colonnes supprimées",{{"Store Number", type text}}),
#"Valeur remplacée" = [login to view URL](#"Type modifié1","1","ST-HUBERT",[login to view URL],{"Store Number"}),
#"Valeur remplacée1" = [login to view URL](#"Valeur remplacée","2","ST-JEAN",[login to view URL],{"Store Number"}),
#"Valeur remplacée2" = [login to view URL](#"Valeur remplacée1","3","CHÂTEAU",[login to view URL],{"Store Number"}),
#"Type modifié2" = [login to view URL](#"Valeur remplacée2",{{"Date Of Last Sale", type datetime}})
in
#"Type modifié2"