cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
abpgupta
Helper IV
Helper IV

Analyze in Excel like Download option for Excel Links

Hi All

 

I am creating a pre-built Pivot Table for Excel Consumers and want to provide a link in PBIX report. However, sharepoint link just opens in new browser window. I would like it to work similar to "Analyze in Excel" Drop down when a button or Image is clicked.

 

Do you know if it is possible to set url to download excel directly to Local machine?

 

Thanks for inputs!

4 REPLIES 4
lbendlin
Super User III
Super User III

In my opinion paginated reports are the antithesis to Analyze in Excel. Why did you go with paginated reports in the first place - did your users demand them? Have they ever experienced regular reports in the Power BI service?

 

Even if you include  a pre-filtered Excel file that connects to the dataset you still need to have each of your users "install the app" as a one time action before they can do anything.

 

It feels to me as if you are trying to find workarounds, not solutions.

As I said earlier,  Paginated report is used to provide formatted outputs for multiple pages to users similar to they have functionality using other tools Tableau.  PBIX doesn't have capability to download all data in same format shown on screen. It's downloaded as image for PDF and excel raw data is not have formatted outputs.

 

Please suggest. 

 

lbendlin
Super User III
Super User III

Please provide more context. This sounds like a rather, uhm, inventive way of using Power BI.


Since we can provide using Pivot Table option within PBIX and is very fast to download in Excel compared to Paginated report, I am creating pre-built Pivot table connected to dataset for user to consume data locally as well.
I have put a link in report; however, it opens up in browser and throws warnings; shows hidden field list thus users have to go few more clicks to download Excel for all functionality. 

I would like to avoid extra browser step here.

Paginated report's initial rendering time and  export performance are not acceptable to users compared to other tools  IBM Cognos and Tableau; hence looking for clean and faster way to provide export functionality.

 

Hope I am clear. 

 

Helpful resources

Announcements
PBI User Groups

Welcome to the User Group Public Preview

Check out new user group experience and if you are a leader please create your group

March Update

Check it Out!

Click here to read more about the March 2021 Updates!

secondImage

The largest Power BI virtual conference

100+ sessions, 100+ speakers, Product managers, MVPs, and experts. All about Power BI. Attend online or watch the recordings.

secondImage

Experience what’s next for Power BI

See the latest Power BI innovations, updates, and demos from the Microsoft Business Applications Launch Event.

Top Solution Authors
Top Kudoed Authors