1.

Organization wished to analyze Power BI report data in excel, is It possible?

Answer»

Yes, it’s possible by following the steps below:

  • Firstly, Power BI Admin portal, in tenant settings “Analyze in EXCEL” option MUST be ENABLED by Power BI Administrator.
  • Then at upper right corner, click settings to download and install Excel updates.
  • Next left-hand side navigation pane, got to workspace > dataset > click on Eclipses (three dots) and select Analyze in Excel.
  • Download .ODC, SAVE and double click on it.
  • Post that NEED to provide power BI user id and password.
  • Which will connect to dataset in Power BI.


Discussion

No Comment Found