Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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?
Solved! Go to 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:
Please reply back if you have any further misunderstanding.
Regards
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:
Please reply back if you have any further misunderstanding.
Regards
@ammartino44 Here's the blog post on step by step instructions of Analyze in Excel with Power BI.
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.