Using AtScale with Microsoft Power BI

This section describes how to connect Power BI to AtScale using the SQL Server Analysis Services Database Connector.

Before you start

It is strongly recommended that you set the query.factless.ignoreIncidentalFilter global setting to false and restart the engine. Failure to do so will cause AtScale to return unexpected results for filter queries.

Connect to Power BI

• Using AtScale with Power BI Desktop
• Using Power BI Service with Token-Based Authentication
• Using Power BI Service with Windows Authentication
• Power BI Service SSO via Inbound Kerberos
• Using SuperDAX MD
• Using DAX Tabular
• Using Power BI with Field Parameters
• Functional Differences Between SSAS and AtScale
• Known Issues

Additional information

For a demonstration of what you can do with AtScale and Power BI, check out the Automate Multi-Currency Reporting in Power BI with AtScale video.