Tutorial: Configure a Tableau Report in BI Helper without filters
In this tutorial, we will walk through the steps to set up a Tableau report for bursting and distribution in BI Helper, using the Retail Sales Report as an example.
BI Helper follows a three-stage process to generate and distribute Tableau reports — Schedule Report, Generate PDF and Send Email. The detailed steps are as follows:
- Create your BI Helper account at https://portal.bihelper.tech. Sign in and go the Job Summary tab, where you will see the Retail Sales Report. Click on the Edit icon (orange pen) under Actions.
- This takes you to the Schedule Report tab in the Job configuration section. Check that the job name is Retail Sales Report. Save and go to the Generate PDF tab. Enter your Tableau credentials as detailed in the Tableau Online Authentication section below.
- You can now see the Tableau projects and workbooks to which you have access.
- Leave the slicer name and slicer value blank and enter the email ids to which the PDF (without any filters) should be delivered.
5. Save and go to the Send Email tab. Set up and validate your sender mail ID and enter your email subject and body. Click on Update to complete your job setup and return to the Job Summary tab.
6. Click on the Play button to run the Retail Sales Report. PDFs of the report will be emailed to the recipients defined by you. Your users, both internal and external, don’t need to have Tableau licenses to receive their reports.
Tableau Online Authentication
As part of Tableau Online Authentication, you need to provide BI Helper the Tableau URL, site name, Personal Access Token name and secret.
a. In the following Tableau URL: https://prod-apnortheast-a.online.tableau.com/#/site/bihelper/views/RetailSalesReport-Demo_16141395161860/Title?:iid=2, the Tableau URL is https://prod-apnortheast-a.online.tableau.com.
b. Site Name: In the above URL, bihelper is the site name.
c. Personal Access Token and Secret: Personal access tokens provide Tableau users the ability to create long-lived authentication tokens. The tokens allow users to run automation with Tableau REST APIs without requiring hard-coded credentials or interactive login.
Please refer to Tableau Documentation — Personal Access Token for more details on security, use cases, revoking tokens, token lifetime, monitoring token usage, and more.
To configure a Tableau Report in BI Helper with filters, see this tutorial.
BI Helper
BI Helper bihelper.tech is a simple, secure and cost effective SaaS solution for PDF report distribution in Tableau and Power BI. You only need a single Power BI / Tableau license to generate your PDF reports.
Resource: BI Helper Tutorial | Report Distribution in BI Tools
