Find Jobs
Hire Freelancers

Help with Power BI Incremental refresh and Auto Refresh

$10-30 CAD

Lezárt
Kiadva ekkor: 10 hónappal ezelőtt

$10-30 CAD

Teljesítéskor fizetve
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"
Projektazonosító: 36720839

A projektről

12 ajánlat
Távolról teljesíthető projekt
Aktiválva: 9 hónappal ezelőtt

Szeretne pénzt keresni?

A Freelancer oldalán történő árajánlatadás előnyei

Határozzon meg költségvetést és időkeretet
Kapja meg fizetését a munkáért
Vázolja ajánlatát
Ingyen regisztrálhat és adhat árajánlatot munkákra
12 szabadúszó adott átlagosan $58 CAD összegű árajánlatot erre a munkára
Felhasználó avatár
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 believe". I don't want to mention much here but I have 6+ years of extensive experience in Power BI along with Power Apps, Power Automate, Python & AWS with total 8+ years of IT experience. I am not intelligent, but I try to complete the work ASAP as I don't believe in deadline. I don't believe in saying rather my work speaks. It's our first collaboration that's why I have to describe my proposal or else I prefer not to as it won't be needed next time. ✅ You can go through my profile to see my past works in Freelancer site ==> https://www.freelancer.com/u/Akmanyu
$100 CAD 1 napon belül
4,9 (67 értékelés)
5,5
5,5
Felhasználó avatár
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 skills to meet your requirements. My experience includes knowledge and application of data modeling, data analysis, data transformation, and data visualization using Power BI. I am proficient in creating visually appealing dashboards and reports that are easy to understand and interpret. My skills include data cleaning, transformation, and shaping to meet your specific business needs. I have also worked with various data sources, including Excel, SQL Server, SharePoint, and more. In addition to my expertise in Power BI, I am also a Certified Chartered Accountant and Member of ACCA (UK), with 7 years of experience in finance and accounting. I have experience in accounting and bookkeeping, which can help me create dashboards that cater to your specific financial needs. Please let me know if you have any questions or concerns. I am looking forward to working with you! ***----My Previous Projects related to your work-----***: https://www.freelancer.com/projects/power-bi/Modify-old-create-new-power https://www.freelancer.com/projects/power-bi/PowerBI-Power-Query-Removing-duplicate https://www.freelancer.com/projects/power-bi/PowerBI-Power-Query-Removing-duplicate
$120 CAD 2 napon belül
4,9 (4 értékelés)
2,8
2,8
Felhasználó avatár
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 refresh and would be thrilled to help you with this project. As part of the project, I would be able to provide the necessary technical assistance on Oracle EBS as well as cloud applications such as Power BI. Additionally, I have extensive experience in setting up an automatic extract and load with script shell and cronjob so that your data can be updated quickly when required. I believe I would be the perfect fit for this project due to my extensive knowledge of Power BI, Oracle EBS, cloud applications and data migrations as well as training and work related to ETL, Data Warehouse, data mining, NoSQL and MDX. Please let me know if you'd like me to discuss further or if you have any other questions? Best regards! Bonjour!
$100 CAD 2 napon belül
0,0 (0 értékelés)
0,0
0,0
Felhasználó avatár
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 becoming a part of your team. I have done a lot of similar projects on creating and integrating of Microsoft PowerBI dashboards and reports on other freelancing platform and please see my bio and please refer to my profile page Education: My credentials include a MCA Certification. In addition, I have a data science Certificate from the IIIT-B. Work Experience Over the last 5 years, I had worked remotely with leading business consulting companies in the. More recently, I have worked as a PowerBI developer. where I successfully implemented over 30 projects on PowerBI. I am available to communicate with you, in any channel that is convenient for you, so please send me a message and let me get to work Regards
$20 CAD 7 napon belül
1,0 (1 értékelés)
0,0
0,0
Felhasználó avatár
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 the details further. I'm open to using anydesk so we can work together. Looking forward to working with you.
$80 CAD 1 napon belül
0,0 (0 értékelés)
0,0
0,0
Felhasználó avatár
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 visualizations for business decision-making. My proficiency in Power BI enables me to transform raw data into interactive visualizations and dashboards that effectively communicate key findings to different audiences. I look forward to hearing from you to learn more about the topic.
$10 CAD 7 napon belül
0,0 (0 értékelés)
0,0
0,0
Felhasználó avatár
working as a data analyst from last five years in MNC company and developed hundreds of dashboards in power bi.
$20 CAD 7 napon belül
0,0 (0 értékelés)
0,0
0,0
Felhasználó avatár
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, supermarket sales, and superstore analysis. I specialize in creating dynamic dashboards, which you can see examples of in my portfolio. Additionally, I hold two certifications in the field of data analysis, which cover data entry, cleaning, analysis, visualization, and Python. I am available to start immediately or at a time that is convenient for you. Thank you for considering my application. I look forward to working with you..
$40 CAD 5 napon belül
0,0 (0 értékelés)
0,0
0,0
Felhasználó avatár
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 you Regards
$50 CAD 3 napon belül
0,0 (0 értékelés)
0,0
0,0
Felhasználó avatár
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 - some thorough troubleshooting will get it resolved. My method of troubleshooting is to change one thing at a time, and write it down as you do it! Then you can backtrack to what you had before if you need to go a different direction. I'm new to Freelancer, so I'd love to get some successful projects under my belt. Looking forward to working with you!
$30 CAD 3 napon belül
0,0 (0 értékelés)
0,0
0,0
Felhasználó avatár
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 napon belül
0,0 (0 értékelés)
0,0
0,0

Az ügyfélről

CANADA zászlója
longueuil, Canada
5,0
15
Fizetési mód hitelesítve
Tagság kezdete: febr. 27, 2020

Ügyfél-hitelesítés

Köszönjük! E-mailben elküldtük a linket, melyen átveheti ajándék egyenlegét.
E-mailje elküldése során valami hiba történt. Kérjük, próbálja újra.
Regisztrált Felhasználók Összes Közzétett Munka
Freelancer ® is a registered Trademark of Freelancer Technology Pty Limited (ACN 142 189 759)
Copyright © 2024 Freelancer Technology Pty Limited (ACN 142 189 759)
Előnézet betöltése
Hozzáférést adott a helymeghatározáshoz.
Belépési munkamenete lejárt, és kijelentkeztettük. Kérjük, lépjen be újra.