Help with Power BI Incremental refresh and Auto Refresh

Ditutup Disiarkan 3 bulan lepas Dibayar semasa penghantaran
Ditutup Dibayar semasa penghantaran

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

ID Projek: #36720839

Tentang projek

12 cadangan Projek jarak jauh Aktif 2 bulan lepas

12 pekerja bebas membida secara purata $58 untuk pekerjaan ini


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 Lagi

$100 CAD dalam sehari
(67 Ulasan)

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 Lagi

$120 CAD dalam 2 hari
(4 Ulasan)

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 Lagi

$100 CAD dalam 2 hari
(0 Ulasan)

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 Lagi

$20 CAD dalam 7 hari
(1 Ulasan)

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 Lagi

$80 CAD dalam sehari
(0 Ulasan)

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 Lagi

$10 CAD dalam 7 hari
(0 Ulasan)

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

$20 CAD dalam 7 hari
(0 Ulasan)

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 Lagi

$40 CAD dalam 5 hari
(0 Ulasan)

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 Lagi

$50 CAD dalam 3 hari
(0 Ulasan)

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

$30 CAD dalam 3 hari
(0 Ulasan)

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 dalam 2 hari
(0 Ulasan)