Find Jobs
Hire Freelancers

Power BI Direct Query Connection Assistance

$30-250 USD

Completed
Posted 3 months ago

$30-250 USD

Paid on delivery
I urgently need assistance with my Power BI Direct Query connection issue. The trouble lies in a specific table that is not working despite its counterparts functioning aptly on the same SQL Server domain (myphp). The error message I receive relates closely to [login to view URL]: ODBC: ERROR [22018]. As far as I am able to verify: - I have checked the connection settings for the problematic table - The error I encounter appears to be a DataSource error related to ODBC - This issue arises mostly when importing into Power BI The ideal freelancer for this project should have: - An in-depth understanding of SQL Server and database management - Experience dealing with ODBC errors [22018] - Proficiency in Power BI and its correlation with SQL Server - Skill in troubleshooting and resolving data mismatch problems Your task will be to identify the source of the problem, apply necessary corrections, and ensure safe and smooth data import into Power BI. Your proactive suggestions to prevent such errors in the future would be highly appreciated.
Project ID: 37770771

About the project

40 proposals
Remote project
Active 3 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
Awarded to:
User Avatar
Hi there, I am a Data Scientist and am a professional responsible for extracting actionable insights and knowledge from large volumes of Data Visualization. I have over 12-plus years of experience with Power BI, PowerApps, PowerShell, Visual Studio, Power Automation, Microsoft Power BI, Microsoft 365, and Tableau top priority is to provide high-quality work. I am willing to fully devote my time and energy to improve the service offered, with timely, accurate, and professional results, Building trust and a long-term relationship with the customer is my main objective. Let's discuss this further via chat, and I'll start your project right now. Thank you. Gdev
$40 USD in 2 days
5.0 (3 reviews)
3.1
3.1
40 freelancers are bidding on average $166 USD for this job
User Avatar
I'm passionate about solving complex data problems, and my deep understanding of database programming, particularly with SQL Server and MySQL, has prepared me well for addressing your Power BI Direct Query connection issue. Over the years, I have become highly skilled at troubleshooting and resolving data mismatch problems - a skill set that directly aligns with your needs. Notably, I've dealt with ODBC errors similar to the one you mentioned ([22018]) in the past, allowing me to swiftly identify their sources and apply necessary corrections. Power BI and its correlation with SQL Server is one of my expertise since I've used it extensively for businesses like DXC technologies. In such diverse contexts, I’ve helped prevent future issues like this by taking a proactive stance. I evaluate all possibilities that could lead to errors and prevent them from surfacing before they even happen. My primary goal is always client satisfaction, which means that you can expect not just effective resolution of your present problem but also guidance on how better to manage Power BI imports in the future. If you choose me for this project, I will ensure safe and smooth data import into Power BI; any problems you may encounter afterwards will have free 4-day support from me. Let us begin resolving your problem together and build a long-term professional relationship. I look forward to hearing from you!
$180 USD in 5 days
4.9 (73 reviews)
6.9
6.9
User Avatar
I am going to start work right now on resolving your Power BI Direct Query connection issue. With my expertise in SQL Server and database management, I'll tackle the DataSource error [22018] and ensure seamless data import into Power BI. Your urgent need for assistance will be met with thorough troubleshooting and corrective actions, aimed at preventing future errors. Let's get your Power BI connection back on track swiftly and effectively.
$180 USD in 4 days
5.0 (27 reviews)
6.1
6.1
User Avatar
I have more than 15 years of experience in the development As I am an expert, I can build it according to your requirements. Because I have a lot of experience in these fields, I can build your project as soon as possible. I offer excellent software quality work and provide the best support for your project. If you give me this job, I will do my best to finish your job by your timeline. If you want to see my past works, I can show you my past works right now. Ready to discuss this with you about the task now. Thank you for the reading.
$100 USD in 7 days
4.7 (34 reviews)
5.6
5.6
User Avatar
Hello, How are you. I am a senior Data Analyst and PowerBI expert with over 5 years of experience using complex DAX calculations to find the most optimal solutions. My core strengths include data manipulation & analysis, building reports & dashboards and developing visualizations using PowerBI. I have already connected Power bi with several databases and have extensive experience in creating dynamic and attractive dashboards. I hope this message finds you well. I am writing to express my interest in assisting you with the urgent Power BI Direct Query connection issue you are currently facing. Based on the details provided, it seems that the problem is specific to a particular table, generating an ODBC error [22018] during the import into Power BI. Best regards
$30 USD in 2 days
5.0 (23 reviews)
4.6
4.6
User Avatar
As someone who has invested two decades in software development and data analysis, I confidently can say that no data issue is too complex for me to tackle. My extensive experience as a database developer, designer, and administrator with a specialization in MS SQL Server comes into play when dealing with tricky problems like the one you're facing. Additionally, my proficiency in MySQL equips me with a broad understanding of databases that's not limited to a specific domain. Power BI is an integral part of my skill set. I've used it extensively to effectively solve several data-related issues over the years. Dealing with ODBC errors [22018] is something I'm all too familiar with. My approach involves diligent troubleshooting, identifying the root cause, and applying precise solutions to ensure smooth data imports into Power BI. My proactive nature will also allow me to suggest changes or improvements in order to minimize similar errors reoccurring in the future. My passion for this field extends beyond just resolving problems - it involves ensuring that my clients have a seamless and efficient system. Trust me with your project, and I assure you top-quality work delivered efficiently and true solutions for your Power BI Direct Query connection woes. Let's enhance your data management capabilities together!
$50 USD in 1 day
4.9 (15 reviews)
4.6
4.6
User Avatar
Hi there, I'm thrilled to apply for your Power BI Direct Query Connection Assistance project. With 4-5 years of experience in Database Programming, Power BI, Database Administration, Microsoft SQL Server and MySQL, I'm confident in my ability to bring valuable insights and expertise to your initiative. Please note that the initial bid is an estimate, and the final quote will be provided after a thorough discussion of the project requirements or upon reviewing any detailed documentation you can share. Could you please share any available detailed documentation? I'm also open to further discussions to explore specific aspects of the project. Feel free to check out my profile, showcasing my portfolio, past jobs, and client reviews. It reflects the quality and professionalism I bring to every project. My goal is to provide a competitive budget without compromising on quality. Thanks for considering my proposal. I'm eager to collaborate and contribute to your project's success. Let me know if you need any more information. Best regards, Rashid Amjad
$250 USD in 8 days
5.0 (4 reviews)
4.6
4.6
User Avatar
Hi! I am skilled SQL coder with skills including Database Administration, Power BI, Database Programming, Microsoft SQL Server and MySQL. C#, ASP.net, ETL, BI, DBA, SQL and PL/SQL Expert 15+ years experience in software development, database programming and administration, and project management. Specialist: SQL, PL/SQL, T-SQL, PL/pgSQL, ETL, Database Migration, SQL Optimization, Stored Procedure , C# , ASP.NET, AWS, Google Cloud, Microsoft Azure Database Expertise: MySQL, MariaDB, Oracle, MSSQL Server, PostgreSQL, EnterpriseDB, DB2, MS Access Database Administration and Programming: Install, configure and administration database server Design and Implement real time database replication and clustering Design and Implement data warehouse solution Database load balancing Database backup and recovery Database performance tuning and optimization Database Migration SQL Optimization Creating procedure, functions, triggers and packages Web Application Development: ASP.net, C#, HTML, CSS, Java Script, Ajax, Jquery, Entity Framework, Crystal Report, Microsoft Reporting Desktop Application Development: VBA, VB6, VB.net, C#, Crystal Report, Microsoft Reporting Application Server and Middle-ware: IIS, Apache Tomcat, HaProxy, PgPool-II, Proxy SQL Cloud Computing: Google Cloud, AWS & Azure. Operating System: Red-hat Linux, Centos, Ubuntu, Windows DevOps and Automation: Ansible, Python, Bash Shell Script, Jenkins, Apache Airflow ERP and CRM: Microsoft Dynamic Great Plan (GP) Microsoft Dynamic CRM Customized ERP Please contact me to discuss more about this project. Thank you
$150 USD in 4 days
4.0 (8 reviews)
4.9
4.9
User Avatar
Drawing from my extensive experience as a Full Stack Developer and Data Analyst, I am confident in tackling your Power BI Direct Query connection issue. I have a solid background in SQL Server management which includes troubleshooting difficult problems like the one you're facing - ODBC errors [22018]. Recognizing that such issues can hinder data import into Power BI, I will diligently investigate to identify and rectify the source of the problem. Moreover, my proficiency in Power BI alongside SQL Server will be instrumental in ensuring a seamless and secure import of your data. Combining this with my knack for analyzing data, I strive to not only solve immediate problems but also provide preventive strategies for future errors. As you rightly noted, data mismatch problems are crucial and should be dealt with proactively to avoid similar setbacks - rest assured, this is an aspect I highly prioritize. In conclusion, selecting me for this project means engaging a professional who is up-to-date with the latest trends in optimizing processes with technology and data. So let's get started on resolving your Power BI issues promptly and effectively!
$80 USD in 1 day
5.0 (13 reviews)
4.0
4.0
User Avatar
Dear Client, I am writing to express my interest in assisting you with your Power BI Direct Query connection issue. I understand that you are facing trouble with a specific table that is not working despite its counterparts functioning aptly on the same SQL Server domain (myphp). With my expertise in Power BI and SQL Server, I am confident in my ability to diagnose and resolve the issue promptly. I have experience troubleshooting similar connectivity issues and can provide you with a solution that meets your needs. I am committed to delivering high-quality results and exceeding your expectations. I look forward to the opportunity to work with you on this project. Please let me know if you have any questions or need further information. Regards, Lalit
$240 USD in 7 days
5.0 (4 reviews)
3.4
3.4
User Avatar
Hello I’ve carefully checked your requirements and really interested in Power BI Direct Query Connection Assistance. I am confident for your project because I have skills of MySQL, Microsoft SQL Server, Power BI, Database Administration and Database Programming. I’m ready to discuss your project and start immediately. Looking forward to hearing you back and discussing all details. Sincerely, Yehor.
$100 USD in 1 day
5.0 (1 review)
2.6
2.6
User Avatar
⭐⭐⭐======Hi David G. =====⭐⭐⭐ I am excited to submit my proposal for your project. I have developed a strong set of skills that make me confident in my ability to deliver high-quality work to your project. My approach to any project is to first gain a deep understanding of the client's needs and requirements. I will work closely with you to ensure that I understand your project goals and objectives, and that I am able to deliver results that meet or exceed your expectations. In terms of technical skills, I have extensive experience in Microsoft SQL Server, Database Programming, MySQL, Power BI and Database Administration. I'm able to work independently, be detail-oriented, have strong problem-solving ability and excellent communication skills. Overall, I am confident that I can provide the best result beyond your requirements, and help you achieve your project goals. Looking forward to the opportunity to work with you and contribute to the development of the new website. Thank you.
$200 USD in 7 days
5.0 (1 review)
2.6
2.6
User Avatar
Hello, I have more than 14 years of experience in reporting and data analysis. I have designed multiple dashboards and VBA automation to reduce human intervention to enhance data accuracy. These dashboards and reports have dynamic views and functionality to present the data Like: checkboxes, radio buttons, drop-down lists and graphical data representations (Bar charts, pie charts, heat maps, Gantt chat, etc.). I successfully delivered Dashboard, Scorecard, KPI Tracker, heatmap & ad-hoc requests to my clients. I can help you here; I went through the mentioned details and found that I can support you to complete your task. Please check my portfolio once for more information. Further, we will discuss this on chat. Thanks in advance for your valuable time. Thanks, Jitender Kumar Reporting & Data Analytics Excel | VBA | Power BI | SQL | OCR | GSheet
$180 USD in 2 days
5.0 (1 review)
2.6
2.6
User Avatar
Hi Sir, I reviewed your requirement for "Power BI Direct Query Connection Assistance". I have worked on similar projects. I have mentioned my skills into my profile. Can you please review my profile and let me know if we can discuss further in detail. I assure for high quality code and deliver in approved timeline. Thank you.
$140 USD in 7 days
4.7 (2 reviews)
2.5
2.5
User Avatar
I just went through the snap that you shared, it looks like an ODBC driver error I hope to be considered for the project at 120 USD we will connect a call and solve this issue Regards, Subhash
$120 USD in 1 day
5.0 (2 reviews)
1.0
1.0
User Avatar
Hello, Thank you for posting. I like to work with your project. I am a solution expert with Power BI, Power Automate. I have make several dashboards for my other clients. I can show you my past works when you connected with me. Also I have good knowledge about accounting, Sales, inventory and other services. Currently I am working as an assistant accountant. Hope to hear from you. Regards, Thank you.
$70 USD in 4 days
5.0 (1 review)
0.8
0.8
User Avatar
Hello, Hope you are doing well. I’ve carefully checked your project: Power BI Direct Query Connection Assistance Very familiar with Microsoft SQL Server, Power BI, MySQL, Database Administration and Database Programming I can complete your project on time and will provide you 100% satisfaction. Can start working right now on your project. Looking forward to hearing you back and discussing all details. Will wait
$180 USD in 2 days
0.0 (0 reviews)
0.0
0.0
User Avatar
Hello Client, I hope this proposal finds you in excellent health. Welcome to my profile, Home to Professional and Quality services with 100% customer satisfaction guarantee. I'm a Certified & Experienced Expert. Dear Client, I take this opportunity to inform you that i have KEENLY gone through all your project requirements as given in your project description and I confirm to you that i can perfectly deliver as instructed. Being in possession of all CLEARLY STATED required project skills as this is my area of professional specialisation having completed all Certifications and developed adequate experience in the same area, I hereby humbly request you to consider my bid for Professional, Quality and Affordable services always. STRICT TIMELY DELIVERY & UNLIMITED REVISIONS. Incase your project is deleted, you can hire me directly via the link; https://www.freelancer.com/u/prodeveloperserv Kindly Message Me We Discuss More About The Project and seal the contract. Welcome and Thank-you.
$250 USD in 1 day
0.0 (0 reviews)
0.0
0.0
User Avatar
Hello, Greetings David G., Good evening! I am professional data analyst with skills including Microsoft SQL Server, Power BI, MySQL, Database Programming and Database Administration. I hold an masters degree in data analysis which provides me with the necessary background to handle your project. Having done similar projects, I can deliver quality and superior work at a price we are both comfortable with and within the agreed timeline. Meanwhile, I am currently reviewing your attachment. I will update you shortly in the inbox once you respond to my proposal. Please contact me to discuss more regarding this project. Please respond at your earliest convenience, Lincoln
$150 USD in 2 days
0.0 (0 reviews)
0.0
0.0
User Avatar
Utilizing my extensive experience in SQL Server domain and profound understanding of ODBC errors—especially [22018]—I can without a doubt assist you in resolving your Power BI Direct Query connection issue. My skills in Power BI combined with comprehensive knowledge of data discrepancy troubleshooting make me the ideal candidate for this task. Throughout my two years of full-stack development journey, I have come across and successfully resolved similar issues that echoed yours. And that's not all—I'm proactive to suggest preventive measures to curb such setbacks in the future. With meticulousness as my ally, I will not only identify the source but also apply necessary corrections to ensure a seamless data import into Power BI. As an ardent learner, I'm always hungry for more knowledge—your project presents one such opportunity where I can widen my horizons while providing you with a top-notch resolution. Let's collaborate and turn your vision into reality by trusting me to deliver precise and reliable solutions for your Power BI needs! Join me on this exciting venture—
$140 USD in 2 days
0.0 (0 reviews)
0.0
0.0
User Avatar
Hello there I checked out your project "Power BI Direct Query Connection Assistance", and I'm confident Ninja Studio can knock it out of the park for you! With our solid experience in IT field, we're all set to build you a killer decentralized platform. Plus, our expertise in web development ensures your site will be slick and seamless, whether you're selling products or sharing content. And hey, if you need some jaw-dropping design work, our creative team has got you covered. We'll make sure your brand shines like a supernova! So, what do you say? Ready to take your project to the next level with Ninja Studio? Let's chat and make some magic happen Looking forward to the opportunity to collaborate. Let's chat and discuss the exciting details. Thank You Ninja Studio
$250 USD in 3 days
0.0 (0 reviews)
0.0
0.0

About the client

Flag of UNITED ARAB EMIRATES
Dubai, United Arab Emirates
5.0
6
Payment method verified
Member since Oct 30, 2022

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