Find Jobs
Hire Freelancers

Help with Power BI Incremental refresh and Auto Refresh

$10-30 CAD

Closed
Posted 10 months ago

$10-30 CAD

Paid on delivery
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"
Project ID: 36720839

About the project

12 proposals
Remote project
Active 9 mos ago

Looking to make some money?

Benefits of bidding on Freelancer

Set your budget and timeframe
Get paid for your work
Outline your proposal
It's free to sign up and bid on jobs
12 freelancers are bidding on average $58 CAD for this job
User Avatar
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 in 1 day
4.9 (67 reviews)
5.5
5.5
User Avatar
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 in 2 days
4.9 (4 reviews)
2.8
2.8
User Avatar
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 in 2 days
0.0 (0 reviews)
0.0
0.0
User Avatar
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 in 7 days
1.0 (1 review)
0.0
0.0
User Avatar
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 in 1 day
0.0 (0 reviews)
0.0
0.0
User Avatar
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 in 7 days
0.0 (0 reviews)
0.0
0.0
User Avatar
working as a data analyst from last five years in MNC company and developed hundreds of dashboards in power bi.
$20 CAD in 7 days
0.0 (0 reviews)
0.0
0.0
User Avatar
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 in 5 days
0.0 (0 reviews)
0.0
0.0
User Avatar
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 in 3 days
0.0 (0 reviews)
0.0
0.0
User Avatar
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 in 3 days
0.0 (0 reviews)
0.0
0.0
User Avatar
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 in 2 days
0.0 (0 reviews)
0.0
0.0

About the client

Flag of CANADA
longueuil, Canada
5.0
15
Payment method verified
Member since Feb 27, 2020

Client Verification

Thanks! We’ve emailed you a link to claim your free credit.
Something went wrong while sending your email. Please try again.
Registered Users Total Jobs Posted
Freelancer ® is a registered Trademark of Freelancer Technology Pty Limited (ACN 142 189 759) & Freelancer Online India Private Limited (CIN U93000HR2011FTC043854)
Copyright © 2024 Freelancer Technology Pty Limited (ACN 142 189 759)
Loading preview
Permission granted for Geolocation.
Your login session has expired and you have been logged out. Please log in again.