Skip to main content

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

How to get the embed link for the PowerBI report created through the SharePoint Online's Integration feature?

For context, in an SPO list, there's a cool feature where you can quickly spin up a PowerBI report by going to Integrate > PowerBI > Visualize this list. I get that by publishing the report to ...
user113227's user avatar
0 votes
1 answer
40 views

SharePoint embedded Power BI report not working with dynamic URL (using embed webpart)

I'm having an issue with a dynamic URL not working when added to a SharePoint page as an embed (using the Embed webpart, not the Power BI webpart). The URL is as follows: https://app.powerbi.com/...
zestyphresh's user avatar
0 votes
0 answers
18 views

hide bottom toolbar of Power Bi Dashboard

I created a site page in which I used embed option to embed my Power Bi Report. Now I want to hide the bottom section as shown in the image. How can I achieve this?
Renuka's user avatar
  • 39
1 vote
1 answer
21 views

Power BI integrated from a SharePoint list

I have a Power BI visualization created via a SharePoint list integration. I can therefore view the visual tools through the SharePoint list. However, I would like to display the visualizations on ...
Ceesh's user avatar
  • 11
0 votes
1 answer
37 views

Power bi report not visible on site page

I created a site page for power bi report, but the report is only visible to me no other users can view that report. There is an error showing on that page: "Upgrade the current Power BI license ...
Renuka's user avatar
  • 39
0 votes
2 answers
34 views

How can I provide access to different user over the Power BI report embedded into SharePoint page

I have a power bi report and is embedded to SharePoint Online page. Now, users other than me if trying to open the SharePoint page, unable to view the Report over the page and getting below error: It ...
Kailash Sahoo's user avatar
0 votes
1 answer
122 views

Power BI Report to Display A SharePoint List Item's Attributes

I created a Power BI report to display list items from a SharePoint List. Can someone lead me in the right direction as to how to display the item details in another report page, or even in the same ...
Gary Mc's user avatar
  • 33
0 votes
0 answers
8 views

Whenever I click on any item on Powerbi dashboard, can the item be updated (number addition) on the SharePoint list

I was trying to create a voting dashboard on Powerbi. Now I want to make that dashboard interactive with live voting. So whenever there is a click on any item of any column on that dashboard, I want ...
Naman Mehta's user avatar
0 votes
0 answers
17 views

Power BI Embed code, created from SharePoint list

I know how to find and add the embed code to the SharePoint online web part when you create a report from PowerBi. However, I need help finding the embed code when I make a report from the SharePoint ...
Harris's user avatar
  • 595
0 votes
0 answers
41 views

Power BI embed on SharePoint is not showing UK date format for slicer visual

We have slicer visual on our Power BI report. We need the slicer date display in dd/mm/yyyy format. The slicer is showing correct format before but recently we found that our report's slicer visual is ...
Mark L's user avatar
  • 4,065
1 vote
1 answer
5k views

How can we integrate Microsoft planner with Power Bi

As I checked there is no planner connector available in Power Bi. Is there any way to connect planner with Power Bi directly.
aziz khan's user avatar
0 votes
1 answer
785 views

Import data from multiple excel file to SharePoint list using power automate

I have more than 150 excel files which all have same information table to update their production from different location. my question is can I use Power Automate to import and consolidate all data in ...
Mahmud Ankur's user avatar
0 votes
1 answer
2k views

How to get multi selection look up value in Power BI report?

I am new in Power BI and working on creating a simple report. I have 2 list - "Country" and "Test" which contain invoice amount. Country is multiselect look up in Test list. I need ...
love thakker's user avatar
  • 1,138
0 votes
1 answer
2k views

PowerBi reports and SharePoint permissions

I'm looking at creating a Power Bi report / Dashboard which gathers information from numerous SharePoint sites. I will be using a user(system) account with Power Bi licence. This system user will have ...
Orange Juice Jones's user avatar
1 vote
0 answers
440 views

Power Bi - Power Automate Flow does not trigger when embedded in the SharePoint

I have added a Power Automate button into my Power Bi report and set a flow. When button is pressed it refreshes the report. This works when I open the report in Power Bi workspace and it takes less ...
Guest's user avatar
  • 37
0 votes
1 answer
116 views

Show charts inside my modern page

I want to build 3 charts and show them inside my SharePoint online modern page, the charts are as follow: First chart is to group the items from a single SharePoint list by Created date, and show the ...
John John's user avatar
1 vote
0 answers
24 views

sharepoint power bi libraries

I published power bi reports to cloud service. Power BI reports include python codes but python path is connected to SharePoint folder. But the problem is the python libraries. How can I install ...
melik masarifoğlu's user avatar
0 votes
1 answer
3k views

Unable to get Sharepoint Online data Web data source for Power BI

What I wanted to do is to get the data for Power BI from web datasource. The excel data was uploaded in sharepoint online as document and then I copied link for url data source on the power BI side. ...
afikri's user avatar
  • 101
1 vote
0 answers
136 views

Power Bi query to get SharePoint Group Names

I am attempting to make a report from my 2013 SharePoint Farm. I can't figure out how to convert SharePoint Group IDs to the Group's Display Name for my Power BI report. I found the OData Feed, ...
amsackett's user avatar
  • 379
1 vote
1 answer
1k views

Can I automatically export the Excel file for the Site Usage Report daily?

In my SharePoint site there is an option to "Download 90 day site usage data" and I would like to be able to do this automatically every day. My end goal is to use this data to make my own ...
MikeDurso's user avatar
  • 147
0 votes
1 answer
36 views

Power Bi for small company. will the free version satisfy our needs [closed]

We are a new startup with 5++ employees, we need to use PowerBi as follow:- we have our own SQL server 2017 which contain info about suppliers, and the SQL is hosted in the cloud One of our employees ...
John John's user avatar
1 vote
1 answer
219 views

Showing all the entries inside a SharePoint Multiple line of text which have append changes to exsisting text enabled

I have the following field inside my SharePoint list:- inside SharePoint view when we click on an item we can view all the entries inside the above field along with the date and the username.. but if ...
John John's user avatar
0 votes
1 answer
3k views

How I can show the user-names for a People or Group site column which allow multiple selection inside our PowerBi report

I have a SharePoint online list which contain 2 site columns:- People or Group site column which allow multiple selection People or Group site column which allow single selection and i am showing ...
John John's user avatar
0 votes
1 answer
25 views

PowerBI Online Service Display of Parameter Values

I have a report with Start/End date parameters which the User can update in the Online PowerBI Service, and when I upload the report, I also have a card displaying (next to the report grid) to show ...
Carl Porch's user avatar
1 vote
1 answer
2k 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 ...
Akshay Manke's user avatar
0 votes
1 answer
1k 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-...
Benedikt W's user avatar
1 vote
0 answers
357 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 ...
Rafay's user avatar
  • 11
2 votes
1 answer
13k 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 ...
AIMEN BOULAHIA's user avatar
0 votes
1 answer
575 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.
Noman's user avatar
  • 151
1 vote
1 answer
321 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 ...
georgyfelix's user avatar
2 votes
1 answer
946 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)...
Shubham A's user avatar
0 votes
1 answer
25 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 ...
Sarah Grzymkowski's user avatar
0 votes
2 answers
460 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 ...
Bhuvana Sundar's user avatar
1 vote
2 answers
10k 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?
Bhuvana Sundar's user avatar
1 vote
1 answer
1k 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 ...
lain91's user avatar
  • 41
0 votes
1 answer
500 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 ...
Aakash Maurya's user avatar
1 vote
1 answer
11k 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-...
Anders's user avatar
  • 157
0 votes
1 answer
21 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 ...
hittle08's user avatar
1 vote
0 answers
13 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 ...
user1728501's user avatar
0 votes
1 answer
3k 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. ...
Guido Matis's user avatar
0 votes
1 answer
348 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 ...
Danielle Sutton's user avatar
4 votes
0 answers
231 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 ...
Danielle Sutton's user avatar
0 votes
1 answer
875 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 ...
Danielle Sutton's user avatar
3 votes
1 answer
834 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-...
Suthan Bala's user avatar
1 vote
1 answer
2k 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 ...
Tommy0824's user avatar
4 votes
1 answer
3k 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 ...
Dylan Cristy's user avatar
  • 12.8k
2 votes
1 answer
82 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(...
Ravi Nuthakki's user avatar
4 votes
1 answer
460 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 ...
Arulraj's user avatar
  • 196
0 votes
3 answers
537 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" ...
Samantha's user avatar
0 votes
0 answers
614 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 ...
Jherb's user avatar
  • 1