Jet Analytics delivers fast, flexible dashboards and reports in Excel, Power BI, and in the browser. Now you can bring all your data together in one place to enable everyone in the organization to easily perform sophisticated business analysis from anywhere, without technical expertise. Empower users to make better decisions, faster.
This blog shares information on the steps involved to connect Jet Analytics to the Business Central (Online Tenant)
Step 1: Find tenant and environment information
Step 2: Get web services access key
User which will be used to establish the connection to the Business Central data source ensure this user have permission set of either:
- D365 FULL ACCESS
Step 3: Install Jet Analytics Extension
On Extension Management page click Manage → Extension Marketplace And search for Jet Analytics App
Click -> Get it now to deploy the App
Step 4: Verify extension installation
Click Manage and then Deployment Status
Verify that the status is completed.
Step 5: Allow http client requests
Step 6: Configure Business Central data source in Jet Analytics project
Ensure if your Environment Name is other than Production or Sandbox, you will need to manually enter your Environment name. Like in my case it was Test
Next, we will setup Accounts
You will get (0 selected) at first time in this case this task is already performed so showing count of selected Accounts (Companies in Business Central Database)
Select Template & all desired Companies from the List and hit OK.
Now you can see your table objects in Data Selection Pan.
That’s all for this post rest will discuss in other upcoming posts.
One news I want to share with all readers, now we are Jet Reports Partner, if you have any requirements you can reach to me for License, Deployment, Training or Support.