BI Optimizer helps BI and data teams rationalize and optimize their reporting and data assets. It is a new product offered within the Metric Insights Platform. Until the end of 2025, it is included at no additional cost as part of your existing license.
The BI Optimizer utilizes our Plugins to tools like Tableau, Power BI, Databricks, and Snowflake to extract metadata and lineage.
The new application is deployed as a Portal Page.
We are currently in the first phase of the Beta, only focusing on Tableau and Power BI based use-cases.
Tableau Endpoints and Sources for Getting Metadata
Endpoints
- Get all Data Sources: https://help.tableau.com/current/api/rest_api/en-us/REST/rest_api_ref_data_sources.htm#query_data_sources
- Download Data Source XML content: https://help.tableau.com/current/api/rest_api/en-us/REST/rest_api_ref_data_sources.htm#download_data_source
- Get all User Workbooks: https://help.tableau.com/current/api/rest_api/en-us/REST/rest_api_ref_workbooks_and_views.htm#query_workbooks_for_user
- Download Workbook XML content: https://help.tableau.com/current/api/rest_api/en-us/REST/rest_api_ref_workbooks_and_views.htm#download_workbook
Workbook Requirements
It is required to create a Workbook with Usage Data. From there, Tableau Admin creates a readonly SQL connection to Tableau internal PostgreSQL database. The Workbook will source data from this database.