Alternatives to using Analyze in Excel

[Kirt1965]

May be a Power BI Service question....  I would like to hear what people have done or read about that are alternatives to using Analyze in Excel.  Exporting isn't an option because of row limitations.  What we really want is to be able to load the data in the dataset into sheets within Excel.  Each "table" in the dataset its own sheet.

What all have you done when you have VPs who want to see the underlying data and play with it on their own?

Thanks,

Kirt

[Icey · Accepted solution]

Hi @Kirt1965 ,

Try to use DAX Studio to export Power BI model data.

Reference:

Quick Tips: Export Power BI Desktop and Power BI Service Model Data In One Shot with DAX Studio.

Best Regards,

Icey

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[amitchandak]

@Kirt1965 , See if This May 2002 release feature can help

https://powerbi.microsoft.com/en-us/blog/power-bi-desktop-may-2020-feature-summary/#_Excel