Help with Power BI Incremental refresh and Auto Refresh

Suljettu Julkaistu 3 kuukautta sitten Maksettu toimituksen yhteydessä
Suljettu Maksettu toimituksen yhteydessä

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.


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}})


#"Type modifié2"

Power BI Microsoft PowerBI

Projektin tunnus: #36720839

Tietoa projektista

12 ehdotusta Etäprojekti Aktiivinen 2 kuukautta sitten

12 freelanceria on tarjonnut keskimäärin $58 tähän työhön


Hi There, Good evening! I have gone through your requirement. I have worked on the similar type of requirements in past. Please ping to discuss more on the project. Below is my intro - "First use then bel Lisää

$100 CAD 1 päivässä
(67 arvostelua)

Greetings, I understand that you are seeking a professional with expertise in data visualization and dashboard creation using Power BI. As a data expert with extensive experience in Power BI, I possess the necessary s Lisää

$120 CAD 2 päivässä
(4 arvostelua)

Hello there, My name is Pomarides and I am a professional IT Consultant with 14 years of experience in web and Windows software development. I understand you need help with Power BI incremental refresh and auto refres Lisää

$100 CAD 2 päivässä
(0 arvostelua)

Hi, I encourage you to please read this cover letter with a keen interest to give me a chance to help. I am Venkat Sudhakar Gupta, I have read your job details, requirements and the process and I am passionate about be Lisää

$20 CAD 7 päivässä
(1 arvostelu)

I can help you create incremental refresh of data. I'm working with Power BI daily, we can collaborate through a chat platform to discuss your requirements and ensure a collaborative approach. Let's connect to explore Lisää

$80 CAD 1 päivässä
(0 arvostelua)

I am a data analyst with over 2 years of experience in handling Microsoft Excel - Power BI. I consider myself a highly skilled professional in interpreting and analyzing data to extract insights and generate valuable v Lisää

$10 CAD 7 päivässä
(0 arvostelua)

working as a data analyst from last five years in MNC company and developed hundreds of dashboards in power bi.

$20 CAD 7 päivässä
(0 arvostelua)

Hi, Regarding your project, I can complete this task because I possess excellent skills in data visualization using Excel and Power BI. I have completed several similar projects, including HR, customer analytics, supe Lisää

$40 CAD 5 päivässä
(0 arvostelua)

Hi, I can help you to using how incremental dataset in Power BI working. Step by step we need check : - Using Parameter - Check Query folding on the table - Using partion on Tabular Looking forward to hearing from Lisää

$50 CAD 3 päivässä
(0 arvostelua)

I have a Master's degree in data analytics and am certified by Microsoft as a Power BI Data Analyst. I have many years of experience with technical support in addition to Power BI. We can solve your error together - Lisää

$30 CAD 3 päivässä
(0 arvostelua)

Hi there, I have worked on similar so I can work on increment refresh so i can do it and hoping lets connect and do it together. Regards yaseens

$20 CAD 2 päivässä
(0 arvostelua)