Forum Discussion

RonenBitmn's avatar
RonenBitmn
Copper Contributor
Jan 31, 2021

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

Resources