Showing posts from February, 2023

Bringing ChatGPT into Business Central

 Hi readers, The purpose of the blog is to provide a step-by-step guide on how to integrate ChatGPT, a conversational AI tool, in Business Central, an all-in-one business management solution. The blog aims to educate readers on what ChatGPT and Business Central are, and how to sign up for ChatGPT, obtain the ChatGPT API, and create a Codeunit, Table, and Page in Business Central. The blog post also aims to show readers how to integrate ChatGPT into Business Central, and how it can be used to streamline business operations and enhance customer support. Overview What is ChatGPT? Definition and overview of ChatGPT Explanation of how it works and its key features 2.       What is Business Central? Definition and overview of Business Central Explanation of its features and benefits for businesses 3.       How to Signup in ChatGPT Step-by-step guide on how to create an account in ChatGPT Explanation of the requirements and necessary information Chat

Basic ETL Exercise in Power BI

 Hi, Please watch this video before doing the exercise. ETL-2 video link Download the data from here: Github link Task 1. Get the excel file into the Power BI 2. Launch Power Query Editor 3. Check all the columns are properly named (if not, name it properly) 4. Remove the null values (Rows) 5. Delete the irrelevant columns 6. Add a new table with simple columns. If you face any issues, please comment. 

REST API in Business Central | NLP Translation API in Business central to translate the word and sentences

Introduction Hi, in this post I am going to see you how I have used NLP translation API in Business Central to translate a word or sentence. I have planned the below topics to discuss.  Introduction to REST API RadipAPI  Overview Table in BC  Page in BC  Codeunit to configure the API Demo Video Key Takeaways Introduction to REST API Imagine you're at a pizza restaurant, and you want to order a pizza using the restaurant's website. When you place your order, you're actually using an API! In this case, the website is the client that sends a request to the server (the pizza restaurant). After processing the request, the server replies to the client with its findings. Here's an example of how this could look in a REST API: Request GET /api/pizza/pepperoni HTTP/1.1   This is the client's request to the server, asking for a pepperoni pizza. The GET method is used to retrieve data, and the /api/pizza/pepperoni is the endpoint or URL that identifies the specific resourc

Top five Visual Studio Code add-ons for programming in AL

In this blog, we will delve into the top 5 Visual Studio Code extensions specifically designed for AL programming. These extensions are designed to make the AL programming experience more productive and efficient by providing developers with the tools they need to write, debug and deploy code with ease. Whether you are a seasoned developer or just starting out with AL programming, these extensions will help you take your skills to the next level. So, let's get started and explore the best of what Visual Studio Code has to offer for AL programmers! A brief overview of Visual Studio Code Visual Studio Code is a popular, open-source code editor that is widely used by developers for writing, debugging, and deploying code. It is known for its sleek design, versatility, and performance. AL programming is a high-level programming language that is used in the development of applications for Microsoft Dynamics 365 Business Central. It is essential for developers to have the right tools to m

Comprehensive guide on using ChatGPT with Power BI - My personal experience

Hi all, Today I interacted with chatGPT to know how it responds to my questions related to Power BI. Wow, the result was amazing. Though a few DAX formulas are not correct 90% accuracy was there.  Look what I am going to discuss Introduction to ChatGPT What is Power BI? Identifying Key Performance Indicators (KPIs) with ChatGPT and Power BI Writing DAX code with ChatGPT and Power BI Designing Effective Visualizations with ChatGPT and Power BI Writing Statistical DAX and charts suggestions by ChatGPT Important points before you communicate with chatGPT Conclusion and Future scope of ChatGPT and Power BI integration. Introduction to ChatGPT Modern language model ChatGPT was created by OpenAI. It is a state-of-the-art AI language model that is trained on a vast amount of text data to generate human-like responses to a wide range of questions and prompts. It uses a deep learning technique called Transformer, which enables it to handle long-term dependenc