cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
Post Patron
Post Patron

From Excel Publish to Power BI to recreate the Power View sheets as reports in the Power BI service?

From OneDrive for Business

I have a Microsoft Excel workbook that is saved to OneDrive for Business. The workbook contains several Power View sheets.

 

I need to recreate the Power View sheets as reports in the Power BI service.

Following steps can Solve the problem:

From Excel, click Publish to Power BI, and then click Export. (This is the solution when excel workbook is saved to OneDrive for Business)

From Microsoft SharePoint Online

I have a Microsoft Excel workbook that is saved to Microsoft SharePoint Online. The workbook contains several Power View sheets.

 

I need to recreate the Power View sheets as reports in the Power BI service.

Following steps can Solve the problem:

From the Power BI service, get the data from SharePoint Online, and then click import (This is the solution when excel workbook is saved toMicrosoft SharePoint Online)

 

 

 

 

https://docs.microsoft.com/en-us/power-bi/service-publish-from-excel

Export workbook data to Power BI

When you choose this option, any supported data in tables and/or a data model are exported into a new dataset in Power BI. If you have any Power View sheets, those will be re-created in Power BI as reports.

You can continue editing your workbook. When your changes are saved, they’ll be synchronized with the dataset in Power BI, usually within about an hour. If you need more immediate gratification, you can just select Publish again, and your changes are exported right then and there. Any visualizations you have in reports and dashboards will be updated, too.

Choose this option if you’ve used Get & Transform data or Power Pivot to load data into a data model, or if your workbook has Power View sheets with visualizations you want to see in Power BI.

Using Export from Publish to Power BI in Excel is pretty much the same as using Get Data > File > OneDrive for Business > Export Excel data into Power BI from Power BI in your browser.

1 ACCEPTED SOLUTION

Accepted Solutions
Highlighted
Post Patron
Post Patron

Re: From Excel Publish to Power BI to recreate the Power View sheets as reports in the Power BI serv

From OneDrive for Business

I have a Microsoft Excel workbook that is saved to OneDrive for Business. The workbook contains several Power View sheets.

 

I need to recreate the Power View sheets as reports in the Power BI service.

Following steps can Solve the problem:

From Excel, click Publish to Power BI, and then click Export. (This is the solution when excel workbook is saved to OneDrive for Business)

 

 

 

From Microsoft SharePoint Online

I have a Microsoft Excel workbook that is saved to Microsoft SharePoint Online. The workbook contains several Power View sheets.

 

I need to recreate the Power View sheets as reports in the Power BI service.

Following steps can Solve the problem:

From the Power BI service, get the data from SharePoint Online, and then click import (This is the solution when excel workbook is saved to Microsoft SharePoint Online)

View solution in original post

2 REPLIES 2
Highlighted
Solution Sage
Solution Sage

Re: From Excel Publish to Power BI to recreate the Power View sheets as reports in the Power BI serv

Hi @ShivendooKumar ,

Thank you for sharing this.

Best Regards,

Teige

Highlighted
Post Patron
Post Patron

Re: From Excel Publish to Power BI to recreate the Power View sheets as reports in the Power BI serv

From OneDrive for Business

I have a Microsoft Excel workbook that is saved to OneDrive for Business. The workbook contains several Power View sheets.

 

I need to recreate the Power View sheets as reports in the Power BI service.

Following steps can Solve the problem:

From Excel, click Publish to Power BI, and then click Export. (This is the solution when excel workbook is saved to OneDrive for Business)

 

 

 

From Microsoft SharePoint Online

I have a Microsoft Excel workbook that is saved to Microsoft SharePoint Online. The workbook contains several Power View sheets.

 

I need to recreate the Power View sheets as reports in the Power BI service.

Following steps can Solve the problem:

From the Power BI service, get the data from SharePoint Online, and then click import (This is the solution when excel workbook is saved to Microsoft SharePoint Online)

View solution in original post

Helpful resources

Announcements

August Community Highlights

Check out a full recap of the month!

August 2020 CYST Challenge

Check out the winners of the recent 'Can You Solve These?' community challenge!

Experience what’s next for Power BI

Join us for an in-depth look at the new Power BI features and capabilities at the free Microsoft Business Applications Launch Event.

Top Solution Authors
Top Kudoed Authors