Connecting to AtScale Using Microsoft Power BI
This section describes how to connect Power BI to AtScale using the SQL Server Analysis Services Database Connector:
Before you start
Consider the following:
- As of AtScale 2020.5.2, the "AtScale Cubes" connector is deprecated and will no longer be maintained by Microsoft. It is strongly recommended that customers install a compatible version of AtScale and migrate to use the SQL Server Analysis Services Database Connector.
- It is strongly recommended that you set the
QUERY.FACTLESS.IGNOREINCIDENTALFILTER = FALSE
engine setting and restart the engine. Failure to do so will cause AtScale to return unexpected results for filter queries.