Forum Discussion
RonenBitmn
Jan 31, 2021Copper Contributor
Power Query connect to Power BI Pro
Hi,
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 it
i don't have in the Get Data | connect to power BI
like it shows under this link
https://community.powerbi.com/t5/Power-Query/Analyze-in-Excel-Via-Get-Data-From-Power-BI-Dataset/td-p/1144737
i am not sure how am i able to use the answer for the post above
"Analysis Services" instance of your Power BI dataset
when i tried using the connection of "Analyze in Excel" pivot table it didn't succeed
please advise what am i doing wrong
thanks
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 Community
Analyze in Excel - that's better to ask on Power BI site and check sqlbi.com, not sure how it works now.
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 Community
Analyze in Excel - that's better to ask on Power BI site and check sqlbi.com, not sure how it works now.