{"id":3151,"date":"2026-10-24T14:53:27","date_gmt":"2026-10-24T09:23:27","guid":{"rendered":"https:\/\/www.nevastech.com\/blog\/?p=3151"},"modified":"2026-10-24T15:10:25","modified_gmt":"2026-10-24T09:40:25","slug":"connect-power-bi-to-dynamics-gp","status":"publish","type":"post","link":"https:\/\/www.nevastech.com\/blog\/connect-power-bi-to-dynamics-gp\/","title":{"rendered":"How to Connect Power BI to Dynamics GP, and Which Tables to Start With"},"content":{"rendered":"<p>Most <a href=\"https:\/\/www.nevastech.com\/solutions\/microsoft-dynamics-erp\/microsoft-dynamics-gp\/\">Microsoft Dynamics GP (Great Plains)<\/a> users know their data is valuable. The difficulty is getting it out in a form that managers can actually use. SmartLists are excellent for day-to-day lists, and Management Reporter handles the financial statements, but neither gives you interactive dashboards, trends over several years, or a single view across companies.<\/p>\n<p>This is where Power BI comes in. In this article, we will explain how to connect Power BI to Dynamics GP, which tables and views to start with, and how to set things up so your reports stay fast, secure and accurate.<\/p>\n<h2><span class=\"ez-toc-section\" id=\"Why_Power_BI_and_Dynamics_GP_Work_Well_Together\"><\/span>Why Power BI and Dynamics GP Work Well Together<span class=\"ez-toc-section-end\"><\/span><\/h2><div id=\"ez-toc-container\" class=\"ez-toc-v2_0_79 counter-hierarchy ez-toc-counter ez-toc-grey ez-toc-container-direction\">\n<div class=\"ez-toc-title-container\">\n<p class=\"ez-toc-title ez-toc-toggle\" style=\"cursor:pointer\">Table of Contents<\/p>\n<span class=\"ez-toc-title-toggle\"><a href=\"#\" class=\"ez-toc-pull-right ez-toc-btn ez-toc-btn-xs ez-toc-btn-default ez-toc-toggle\" aria-label=\"Toggle Table of Content\"><span class=\"ez-toc-js-icon-con\"><span class=\"\"><span class=\"eztoc-hide\" style=\"display:none;\">Toggle<\/span><span class=\"ez-toc-icon-toggle-span\"><svg style=\"fill: #999;color:#999\" xmlns=\"http:\/\/www.w3.org\/2000\/svg\" class=\"list-377408\" width=\"20px\" height=\"20px\" viewBox=\"0 0 24 24\" fill=\"none\"><path d=\"M6 6H4v2h2V6zm14 0H8v2h12V6zM4 11h2v2H4v-2zm16 0H8v2h12v-2zM4 16h2v2H4v-2zm16 0H8v2h12v-2z\" fill=\"currentColor\"><\/path><\/svg><svg style=\"fill: #999;color:#999\" class=\"arrow-unsorted-368013\" xmlns=\"http:\/\/www.w3.org\/2000\/svg\" width=\"10px\" height=\"10px\" viewBox=\"0 0 24 24\" version=\"1.2\" baseProfile=\"tiny\"><path d=\"M18.2 9.3l-6.2-6.3-6.2 6.3c-.2.2-.3.4-.3.7s.1.5.3.7c.2.2.4.3.7.3h11c.3 0 .5-.1.7-.3.2-.2.3-.5.3-.7s-.1-.5-.3-.7zM5.8 14.7l6.2 6.3 6.2-6.3c.2-.2.3-.5.3-.7s-.1-.5-.3-.7c-.2-.2-.4-.3-.7-.3h-11c-.3 0-.5.1-.7.3-.2.2-.3.5-.3.7s.1.5.3.7z\"\/><\/svg><\/span><\/span><\/span><\/a><\/span><\/div>\n<nav><ul class='ez-toc-list ez-toc-list-level-1 eztoc-toggle-hide-by-default' ><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-1\" href=\"https:\/\/www.nevastech.com\/blog\/connect-power-bi-to-dynamics-gp\/#Why_Power_BI_and_Dynamics_GP_Work_Well_Together\" >Why Power BI and Dynamics GP Work Well Together<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-2\" href=\"https:\/\/www.nevastech.com\/blog\/connect-power-bi-to-dynamics-gp\/#Before_You_Connect_Three_Decisions\" >Before You Connect: Three Decisions<\/a><ul class='ez-toc-list-level-3' ><li class='ez-toc-heading-level-3'><a class=\"ez-toc-link ez-toc-heading-3\" href=\"https:\/\/www.nevastech.com\/blog\/connect-power-bi-to-dynamics-gp\/#1_Who_will_build_the_reports\" >1. Who will build the reports?<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-3'><a class=\"ez-toc-link ez-toc-heading-4\" href=\"https:\/\/www.nevastech.com\/blog\/connect-power-bi-to-dynamics-gp\/#2_How_will_the_data_be_refreshed\" >2. How will the data be refreshed?<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-3'><a class=\"ez-toc-link ez-toc-heading-5\" href=\"https:\/\/www.nevastech.com\/blog\/connect-power-bi-to-dynamics-gp\/#3_What_access_will_Power_BI_have\" >3. What access will Power BI have?<\/a><\/li><\/ul><\/li><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-6\" href=\"https:\/\/www.nevastech.com\/blog\/connect-power-bi-to-dynamics-gp\/#How_to_Connect_Power_BI_to_Dynamics_GP_Step_by_Step\" >How to Connect Power BI to Dynamics GP: Step by Step<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-7\" href=\"https:\/\/www.nevastech.com\/blog\/connect-power-bi-to-dynamics-gp\/#Understanding_GP_Table_Names\" >Understanding GP Table Names<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-8\" href=\"https:\/\/www.nevastech.com\/blog\/connect-power-bi-to-dynamics-gp\/#Which_Tables_to_Start_With\" >Which Tables to Start With<\/a><ul class='ez-toc-list-level-3' ><li class='ez-toc-heading-level-3'><a class=\"ez-toc-link ez-toc-heading-9\" href=\"https:\/\/www.nevastech.com\/blog\/connect-power-bi-to-dynamics-gp\/#General_Ledger_for_profit_and_loss_and_balance_sheet_analysis\" >General Ledger (for profit and loss and balance sheet analysis)<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-3'><a class=\"ez-toc-link ez-toc-heading-10\" href=\"https:\/\/www.nevastech.com\/blog\/connect-power-bi-to-dynamics-gp\/#Receivables_for_customer_and_cash_collection_reports\" >Receivables (for customer and cash collection reports)<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-3'><a class=\"ez-toc-link ez-toc-heading-11\" href=\"https:\/\/www.nevastech.com\/blog\/connect-power-bi-to-dynamics-gp\/#Payables_for_vendor_and_spend_analysis\" >Payables (for vendor and spend analysis)<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-3'><a class=\"ez-toc-link ez-toc-heading-12\" href=\"https:\/\/www.nevastech.com\/blog\/connect-power-bi-to-dynamics-gp\/#Sales_for_revenue_by_customer_item_and_salesperson\" >Sales (for revenue by customer, item and salesperson)<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-3'><a class=\"ez-toc-link ez-toc-heading-13\" href=\"https:\/\/www.nevastech.com\/blog\/connect-power-bi-to-dynamics-gp\/#Inventory_for_stock_levels_and_item_analysis\" >Inventory (for stock levels and item analysis)<\/a><\/li><\/ul><\/li><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-14\" href=\"https:\/\/www.nevastech.com\/blog\/connect-power-bi-to-dynamics-gp\/#A_Shortcut_Use_GPs_Built-In_SQL_Views\" >A Shortcut: Use GP&#8217;s Built-In SQL Views<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-15\" href=\"https:\/\/www.nevastech.com\/blog\/connect-power-bi-to-dynamics-gp\/#Practical_Tips_for_Accurate_Reports\" >Practical Tips for Accurate Reports<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-16\" href=\"https:\/\/www.nevastech.com\/blog\/connect-power-bi-to-dynamics-gp\/#Security_and_Organization\" >Security and Organization<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-17\" href=\"https:\/\/www.nevastech.com\/blog\/connect-power-bi-to-dynamics-gp\/#Power_BI_Versus_Management_Reporter\" >Power BI Versus Management Reporter<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-18\" href=\"https:\/\/www.nevastech.com\/blog\/connect-power-bi-to-dynamics-gp\/#Looking_Ahead_to_Business_Central\" >Looking Ahead to Business Central<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-19\" href=\"https:\/\/www.nevastech.com\/blog\/connect-power-bi-to-dynamics-gp\/#How_Nevas_Technologies_Can_Help\" >How Nevas Technologies Can Help<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-20\" href=\"https:\/\/www.nevastech.com\/blog\/connect-power-bi-to-dynamics-gp\/#Summarizing_the_Key_Points\" >Summarizing the Key Points<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-21\" href=\"https:\/\/www.nevastech.com\/blog\/connect-power-bi-to-dynamics-gp\/#Frequently_Asked_Questions\" >Frequently Asked Questions<\/a><\/li><\/ul><\/nav><\/div>\n\n<p>Dynamics GP stores everything in Microsoft SQL Server, and Power BI connects to SQL Server very easily. That combination means you can:<\/p>\n<ul>\n<li>Build dashboards for sales, receivables, payables, inventory and profitability<\/li>\n<li>Compare several years of data without running reports one by one<\/li>\n<li>Combine all your GP companies into one view<\/li>\n<li>Share reports securely with managers who do not use GP<\/li>\n<\/ul>\n<p>It also does not consume a GP user license, because Power BI reads the database directly rather than logging in to GP.<\/p>\n<h2><span class=\"ez-toc-section\" id=\"Before_You_Connect_Three_Decisions\"><\/span>Before You Connect: Three Decisions<span class=\"ez-toc-section-end\"><\/span><\/h2>\n<h3><span class=\"ez-toc-section\" id=\"1_Who_will_build_the_reports\"><\/span>1. Who will build the reports?<span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p>Power BI Desktop is free to download, so anyone can start building reports. However, to share reports with colleagues through the Power BI service, each person publishing or viewing them generally needs a Power BI Pro license, unless your organization has a Premium or Fabric capacity. It is worth checking your Microsoft 365 licensing early, as it affects your budget.<\/p>\n<h3><span class=\"ez-toc-section\" id=\"2_How_will_the_data_be_refreshed\"><\/span>2. How will the data be refreshed?<span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p>Dynamics GP normally runs on a server in your own office or data centre. For published reports to refresh automatically, you need the on-premises data gateway. This is a small Microsoft application installed on a server that can reach your GP SQL Server. It securely passes data to the Power BI service on a schedule you set.<\/p>\n<h3><span class=\"ez-toc-section\" id=\"3_What_access_will_Power_BI_have\"><\/span>3. What access will Power BI have?<span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p>We strongly recommend creating a dedicated, read-only SQL login for Power BI. Never use the &#8220;sa&#8221; account or a Dynamics GP user&#8217;s login. A read-only account cannot change GP data, and you can limit it to the databases and views it actually needs.<\/p>\n<h2><span class=\"ez-toc-section\" id=\"How_to_Connect_Power_BI_to_Dynamics_GP_Step_by_Step\"><\/span>How to Connect Power BI to Dynamics GP: Step by Step<span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p>Here is the standard approach, using Power BI Desktop and SQL Server:<\/p>\n<ol>\n<li>Open Power BI Desktop and choose Get Data &gt; SQL Server.<\/li>\n<li>Enter the server name of your GP SQL Server (for example, GPSQL01 or GPSQL01\\GP).<\/li>\n<li>Enter the database name. Each GP company has its own database, usually a short code such as TWO or ABC01. The system database is normally called DYNAMICS.<\/li>\n<li>Choose the data connectivity mode:\n<ul>\n<li>Import copies the data into Power BI. It is faster and suits most GP reporting.<\/li>\n<li>DirectQuery queries SQL Server each time a report is opened. Use it only when you truly need near real-time figures, as it adds load to your Dynamics GP server.<\/li>\n<\/ul>\n<\/li>\n<li>Sign in with the read-only SQL account.<\/li>\n<li>Select the tables or views you need, and click Transform Data to tidy them in Power Query.<\/li>\n<li>Build your model and report, then publish to the Power BI service.<\/li>\n<li>Configure the gateway and set a scheduled refresh, for example every morning before the working day starts.<\/li>\n<\/ol>\n<p>That is all it takes to get connected. The real skill lies in choosing the right data.<\/p>\n<h2><span class=\"ez-toc-section\" id=\"Understanding_GP_Table_Names\"><\/span>Understanding GP Table Names<span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p>Microsoft Dynamics GP table names look cryptic at first, but they follow a pattern you will quickly recognize. The letters tell you the module, and the numbers tell you the type of data.<\/p>\n<table>\n<thead>\n<tr>\n<th>Prefix<\/th>\n<th>Module<\/th>\n<\/tr>\n<\/thead>\n<tbody>\n<tr>\n<td>GL<\/td>\n<td>General Ledger<\/td>\n<\/tr>\n<tr>\n<td>RM<\/td>\n<td>Receivables Management<\/td>\n<\/tr>\n<tr>\n<td>PM<\/td>\n<td>Payables Management<\/td>\n<\/tr>\n<tr>\n<td>SOP<\/td>\n<td>Sales Order Processing<\/td>\n<\/tr>\n<tr>\n<td>POP<\/td>\n<td>Purchase Order Processing<\/td>\n<\/tr>\n<tr>\n<td>IV<\/td>\n<td>Inventory<\/td>\n<\/tr>\n<tr>\n<td>SY<\/td>\n<td>System and company setup<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<p>The number range usually indicates what the table holds:<\/p>\n<ul>\n<li>00000 range: master records, such as accounts, customers, vendors and items<\/li>\n<li>10000 range: work records, which are saved but not yet posted<\/li>\n<li>20000 range: open records, which are posted but still active<\/li>\n<li>30000 range: history, such as closed years and fully paid documents<\/li>\n<\/ul>\n<p>This matters a great deal for reporting. If you only read the open table, you will miss history. If you only read history, you will miss this year&#8217;s activity. Most reports need both, combined.<\/p>\n<h2><span class=\"ez-toc-section\" id=\"Which_Tables_to_Start_With\"><\/span>Which Tables to Start With<span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p>We would emphasize starting small. Pick one business question, connect only the tables needed to answer it, and build from there.<\/p>\n<h3><span class=\"ez-toc-section\" id=\"General_Ledger_for_profit_and_loss_and_balance_sheet_analysis\"><\/span>General Ledger (for profit and loss and balance sheet analysis)<span class=\"ez-toc-section-end\"><\/span><\/h3>\n<table>\n<thead>\n<tr>\n<th>Table<\/th>\n<th>What it holds<\/th>\n<\/tr>\n<\/thead>\n<tbody>\n<tr>\n<td>GL00100<\/td>\n<td>Account master: account descriptions, types and categories<\/td>\n<\/tr>\n<tr>\n<td>GL00105<\/td>\n<td>Account index: the full account number string<\/td>\n<\/tr>\n<tr>\n<td>GL00102<\/td>\n<td>Account categories<\/td>\n<\/tr>\n<tr>\n<td>GL20000<\/td>\n<td>Posted transactions for open years<\/td>\n<\/tr>\n<tr>\n<td>GL30000<\/td>\n<td>Posted transactions for historical (closed) years<\/td>\n<\/tr>\n<tr>\n<td>SY40100<\/td>\n<td>Fiscal period setup<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<p>Combine GL20000 and GL30000 to get the full transaction history.<\/p>\n<h3><span class=\"ez-toc-section\" id=\"Receivables_for_customer_and_cash_collection_reports\"><\/span>Receivables (for customer and cash collection reports)<span class=\"ez-toc-section-end\"><\/span><\/h3>\n<table>\n<thead>\n<tr>\n<th>Table<\/th>\n<th>What it holds<\/th>\n<\/tr>\n<\/thead>\n<tbody>\n<tr>\n<td>RM00101<\/td>\n<td>Customer master<\/td>\n<\/tr>\n<tr>\n<td>RM20101<\/td>\n<td>Open receivables documents<\/td>\n<\/tr>\n<tr>\n<td>RM30101<\/td>\n<td>Historical receivables documents<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<h3><span class=\"ez-toc-section\" id=\"Payables_for_vendor_and_spend_analysis\"><\/span>Payables (for vendor and spend analysis)<span class=\"ez-toc-section-end\"><\/span><\/h3>\n<table>\n<thead>\n<tr>\n<th>Table<\/th>\n<th>What it holds<\/th>\n<\/tr>\n<\/thead>\n<tbody>\n<tr>\n<td>PM00200<\/td>\n<td>Vendor master<\/td>\n<\/tr>\n<tr>\n<td>PM20000<\/td>\n<td>Open payables documents<\/td>\n<\/tr>\n<tr>\n<td>PM30200<\/td>\n<td>Historical payables documents<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<h3><span class=\"ez-toc-section\" id=\"Sales_for_revenue_by_customer_item_and_salesperson\"><\/span>Sales (for revenue by customer, item and salesperson)<span class=\"ez-toc-section-end\"><\/span><\/h3>\n<table>\n<thead>\n<tr>\n<th>Table<\/th>\n<th>What it holds<\/th>\n<\/tr>\n<\/thead>\n<tbody>\n<tr>\n<td>SOP30200<\/td>\n<td>Posted sales document headers<\/td>\n<\/tr>\n<tr>\n<td>SOP30300<\/td>\n<td>Posted sales document lines<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<h3><span class=\"ez-toc-section\" id=\"Inventory_for_stock_levels_and_item_analysis\"><\/span>Inventory (for stock levels and item analysis)<span class=\"ez-toc-section-end\"><\/span><\/h3>\n<table>\n<thead>\n<tr>\n<th>Table<\/th>\n<th>What it holds<\/th>\n<\/tr>\n<\/thead>\n<tbody>\n<tr>\n<td>IV00101<\/td>\n<td>Item master<\/td>\n<\/tr>\n<tr>\n<td>IV00102<\/td>\n<td>Item quantities by site<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<h2><span class=\"ez-toc-section\" id=\"A_Shortcut_Use_GPs_Built-In_SQL_Views\"><\/span>A Shortcut: Use GP&#8217;s Built-In SQL Views<span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p>If joining tables sounds daunting, there is an easier starting point. Microsoft Dynamics GP includes a set of SQL views that sit behind the standard SmartLists. They already join the master, open and history tables together, with readable column names. Useful examples include:<\/p>\n<ul>\n<li>AccountTransactions: general ledger transactions with account details<\/li>\n<li>ReceivablesTransactions: customer documents across open and history<\/li>\n<li>PayablesTransactions: vendor documents across open and history<\/li>\n<li>SalesTransactions and SalesLineItems: posted sales documents<\/li>\n<li>Customers, Vendors and Items: master data<\/li>\n<\/ul>\n<p>For many organizations, these views cover 80% of reporting needs. If you already use SmartLists, the fields will look familiar. Our guide to Dynamics GP for new users explains how SmartLists work.<\/p>\n<p>When the standard views are not enough, your partner can create custom SQL views tailored to your reports. This kind of customization keeps complex logic in one place, so every report uses the same rules.<\/p>\n<h2><span class=\"ez-toc-section\" id=\"Practical_Tips_for_Accurate_Reports\"><\/span>Practical Tips for Accurate Reports<span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p>From our project experience, a few habits make a large difference:<\/p>\n<ul>\n<li>Filter out unposted and voided documents: Work tables and voided entries can inflate your figures. Check the document status and void fields.<\/li>\n<li>Watch the document types: In Receivables and Payables, returns and credit notes should usually show as negative amounts. GP stores them as positive values with a document type, so apply the sign in Power Query.<\/li>\n<li>Trim text fields: GP pads many text fields with trailing spaces. Trimming them avoids failed matches between tables.<\/li>\n<li>Handle multiple companies: Each company is a separate database. Bring each into Power BI and append them, adding a column for the company name.<\/li>\n<li>Use a proper date table: Create a calendar table that matches your GP fiscal periods, so monthly and yearly comparisons line up with your accounts.<\/li>\n<li>Reconcile against GP: Before sharing a dashboard, compare its totals with a GP trial balance or aged trial balance. If the numbers do not match, analyzing the difference early saves embarrassment later.<\/li>\n<\/ul>\n<h2><span class=\"ez-toc-section\" id=\"Security_and_Organization\"><\/span>Security and Organization<span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p>Power BI can expose sensitive information, such as salaries, margins and customer balances, to a wide audience. So plan your security from the start:<\/p>\n<ul>\n<li>Keep payroll and HR data out of general reports.<\/li>\n<li>Use workspaces in the Power BI service to separate finance, sales and operations content.<\/li>\n<li>Use row-level security if different managers should only see their own region, department or company.<\/li>\n<li>Keep the gateway server patched and limit who can manage it.<\/li>\n<\/ul>\n<h2><span class=\"ez-toc-section\" id=\"Power_BI_Versus_Management_Reporter\"><\/span>Power BI Versus Management Reporter<span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p>Power BI does not replace Management Reporter for formal financial statements. Management Reporter is still the better tool for printed income statements and balance sheets with precise formatting. Power BI is the better tool for interactive analysis, trends and operational dashboards. Most GP customers benefit from using both.<\/p>\n<h2><span class=\"ez-toc-section\" id=\"Looking_Ahead_to_Business_Central\"><\/span>Looking Ahead to Business Central<span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p>Dynamics GP product support ends on 31 December 2029, and many organizations are planning a <a href=\"https:\/\/www.nevastech.com\/services\/dynamics-gp-to-business-central-migration\">Dynamics GP to Business Central migration<\/a>. The good news is that Power BI skills carry across. <a href=\"https:\/\/www.nevastech.com\/solutions\/microsoft-dynamics-365\/microsoft-dynamics-365-business-central\/\">Dynamics 365 Business Central<\/a> has a built-in Power BI connector and ready-made reporting apps. Building your GP reports around clear business questions now will make them much easier to rebuild later.<\/p>\n<h2><span class=\"ez-toc-section\" id=\"How_Nevas_Technologies_Can_Help\"><\/span>How Nevas Technologies Can Help<span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p>Nevas Technologies has worked with Dynamics GP since version 7.0 and regularly helps clients turn GP data into useful dashboards. We can:<\/p>\n<ul>\n<li>Set up a secure Power BI connection and gateway through our <a href=\"https:\/\/www.nevastech.com\/solutions\/microsoft-dynamics-erp\/microsoft-dynamics-gp\/dynamics-gp-support\">Dynamics GP support<\/a> services<\/li>\n<li>Build custom SQL views and dashboards for finance, sales and inventory<\/li>\n<li>Train your team on GP reporting through <a href=\"https:\/\/www.nevastech.com\/solutions\/microsoft-dynamics-erp\/microsoft-dynamics-gp\/dynamics-gp-training\">Dynamics GP training<\/a><\/li>\n<li>Plan your reporting for the future with our <a href=\"https:\/\/www.nevastech.com\/solutions\/microsoft-dynamics-365-business-central-consultants\">Business Central consultants<\/a><\/li>\n<\/ul>\n<h2><span class=\"ez-toc-section\" id=\"Summarizing_the_Key_Points\"><\/span>Summarizing the Key Points<span class=\"ez-toc-section-end\"><\/span><\/h2>\n<ul>\n<li>Connect using Power BI Desktop and SQL Server, with a read-only login.<\/li>\n<li>Refresh published reports through the on-premises data gateway.<\/li>\n<li>Start with GL, RM, PM, SOP and IV tables, or GP&#8217;s built-in SQL views.<\/li>\n<li>Combine open and history tables to see the full picture.<\/li>\n<li>Reconcile your dashboards against GP before sharing them.<\/li>\n<\/ul>\n<p>With the right setup, Power BI turns years of GP data into clear, timely insight for your whole organization.<\/p>\n<p>If you would like help connecting Power BI to your GP system, contact Nevas Technologies and our team will be glad to help.<\/p>\n<h2><span class=\"ez-toc-section\" id=\"Frequently_Asked_Questions\"><\/span>Frequently Asked Questions<span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p><strong>Does connecting Power BI use a Dynamics GP user license?<\/strong> No. Power BI reads the SQL database directly, so it does not log in to GP or use a GP license.<\/p>\n<p><strong>Do I need a gateway to use Power BI with GP?<\/strong> Only if you publish reports to the Power BI service and want them to refresh automatically. Power BI Desktop on its own does not need one.<\/p>\n<p><strong>Should I use Import or DirectQuery?<\/strong> Import suits most GP reporting and is faster. Use DirectQuery only when you need near real-time data.<\/p>\n<p><strong>Which GP tables should I start with?<\/strong> Start with the General Ledger tables (GL00100, GL20000 and GL30000) or the Account Transactions view, then add Receivables, Payables and Sales as needed.<\/p>\n","protected":false},"excerpt":{"rendered":"<p>Most Microsoft Dynamics GP (Great Plains) users know their data is valuable. The difficulty is getting it out in a form that managers can actually use. SmartLists are excellent for day-to-day lists, and Management Reporter handles the financial statements, but neither gives you interactive dashboards, trends over several years, or a single view across companies. &#8230; <a title=\"How to Connect Power BI to Dynamics GP, and Which Tables to Start With\" class=\"read-more\" href=\"https:\/\/www.nevastech.com\/blog\/connect-power-bi-to-dynamics-gp\/\" aria-label=\"Read more about How to Connect Power BI to Dynamics GP, and Which Tables to Start With\">Read more<\/a><\/p>\n","protected":false},"author":2,"featured_media":3152,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[5],"tags":[],"class_list":["post-3151","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-dynamics-gp"],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v27.2 - https:\/\/yoast.com\/product\/yoast-seo-wordpress\/ -->\n<title>Connect Power BI to Dynamics GP: Tables to Use<\/title>\n<meta name=\"description\" content=\"Learn how to connect Power BI to Dynamics GP, which tables and views to start with, and how to keep reports secure.\" \/>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/www.nevastech.com\/blog\/connect-power-bi-to-dynamics-gp\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Connect Power BI to Dynamics GP: Tables to Use\" \/>\n<meta property=\"og:description\" content=\"Learn how to connect Power BI to Dynamics GP, which tables and views to start with, and how to keep reports secure.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.nevastech.com\/blog\/connect-power-bi-to-dynamics-gp\/\" \/>\n<meta property=\"og:site_name\" content=\"Nevas Technologies Insights\" \/>\n<meta property=\"article:published_time\" content=\"2026-10-24T09:23:27+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2026-10-24T09:40:25+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/www.nevastech.com\/blog\/wp-content\/uploads\/2026\/10\/Connect-Power-BI-to-Dynamics-GP.png\" \/>\n\t<meta property=\"og:image:width\" content=\"1672\" \/>\n\t<meta property=\"og:image:height\" content=\"941\" \/>\n\t<meta property=\"og:image:type\" content=\"image\/png\" \/>\n<meta name=\"author\" content=\"John Solomon\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"John Solomon\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"8 minutes\" \/>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"Connect Power BI to Dynamics GP: Tables to Use","description":"Learn how to connect Power BI to Dynamics GP, which tables and views to start with, and how to keep reports secure.","robots":{"index":"index","follow":"follow","max-snippet":"max-snippet:-1","max-image-preview":"max-image-preview:large","max-video-preview":"max-video-preview:-1"},"canonical":"https:\/\/www.nevastech.com\/blog\/connect-power-bi-to-dynamics-gp\/","og_locale":"en_US","og_type":"article","og_title":"Connect Power BI to Dynamics GP: Tables to Use","og_description":"Learn how to connect Power BI to Dynamics GP, which tables and views to start with, and how to keep reports secure.","og_url":"https:\/\/www.nevastech.com\/blog\/connect-power-bi-to-dynamics-gp\/","og_site_name":"Nevas Technologies Insights","article_published_time":"2026-10-24T09:23:27+00:00","article_modified_time":"2026-10-24T09:40:25+00:00","og_image":[{"width":1672,"height":941,"url":"https:\/\/www.nevastech.com\/blog\/wp-content\/uploads\/2026\/10\/Connect-Power-BI-to-Dynamics-GP.png","type":"image\/png"}],"author":"John Solomon","twitter_card":"summary_large_image","twitter_misc":{"Written by":"John Solomon","Est. reading time":"8 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/www.nevastech.com\/blog\/connect-power-bi-to-dynamics-gp\/#article","isPartOf":{"@id":"https:\/\/www.nevastech.com\/blog\/connect-power-bi-to-dynamics-gp\/"},"author":{"name":"John Solomon","@id":"https:\/\/www.nevastech.com\/blog\/#\/schema\/person\/4999a5a32569d9cb02ceb097d8bb6f9f"},"headline":"How to Connect Power BI to Dynamics GP, and Which Tables to Start With","datePublished":"2026-10-24T09:23:27+00:00","dateModified":"2026-10-24T09:40:25+00:00","mainEntityOfPage":{"@id":"https:\/\/www.nevastech.com\/blog\/connect-power-bi-to-dynamics-gp\/"},"wordCount":1702,"publisher":{"@id":"https:\/\/www.nevastech.com\/blog\/#organization"},"image":{"@id":"https:\/\/www.nevastech.com\/blog\/connect-power-bi-to-dynamics-gp\/#primaryimage"},"thumbnailUrl":"https:\/\/www.nevastech.com\/blog\/wp-content\/uploads\/2026\/10\/Connect-Power-BI-to-Dynamics-GP.png","articleSection":["Dynamics GP"],"inLanguage":"en-US"},{"@type":"WebPage","@id":"https:\/\/www.nevastech.com\/blog\/connect-power-bi-to-dynamics-gp\/","url":"https:\/\/www.nevastech.com\/blog\/connect-power-bi-to-dynamics-gp\/","name":"Connect Power BI to Dynamics GP: Tables to Use","isPartOf":{"@id":"https:\/\/www.nevastech.com\/blog\/#website"},"primaryImageOfPage":{"@id":"https:\/\/www.nevastech.com\/blog\/connect-power-bi-to-dynamics-gp\/#primaryimage"},"image":{"@id":"https:\/\/www.nevastech.com\/blog\/connect-power-bi-to-dynamics-gp\/#primaryimage"},"thumbnailUrl":"https:\/\/www.nevastech.com\/blog\/wp-content\/uploads\/2026\/10\/Connect-Power-BI-to-Dynamics-GP.png","datePublished":"2026-10-24T09:23:27+00:00","dateModified":"2026-10-24T09:40:25+00:00","description":"Learn how to connect Power BI to Dynamics GP, which tables and views to start with, and how to keep reports secure.","breadcrumb":{"@id":"https:\/\/www.nevastech.com\/blog\/connect-power-bi-to-dynamics-gp\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.nevastech.com\/blog\/connect-power-bi-to-dynamics-gp\/"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.nevastech.com\/blog\/connect-power-bi-to-dynamics-gp\/#primaryimage","url":"https:\/\/www.nevastech.com\/blog\/wp-content\/uploads\/2026\/10\/Connect-Power-BI-to-Dynamics-GP.png","contentUrl":"https:\/\/www.nevastech.com\/blog\/wp-content\/uploads\/2026\/10\/Connect-Power-BI-to-Dynamics-GP.png","width":1672,"height":941,"caption":"Connect Power BI to Dynamics GP"},{"@type":"BreadcrumbList","@id":"https:\/\/www.nevastech.com\/blog\/connect-power-bi-to-dynamics-gp\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/www.nevastech.com\/blog\/"},{"@type":"ListItem","position":2,"name":"How to Connect Power BI to Dynamics GP, and Which Tables to Start With"}]},{"@type":"WebSite","@id":"https:\/\/www.nevastech.com\/blog\/#website","url":"https:\/\/www.nevastech.com\/blog\/","name":"Nevas Technologies Insights","description":"Nevas Technologies Insights","publisher":{"@id":"https:\/\/www.nevastech.com\/blog\/#organization"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/www.nevastech.com\/blog\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"en-US"},{"@type":"Organization","@id":"https:\/\/www.nevastech.com\/blog\/#organization","name":"Nevas Technologies Insights","url":"https:\/\/www.nevastech.com\/blog\/","logo":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.nevastech.com\/blog\/#\/schema\/logo\/image\/","url":"https:\/\/www.nevastech.com\/blog\/wp-content\/uploads\/2022\/09\/nevas-tech-logo.png","contentUrl":"https:\/\/www.nevastech.com\/blog\/wp-content\/uploads\/2022\/09\/nevas-tech-logo.png","width":171,"height":50,"caption":"Nevas Technologies Insights"},"image":{"@id":"https:\/\/www.nevastech.com\/blog\/#\/schema\/logo\/image\/"}},{"@type":"Person","@id":"https:\/\/www.nevastech.com\/blog\/#\/schema\/person\/4999a5a32569d9cb02ceb097d8bb6f9f","name":"John Solomon","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.nevastech.com\/blog\/wp-content\/uploads\/2026\/01\/Gemini_Generated_Image_85xsyk85xsyk85xs.png","url":"https:\/\/www.nevastech.com\/blog\/wp-content\/uploads\/2026\/01\/Gemini_Generated_Image_85xsyk85xsyk85xs.png","contentUrl":"https:\/\/www.nevastech.com\/blog\/wp-content\/uploads\/2026\/01\/Gemini_Generated_Image_85xsyk85xsyk85xs.png","caption":"John Solomon"},"sameAs":["https:\/\/www.nevastech.com\/"],"url":"https:\/\/www.nevastech.com\/blog\/author\/nevas_blog_author\/"}]}},"_links":{"self":[{"href":"https:\/\/www.nevastech.com\/blog\/wp-json\/wp\/v2\/posts\/3151","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.nevastech.com\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.nevastech.com\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.nevastech.com\/blog\/wp-json\/wp\/v2\/users\/2"}],"replies":[{"embeddable":true,"href":"https:\/\/www.nevastech.com\/blog\/wp-json\/wp\/v2\/comments?post=3151"}],"version-history":[{"count":3,"href":"https:\/\/www.nevastech.com\/blog\/wp-json\/wp\/v2\/posts\/3151\/revisions"}],"predecessor-version":[{"id":3157,"href":"https:\/\/www.nevastech.com\/blog\/wp-json\/wp\/v2\/posts\/3151\/revisions\/3157"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/www.nevastech.com\/blog\/wp-json\/wp\/v2\/media\/3152"}],"wp:attachment":[{"href":"https:\/\/www.nevastech.com\/blog\/wp-json\/wp\/v2\/media?parent=3151"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.nevastech.com\/blog\/wp-json\/wp\/v2\/categories?post=3151"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.nevastech.com\/blog\/wp-json\/wp\/v2\/tags?post=3151"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}