Forum Discussion

Paulx99's avatar
Paulx99
Icon for Kudo Kingpin rankKudo Kingpin
10 years ago

Exporting data from Power BI to Excel

Hi all   Does anybody know (as per the post below) when 'export data to CSV' was actually implemented in PBI Desktop ? I currently have PBI Desktop (Mar 2016) installed, but can't see it in there -...
Need Help
ryans's avatar
ryans
Icon for Helper I rankHelper I
10 years ago

Why do you need to export to excel? My guess is that anything you need to do in excel the query editor or calc columns/measures could do just as well. If it is the case that you are more familiar with Excel you can do the same with the combination of Power Query (Get & Transform in 2016) and Power Pivot. If your looking for even more advanced analytics, design a predictive analytics model in the Cortana Analytics Suite and deploy it as a web service. With Power Query or the Query Editor you can call on this webservice and visualize the outcomes of those predictions.

Sean's avatar
Sean
Icon for Community Champion rankCommunity Champion
10 years ago

Pivot Tables in Excel are in Compact Form and have Collapse/Expand buttons.

 

You can summarize the fields and fit a lot of data on one Page! You can Expand only the fields you want to see the details for

 

With the Matrix in PBI you can't - you have to scroll and scroll and keep scrolling... to get to what you want to see...

 

Slicers remove data AND field Totals in the Matrix so they do not help