Loading...

Returning Tables From A Single Excel Cube Formula Connected To Power BI

Returning Tables From A Single Excel Cube Formula Connected To Power BI

Use the ToCSV DAX function and dynamic arrays to return whole tables from a single Excel cube formula

The post Returning Tables From A Single Excel Cube Formula Connected To Power BI first appeared on Chris Webb's BI Blog.

Published on:

Learn more
Chris Webb's BI Blog Chris Webb's BI Blog
Chris Webb's BI Blog Chris Webb's BI Blog

A blog about Power BI, SQL Server Analysis Services (Multidimensional and Tabular), MDX, DAX, Power Pivot, Power Query, M, Power Map and Excel for BI

Share post:

Related posts

Calculated Columns vs Measures in DAX

Level: Beginners Original: Feb 2016 It has been many years since Matt wrote his first take on Calculated Columns vs Measures, back in 2014 whe...

11 hours ago

Fabric Copilot to help write DAX queries improvements

This update comes with a marked improvement when generating DAX queries and conversationally editing them. This includes overall correctness o...

23 hours ago

Datamart are dead.

1 day ago

Unify Datamart with Fabric Data Warehouse!

The unification of Power BI datamarts with Fabric data warehouses offers a significant evolution in Microsoft’s analytics capabilities. ...

1 day ago
Stay up to date with latest Microsoft Dynamics 365 and Power Platform news!
* Yes, I agree to the privacy policy