Get Data from PowerBI option missing in Excel

[Anonymous]

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.

[FREDPI]

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?

[v-henryk-mstf · Accepted solution]

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.

[amitchandak]

@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