SharePoint BI

23 Conversations

Latest Activity

Custom List Message Item


I find nowhere the response, I'm not an "IT guy".

1. I have created as now an excel file in sharepoint with a data model linked to several power view reports. Excel 2017 linked to Report Q1;Report Q2;Report Q3;ReportQ4.

I always update the excel file

... Read More
0 Reply

Hi Everyone,


recently, we migrated around 15000 documents from Box to SharePoint online document library and now I need to generate View Only (No sign-in required) link and export to CVS. 

I'm not sure what are the options I have. Power Shell comes on m

... Read More
0 Reply



I'm using Power Bi webpart on my SharePoint modern pages but since I have to print this report I didn't find anything about. The alternative way that I saw was go to the power bi web page and print the report. For my it's ok to do these steps but fo

... Read More
0 Reply

Not sure if anyone else has ran into this yet, or if I need to just open a premier case instead.  The PowerBI web part came out of preview today in our tenant, and I tried to add it to a modern page, but got an error, that I simply cannot find anywhere on

... Read More
0 Reply

Hi all,

I've been trying to separate our internal traffic from our external users in SPO. We can separate our users by either location office or department, but it seems the only kind of data we can see in the usage reports is "last" login.


Is there a way

... Read More
0 Reply

I am looking to have an active data connection from an Excel file in Excel Services on SharePoint Online (O365) that has a data connection to an on-premises SQL database.


Need to be able to have data refresh work like it does with SharePoint on-premises.


... Read More
16 Replies
Actually, SPO has been using Excel Online (not Excel Services) for quite some time now. The Excel Services capabilities were moved over. Excel is still totally viable (an... Read More

I should also add, because I just tested it, and it works.


An Excel workbook that is connected directly to a SQL server, and then connected to Power BI (either from OneDr

... Read More

If you're talking about Excel Online in Office 365 connecting to on prem data, that is possible with the Gateway if you're using PowerPivot. You can use Power BI to sched

... Read More
Definitively, Power BI has to be the way to go since I expect Excel Services will dissapear at some time from SPO as it happens in SP 2016

i have the following scenario:

I have an on premise SSAS Cube and an Excel Sheet which connect to this Cube and the user is able to filter and work with the data. Now the Excel Sheet should be placed in SharePoint Online and the user should be still abl... Read More
0 Reply

Column 'UserId' in Table 'UserActivity' contains a duplicate value '123C5CF6FC0DF903076CC379DB1CCB03' and this is not allowed for columns on the one side of a many-to-one relationship or for columns that are used as the primary key of a table.

Next refresh

... Read More
0 Reply

Hey Guys/Gals


Searched but could not find this asnwer.


What happens when a user no longer works at the company? Can the PowerBI Dashboards/Data be transfed to a different user? Does this require a ticket with Microsoft? Has anyone ever done this or gone t

... Read More
4 Replies

Are you asking if you can assign permission to another user to have access to Power BI Dashboard? Power BI is a cloud-based service where data and the back-end engines ar

... Read More
34 Views and not 1 comment...dang...didn't know I tripped anyone up.... Guess its time to open a support ticket

If your organization enables Excel Services for SharePoint to enable BI, we have some updates on what has changed with SharePoint Server 2016 BI. Updates include architecture changes to the SharePoint-based on-premises Microsoft BI Stack and how you can b

... Read More
3 Replies
Does Microsoft even official released the SharePoint 2016 yet?

Great to see SharePoint BI is still under Microsoft investment even today PowerBi is the new altenative. 

TL;DR:  Is it possible in any way to get access to the usage information on a per site / per site collection basis and include external users?


I'm trying to get some stats for SharePoint usage, but I'm really struggling.  It seems audit reports aren't ava

... Read More
0 Reply

For a Client of mine i am trying to create a dashboard of all documents in a sitecollection.

it was no problem with odata.feed. but problem with that was that i can not schedule it to refresh.


i finally used web.contents. to refresh the data this works but

... Read More
12 Replies
Sorry @Treb Gatte it is still not working just tested it a moment a go..
sorry for my late reply i am going to check it!

Have you worked through this blog post's code? This might provide some hints. http://makingthings.work/connect-power-bi-to-sp-search/

Read More

Guys, is it right that all users who wish to view a power bi dashboard on SharePoint page require a Power BI liecnce ? 


If yes, Then I find this mad! 

25 Replies
Hi John.

It's currently correct but won't be when the new "Power BI Premium" comes into force. This will allow for "unlicensed" users to consume content.
PowerBI Premium is... Read More

Anyone trialling this too and seeing their refresh disabled? Any pointers on why this has happened and how to fix this?



3 Replies

When will the embed PowerBI Report Modern Webpart be available in SharePoint Online. This was shown at ignite a long time ago but, there has been no news about it since then.

7 Replies

Power BI embedded in SPO is going to be available in a few weeks

Best Response confirmed by Scott Mckenzie (Contributor)

Hi Guys


In my on-premises SharePoint 2013 farm I have configured another domain as a two-way non transitive trust. I'm using the SharePoint farm to host PowerPoivot workbooks with BISM connections to an analysis services (same domain where I hosted my Sha

... Read More
0 Reply

I’ve been working to move a lot of my Excel reports to SharePoint from our file shares and have our users interact with them either directly through Excel online.  A lot of my reports contain data that reside in the workbook’s data model (PowerPivot).  It

... Read More
4 Replies

I see you are with the University of Wisconsin?  Is your Office 365 tenant in the govt Cloud?  I found out the hard way that Data models in Excel ARE NOT supported in the

... Read More

Can anyone tell me what the options are for displaying Power BI dashboards inside SharePoint on-prem?  And can you display individual charts as well?


Are there different options available for SharePoint Online?


5 Replies
That story is evolving. As noted above, building an app is likely your only option, but that should change over the next few months.
I think the only actual solution is tu use Azure PowerBI Embedded feature. You can read more about it here. https://azure.microsoft.com/en-us/services/power-bi-embedded/ Read More

We released a free Power BI News aggregation app today for Windows 10. Download it here: https://www.microsoft.com/store/apps/9NBLGGH51KVR  As this is a v1, any and all feedback is welcome.

Read More
3 Replies
V2 came out yesterday with enhancements. The release details are here: http://community.powerbi.com/t5/Service/Power-BI-News-App-for-Windows-10-released/m-p/63802#M12412 Read More
Great idea given how quickly Power BI iterates... what chance an iOS app too? :)

Is there any way to find the Week Number from a Date field using a custom column in POWER BI desktop app

5 Replies
In the Query Editor, select the date column. Go to the Add column tab. Under the Date button on the right side of the ribbon, select Week, then week of the year. That's t... Read More
Rashid, didn't catch, replacement of what? WEEKNUM in DAX works fine, or you mean Power Query? Here is also some function.

Didn’t find the latest news about that, do I understand correctly the feature is not implemented so far? If so, any hopes when it could be?

More exactly I speak about Excel2016 model published on SP2016. We are only going to deploy SP2016.

4 Replies
It's supposed to happen "soon". It's a top priority of the SSAS team who owns this feature.
Best Response confirmed by Sergei Baklan (MVP)

Why not a standalone Power BI Group?

5 Replies
We would need an app to consolidate all MS discussion sites in one page :P
Fortunately "BI and Data Analysis" appeared under the Excel group. Not exactly Power BI, but very close. You have to have good temper to follow community.powerbi.com on d... Read More
You can always visit http://community.powerbi.com

Agree. It's in the Yammer network. I'm going to need a wider monitor for all of these browser tabs......

Hi Pawel- thanks for the question. For now we recommend going to http://community.powerbi.com/ for general PowerBI questions that don't involve SharePoint. 

Read More

Hi folks,

Last weekend in London, I had the pleasure to present a session at SPS Events London "Bringing data to life using Power BI" - hopefully you will find the slides for your benefit! http://www.slideshare.net/techChirag/bringing-your-data-to-life-using-power-bi-sps-london-2016

Read More
3 Replies
Thanks for sharing Chirag, the resources slide is always interesting
Thanks Peatrick.

Usefull, thanks!