Forum Discussion

Anonymous

Not applicable

4 years ago

Solved

Get Data from PowerBI option missing in Excel

Hi.

I'm struggling with this issue where i don't see PowerBI as an option in my excel's Get Data option.

I wanted to connect to a PowerBI dataset from an excel pivot.
I'm on Office 365.

Microsoft's documentation about this is pretty vague, i'm trying to understand exactly what the issue is.

Anonymous
Not applicable
2 years ago
I have tried these solutions, but still to no succes.
Some users have the option other users in the same organisation don't have these options.
Do other people have resolved these issue?
amitchandak
Super User
4 years ago
Anonymous , Open app.powerbi.com and open a report. USe Export -> analyze in excel. For first time it will download a plugin, Install that and try
v-henryk-mstf
Community Support
4 years ago
Hi Anonymous ,

Open excel to open the following permissions, and then on the Insert ribbon in Excel, select Pivot Table > From Power BI.

Refer to the following official documentation for detailed connection information:Start in Excel to connect to Power BI datasets

If the problem is still not resolved, please provide detailed error information and let me know immediately. Looking forward to your reply.

Best Regards,
Henry

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.