Jan 31 2021
a short explanation on my infrastructure:
- i have an Office 365 Group which have an excel document shared on it.
- on my power bi desktop (i upgraded the license to Pro), i published a dataset which is built from this excel file
- i have another excel file (on the computer of the user office 365 group) that needs to connect to the power bi dataset and analyze iti don't have in the Get Data | connect to power BIlike it shows under this linkhttps://community.powerbi.com/t5/Power-Query/Analyze-in-Excel-Via-Get-Data-From-Power-BI-Dataset/td-...
i am not sure how am i able to use the answer for the post above"Analysis Services" instance of your Power BI datasetwhen i tried using the connection of "Analyze in Excel" pivot table it didn't succeedplease advise what am i doing wrong
View best response
Jan 31 2021
From Power BI connector for Excel shall be in production for E3/E5, you also need to have Power BI Pro license, please check Simplifying enterprise data discovery and analysis in Microsoft Excel - Page 2 - Microsoft Tech Comm...
Analyze in Excel - that's better to ask on Power BI site and check sqlbi.com, not sure how it works now.