How can I share and protect an Excel document online (using Powerpivot), without Sharepoint & Power BI?

+1 vote

One of my clients has made this incredible (and really huge) Excel document with many data sources, sheets, PowerPivot tables, graphs, etc... Some pretty impressive work.

He wants to share it with authorized people but protect his valuable content (aka data sources and document 'logic'). Users may be able to use the filters for example but in view mode only.

Unfortunately, Sharepoint is not an option for my client. Here's what he says about his experience:

As part of its offerings Office 365 including SharePoint Online, Microsoft proposed the Power BI service. This allowed to create a Power BI website where we used to install and operate PowerPivot workbooks.

I have subscribed to Office 365 (free trial) to share my files. That's when I found that the function of creating a Power BI site, necessary to activate a PowerPivot workbook on SharePoint Online, was not proposed.

My research led me to question, besides the web, Sharepoint and Cloud service providers. I found on the web information indicating that the old experience ended at 31/12/2015 in favor of the new, with a time to experience old customers to migrate to the new.

Service companies have confirmed to me that Microsoft had already locked the Power BI for Office 365 thus prohibiting any new entrant.

Microsoft seeks to emphasize two offers: - Enterprise SharePoint (SharePoint classic) on server, - Power BI online (the new experience Power BI).

The first solution is expensive. The second is not yet advanced enough to become an alternative to PowerPivot.

So, what do we think?

Oct 23, 2018 in Power BI by Upasana
• 8,110 points
56 views

1 answer to this question.

Your answer

Your name to display (optional):
Privacy: Your email address will only be used for sending these notifications.
0 votes

Take a look again at Power BI. It just added the ability to pin Excel Ranges to dashboards. http://blogs.msdn.com/b/powerbi/archive/2015/11/24/pin-a-range-from-excel-to-your-dashboard.aspx

If you build an organizational content pack around your Excel workbook, you can share it with your users without needing share the original Excel workbook with your users.

answered Oct 23, 2018 by Annie97
• 2,190 points

Related Questions In Power BI

0 votes
1 answer

Can I create a Power BI report in Office 365 without my locally installed Office Excel?

Yess!! You can achieve this by using ...READ MORE

answered Sep 26, 2018 in Power BI by Kalgi
• 36,220 points
36 views
0 votes
2 answers

How do I get token using javascript API while trying to embed graphs using Power BI

You need to use the generateEmbededToken function. ...READ MORE

answered Oct 3, 2018 in Power BI by Kalgi
• 36,220 points
200 views
0 votes
1 answer
0 votes
1 answer

How can i see my plugin name in the Power BI Visual plugin List ?

there is a couple of errors in your ...READ MORE

answered Nov 8, 2018 in Power BI by Upasana
• 8,110 points
33 views
+4 votes
3 answers

Will Power BI take over MS Excel

Well, if your taking about just data ...READ MORE

answered Sep 26, 2018 in Power BI by Vardhan
• 10,980 points
101 views
0 votes
1 answer

Why should I shift from MS Excel to Power BI

There are a lot of advantages from ...READ MORE

answered Sep 26, 2018 in Power BI by Kalgi
• 36,220 points
46 views
+1 vote
1 answer

How is power BI different from excel

Power series plug-ins you can do certain ...READ MORE

answered Sep 26, 2018 in Power BI by Hannah
• 14,080 points
29 views
0 votes
1 answer

Locating closest match based on Latitude & Longitude

First of all, we need to use the ...READ MORE

answered Jan 2 in Power BI by Shubham
• 12,710 points
52 views
0 votes
1 answer

how can I connect my web api with Power BI Reports?

Go to Home > Edit Queries > ...READ MORE

answered Oct 18, 2018 in Power BI by Annie97
• 2,190 points
580 views
0 votes
1 answer

Excel Power Query: Using List.MatchAny on a column value

try this. let TableA = ...READ MORE

answered Oct 22, 2018 in Power BI by Annie97
• 2,190 points
79 views

© 2018 Brain4ce Education Solutions Pvt. Ltd. All rights Reserved.
"PMP®","PMI®", "PMI-ACP®" and "PMBOK®" are registered marks of the Project Management Institute, Inc. MongoDB®, Mongo and the leaf logo are the registered trademarks of MongoDB, Inc.