How to analyze data from power services into excel?

[ammartino44]

Hello. How can I analyze the underlying data in excel form a sample data set in power bi services? I tried to analyze in excel and it's making me download something related to SQL. Que pasa mufasa? 

[v-micsh-msft · Accepted solution]

Hi ammartino44,

When clicking on Analyze in Excel, Power BI service would allow you to download an ODC file (we could download it and then open it with Microsoft Excel), which opens a connection from Local Excel to online dataset.

Please check the details in the article posted by ankitpatira. Analyze in Excel.

In addition, I would prefer using Power BI publisher for Excel, which is much more convenient than Analyze in Excel:

Power BI publisher for Excel

Please reply back if  you have any further misunderstanding.

Regards

[ankitpatira]

@ammartino44 Here's the blog post on step by step instructions of Analyze in Excel with Power BI.