How to open the report of Power BI Service by Excel ?

[yoshihirok]

I want to open the report of Power BI Service by Excel as model.

By Power BI Desktop, I can open it 'Get Data' - 'Online Servces' - 'Power BI Service'.

Currently, Excel 2016's 'Get Data' have NOT 'Power BI Service'.
Excel 2016 Version 1711, Build 8730.2046.

Can I open the report in Power BI Service as data on Excel 2016 ?

How can I do ?

Regards,

Yoshihiro Kawabata

[GilbertQ]

Hi @yoshihirok

You can use the Power BI Publisher for Excel to do exactly what you are looking for.

Here is the link: https://powerbi.microsoft.com/en-us/excel-dashboard-publisher/

[yoshihirok]

Hi @GilbertQ, thank you for your quick reply.

Power BI Publisher of Excel, that seems to publishing data/report from Excel to Power BI Service.

Now, I want to use the datas on Power BI Service in Excel.

I can to use the datas on Power BI Service in Power BI Desktop.

Scenario by Power BI Desktop

step 1. create a report connecting SQL Server.

step 2. publish the report to Power BI Service for using it by Web browser and phone.

step 3. create new report connecting Power BI Service by Power BI Desktop for new report.

Useful feature is 'Get Data' - 'Online Services' - 'Power BI Service'.

I want to do the same scinario in Excel 2016 for creating new workbook.

Regards,

Yoshihiro Kawabata 

[Aron_Moore]

Sounds like you do want Power BI Publisher for Excel. It allows Excel to read data stored in the Power BI service.

Follow these instuctions under the "Connect to Data" section: https://docs.microsoft.com/en-us/power-bi/publisher-for-excel