AtScale for Snowflake Semantic Views is pre-installed in your Snowflake environment. No separate infrastructure. No imports. No extracts.
In this demo, AtScale Founder and CTO Dave Mariani walks through the three-step setup that turns a Snowflake Semantic View into a live analytics endpoint for Excel and Power BI.
What you’ll see:
- Create an XMLA endpoint in Snowsight — one DDL command attaches the endpoint to your Snowflake warehouse and makes it available to Microsoft analytics tools
- Connect Excel to a live Semantic View — pivot tables and cell-based cube formulas query Snowflake directly over MDX, with no data movement and no refresh lag
- Connect Power BI on a live connection — inherit the full governed semantic model over DAX, add client-side measures, and confirm live connection mode without recreating a single metric
Live Power BI and Excel on Snowflake Semantic Views — set up in under two minutes.Live Power BI and Excel on Snowflake Semantic Views — set up in under two minutes.
One endpoint. Two tools. Zero copies.
With the AtScale for Snowflake Semantic Views XMLA Endpoint, the semantic model your team built travels to Excel and Power BI exactly as defined. No duplication. No semantic drift. No separate permission layer to maintain.
The result: your analysts get live pivot tables and governed Power BI reports grounded in the same metric definitions Snowflake Intelligence and Cortex Analyst use.
Always live, never stale Queries run against Snowflake at query time. No import mode. No scheduled refreshes. No lag between the warehouse and the workbook.
The model travels with the endpoint Attach a Semantic View to the XMLA endpoint and Excel and Power BI inherit the full governed model without anyone rebuilding it.
Snowflake governs every query Row- and column-level security enforced by Snowflake policies applies automatically. There is no parallel permission layer to configure or maintain.
SEE ATSCALE FOR SNOWFLAKE IN ACTION
