Questions tagged [powerbi]

Power BI helps you build on your existing knowledge of Excel, amplifying your ability to understand and capitalize on the ever-expanding world of valuable, yet sometimes unwieldy, data.

Filter by
Sorted by
Tagged with
0
votes
1answer
10 views

PowerBI Desktop and the Gateway - lots of questions!

I currently am running a 2016 SP Server enterprise instance with a separate SQL server for our data. We are looking at using Power BI to replace our current reporting functionality. I'm new to this as ...
0
votes
1answer
34 views

Adding status of files in power Bi dashboard

I have a document library with document status as pending, approved, rejected. I want to show status of document in power BI. But column fields are not visible. What must be the connector I have to ...
0
votes
0answers
10 views

How can I upload information in PowerBI from Sharepoint lists of more than 5000 items?

We have a list that has exceeded the threshold of 5000 items. We want to do operations with PowerBI with the elements of that list but we are not able to load the information due to the threshold of ...
1
vote
1answer
130 views

Ho to Change Author ID from SharePoint list to names in Power BI?

I am creating a dashboard with share Point online list. I want to show number of task created by each person. But, the report is showing numbers (Author ID) How do I change to names?
0
votes
0answers
31 views

Embed Power BI report in web application - Error - Invalid username or password

I am trying to embed Power BI report. I am trying to get token using this blog code. I am using code sample from this blog. I have given all required Power BI permission in my azure app. The issue is ...
0
votes
0answers
25 views

Remove HTML and ?XML Tags & Script from Data - POWER BI

I'm new to "M" and I have a question that I think should be pretty simple but I can't find the right answer anywhere. I am connected to a SharePoint List through Power BI and a few of the columns in ...
1
vote
1answer
28 views

Power Apps form embedded in Power BI to update Sharepoint List

I created a SharePoint Online list that tracks cases. Users review and update cases through a Power Apps form on the site. I also have a Power BI visualization that is querying the SharePoint list to ...
0
votes
1answer
80 views

Converting rows to columns in SharePoint Online List PowerBi Report

I have 2 SharePoint List. Project(Project_ID, Project_Title) and Project_Tasks(Project_ID, Tasks_Title) [here Project_ID is lookup column from Project list.] I have data as: I am able to ...
0
votes
1answer
268 views

SharePoint Date wrong in Power Bi

I have a list in sharepoint where in create items with date and time amongst other data. Eg. I have one where I entered the date 14-06-2019 05:00:00 Now when I pull this into Power Bi the date is 14-...
0
votes
0answers
11 views

How could one go about expanding the web parts for full screen experience? (i.e. Power BI embeded reports)

I have created Power BI reports and successfully embedded them onto SharePoint and end users are able to access them no problem. The problem that I am trying to resolve is the issue that the reports ...
0
votes
1answer
16 views

Successful API build, but now what [closed]

So I am pretty much self taught on SharePoint and have just recently built a Rest API off one of my lists. Now say I wanted to ingest that API into a program like power BI? is that possible? I guess ...
1
vote
0answers
11 views

use sharepoint online content viewing data in power bi

My business is requesting an adoption report. Simply put they need to know how many times our external customers are viewing the contents of the libraries. I know on site level there's a content ...
0
votes
0answers
8 views

Updating PowerBI datasets

I have a PowerBI dashboard on a SharePoint site that I want to display as updated data as possible. But the only scheduled update I can find is weekly or daily. Can it be updated eg. every 5 minutes ...
0
votes
0answers
9 views

is there a way to create SharePoint page with tabs to EXCEL and Power BI?

We have an EXCEL workbook in 0365 and a Power BI report. I would like my users to have a simple tab that allows them to switch between these two apps. I don't want them to open the full-blown ...
0
votes
1answer
1k views

Power BI - This content isn't available. Learn more about Power BI

I have replaced a colleague who has left the company 1 month before my arrival. Hence he could not give all permissions directly to me but the management and the support team has to deal with it. ...
0
votes
1answer
169 views

PowerBI Maps not supported SharePoint Online

I have built a PowerBi report using ArcGIS based on a SP list that stores user information i.e where they are based when they submit a request. However when using the PowerBI webpart on the modern ...
3
votes
0answers
94 views

Sharepoint audit reports automation with power bi

I was wondering if this possible. To automate the SharePoint Online Audit log report i.e a user viewing a page of the site from the excel spreadsheet and using powershell (im assuming) to create a ...
0
votes
1answer
132 views

SharePoint Online - Get User Information & Location

I have built a powerapp form for requesting access to certain groups. This app is then submitted into the SharePoint list. In this list it stores the information based on the user who has created the ...
3
votes
1answer
271 views

ADFS Single-Sign-On for SharePoint 2013 on-premises, Power BI and custom web app?

Scenario There is one user store, namely an on-premises AD. ADFS provides authentication for SharePoint 2013 and Power BI. The custom web app needs to authenticate users from AD. The web app back-...
1
vote
1answer
301 views

Sharepoint List data with Power Bi

I am trying to generate a report on a Sharepoint List with Power Bi. The list is a custom made list solely used for users to raise tickets With Power Bi, I am able to pull the Sharepoint List Data ...
4
votes
1answer
1k views

Embed Power BI report on SharePoint on-prem page, with SP List as data source and repeatable deployment?

I have asked a similar question about PowerView/PowerPivot, but I have not gotten an answer, and through further research, I'm starting to think I can't get done what I want to get done using ...
2
votes
1answer
37 views

SharePoint Online E1 with Power BI Webpart

As per MSDN, O365 E1 license doesn't support Power BI Webpart. (https://technet.microsoft.com/en-us/library/sharepoint-online-service-description.aspx) Can E1 licensed user view the power BI report(...
4
votes
1answer
161 views

What are the different ways to embed Power BI report in Sharepoint Online?

I know two ways, First one is, using modern site page with Power BI webpart. The second option is, using script editor webpart with iframe code generated in Power BI tool In the first option, I am ...
0
votes
3answers
163 views

Make SharePoint list dynamic?

I have a Power BI dashboard connected to a SharePoint list. One of the columns in the SharePoint List is a "Today" column and automatically inputs the current date. The problem is that the "Today" ...
0
votes
0answers
211 views

Nested JSON data to SharePoint list item

So I've recently been tasked with finding a way to retrieve data from an api call, then upload that data back to a SharePoint list item and all followed by that it has to be pulled back into a PowerBi ...
2
votes
2answers
2k views

Power Pivot support in SharePoint online

We have SharePoint 2010 environment and we are using Power Pivot service for reporting and data source as SharePoint list. Since now we are migrating to SharePoint online (Office365), So Could anyone ...
0
votes
2answers
665 views

Power BI Report Not Visible

I have a small problem hat i am facing currently, this involves Power Bi. I am trying to view my report on Sharepoint Online Site Page and the report is also visible but the problem is it is only ...
1
vote
0answers
97 views

PowerBI Report webpart in SharePoint 2016

I have a rather weird problem regarding the SharePoint webpart for paginated reports in PowerBI. After adding the webpart and configuring it to show a report from the powerbi server, it will work at ...
1
vote
1answer
39 views

Report Office 365 settings with Power BI

Can I use Power BI to report on the Office 365 system, including all apps, settings? I would like to build (and eventually schedule) a report showing all information that is visible on the admin pages....
0
votes
0answers
1k views

Embedding a PowerBI report inside a SharePoint page using “Publish to Web” Vs using “Embed in SP online”

I have a free account for PowerBI, and i did the following, to test how i can embed a PowerBI report inside sharepoint pages (sharepoint on-premises + sharepoint On-line):- I create a new PowerBI ...
1
vote
0answers
22 views

Versioning of lists for analysis

Update Well, I found a partial solution to my question. So, I have to update it. The way to extract information for my purpose is by turning on versioning. However, I am still not sure how to extract ...
0
votes
2answers
789 views

How to add Power BI Web part in Web Part page in SharePoint Online

Is there any way we can add Power BI web part in web part page in SharePoint Online?
0
votes
0answers
36 views

Make copy of online Power BI report which is Embedded in .net

I have One online Power BI Report , And our team embedded the report in .net via html5 and knockout ,angular js. My client wants a button through which on clicking it a Copy of that report get's ...
2
votes
1answer
309 views

Can we use Power BI to generate reports from SharePoint 2013 ON-PREMISE data (list and libraries)?

There are a lot of articles talking about integration of Power BI with SharePoint online. Can we use Power BI to generate reports from SharePoint 2013 ON-PREMISE data (list and libraries) ?
0
votes
1answer
46 views

PWA through PowerBI missing Priority

I am looking to pull data from PWA into PowerBI. When I add the Project table in, I don't see the Project field "Priority" This is kind of a key field for us and I don't know where it is.
0
votes
1answer
42 views

Show a percent as a stand-a-lone on Power BI dashboard

I want to get the percentage from two columns (ColumnA and ColumnB) and show it up on my Power BI dashboard as a stand a lone card. Do I have to make a calculated Column first? Then how do I get ...
3
votes
3answers
2k views

Power BI issue with Internet Explorer

Power BI is added in a share point online site using script editor. It is working well on Chrome but not appearing when browsed in IE. I have IE11. The issue is with all the users. Can someone suggest ...
3
votes
1answer
218 views

How to Build Power BI Report that reads info on all SharePoint Online site collections?

What is the best approach to build a Power BI Report that reads info on all SharePoint Online documents from all site collections in an Office 365 Tenant? I’d like to build a report from all ...
0
votes
2answers
68 views

What is the license terms for Power BI reports for streaming data

Is the Power BI license calculated by report render , I read https://powerbi.microsoft.com/en-us/pricing/?b=1 but i am confused ? Could you tell me what's mean 10K rows per hour streaming data ...
0
votes
1answer
1k views

How do I remove html from SP list text field?

I'm doing some reporting in Power BI based off a data connection to a SP list/form that multiple users fill out. One of the fields is a text description field, and I would like to display the text in ...
1
vote
1answer
5k views

Get data from SharePoint Folder using Power BI

Can I show image and meta data details from SharePoint online asset library in PowerBI report, I tried to use SharePoint Folder as data connection but I got this error : Unable to connect : ...
1
vote
0answers
227 views

Using PowerBI to show sharepoint online usage

I would like to provide a usage /audit reporting for SharePoint Online I have enabled Audit logs and i can view the excelsheet report. What im not sure about is do i have to go and create the report ...
0
votes
1answer
450 views

PowerBI in Sharepoint 2013

Has anybody of you experience with integrating PowerBI Dashboards/Tiles into SharePoint ? For my case I am searching a solution, where I can get Dashboards/Tiles via JSON File. Iframe is not a ...
3
votes
1answer
779 views

Is it possible to setup Kerberos for Power BI in SharePoint Online

I would be very grateful if someone could share their knowledge or experience with SharePoint Online + OLAP. Is it possible to configure Kerberos for Power BI for SharePoint? What we have: On-...
0
votes
1answer
121 views

Cannot get O365 PowerBI scheduled refresh to work with an on prem SQL server data source

Can anyone help with an issue I'm having getting O365 PowerBI scheduled refresh to work with an on prem SQL server data source? I have setup the Data Management Gateway and it can connect to the data ...
1
vote
1answer
54 views

How does licencing for Sharepoint (BI tools) on O365 work?

I'm looking at http://www.microsoft.com/en-us/powerBI/pricing/buy-bi.aspx The PowerBI addon licence grants me the following extra features: BI Sites Scheduled Data Refresh Data Stewardship Mobile ...