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
0answers
10 views

Not all fields appeared from sharepoint list to Power BI

I'm connecting SharePoint list to power bi. I observed not all the fields appeared on power bi I tried searching different options but nothing found helpful for me. (Here I tried option if original ...
1
vote
1answer
30 views

How to get version history of a SharePoint list item in to PowerApp

I have a SharePoint (V.2016) Online List on which a PowerApp application is developed. The App is like of Approvals/Rejection timelines etc. For Audit trail we can go to the specific item in to the ...
0
votes
1answer
52 views

Connect excel file in Excel Web in Sharepoint to external SQL server

It is the first time that I am using the web version of excel with external data sources on Sharepoint so I hope that you can help my with that. I do have an Excel list that grabs data from an on-...
1
vote
0answers
17 views

SharePoint Document Library - get filename and then use that file path to read the file in Power BI

I have a quick question around SharePoint on premises and Power BI Desktop. I have fairly extensive experience in SharePoint but just getting started with some Power BI integration. My requirement is ...
2
votes
1answer
1k views

How to resize webpart in SharePoint Online Modern Experience

I met the following situation, I'm trying to embed Power BI report to a SharePoint Online page, I managed to do that by using Power BI webpart as it shown bellow : now I wonder if there is a way to ...
0
votes
1answer
48 views

How to count the values of an option in Power BI multiple choice list, List is Imported through SharePoint List

I am trying to get the count value of 'standard' from the following in PowerBi: Change Type: Minor, Standard, Emergency.
1
vote
1answer
23 views

How to add fields like Text1, Text2 or Number1 Number2 to Formula in Enterprise Custom Fields for Reporting in Project Online/ Project server

How to add fields like Text1, Text2 or Number1 Number2 to Formula in Enterprise Custom Fields for Reporting in Project Online/ Project server. In formula I am not able to find the property Text1 or ...
2
votes
1answer
137 views

how to auto collate all file(*.csv) into one

Need help to automate below step. 300 users add file with extension (*.csv) in a shared folder. End of the day I download the entire folder and extract file (as folder gets downloaded in .zip format)...
0
votes
0answers
42 views

Multiple choices person or group - error in power bi

I got this problem, when i've choosed several technicians like pic below I get this error in Power BI "1 of the loaded queries contained errors", and the column gets blank. If I change the sharepoint ...
0
votes
1answer
21 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
2answers
100 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
27 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
1k 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
211 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 ...
1
vote
1answer
105 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
228 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 ...
1
vote
1answer
1k 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
1answer
17 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
12 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
1answer
2k 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
217 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
120 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
301 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
387 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
859 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
2k 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
40 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
238 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
261 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
291 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
751 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
108 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
48 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
2k 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
23 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
869 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
39 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
350 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
50 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
50 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
3k 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
241 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
70 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
2k 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
8k 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
232 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
499 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
829 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
122 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 ...