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.
75 questions
0
votes
0
answers
3
views
Odata feed from sharepoint server to get MS Project data
I am trying to fetch MsProject Server data from sharepoint 2019 into PowerBI Desktop via following API
/_api/ProjectData/
Its showing the data in preview but not loading into Power BI. Any suggestion ...
- 1,214
0
votes
2
answers
16
views
How long "Status" field takes on SP List
I have a SP list but we want to see how long does someone takes a status from New to In-Progress to Review to Approve to Publish a document on SharePoint. Is there a way to know? Thank you.
0
votes
0
answers
16
views
Move data from Power BI to SharePoint List
I would like to move the data from my Power BI dashboard table to SharePoint List without duplicates using Power Automate flow. I am using the run query against a dataset and parse JSON function in ...
1
vote
1
answer
12
views
Custom list in SharePoint On Premise Sites can be Export to Power BI site?
I created some custom lists in Team Site in SharePoint 2019 and created list items with custom columns, is this custom list can be possible to Export to Power BI site from custom list directly?
- 2,975
0
votes
1
answer
38
views
Date Stamping Status Changes in a SharePoint List without Power Automate
As of current, I have a SharePoint Classic list (through work we can only use Classic) which is used to track many things, of which status changes is one of them. There are around 6 statuses a job can ...
- 1
0
votes
0
answers
3
views
Creating a column with optimize (thumbnail) image to be used in PowerBI
I am building a report in PowerBI with content from a Sharepoint list. Everything looks good but the images are the original size, some 2,3 MB and I have over 300 making this report super big.
How can ...
0
votes
1
answer
18
views
Calculated column in MS Lists not ordering correctly?
I am trying to get a MS Lists calculated column to order numbers correctly (which subsequently is an issue in the PowerBI report that I pull using DirectQuery).
The column is to track Risk Weighting (...
- 3
0
votes
0
answers
42
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 ...
0
votes
1
answer
172
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/...
0
votes
0
answers
39
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?
- 41
1
vote
1
answer
29
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 ...
- 11
0
votes
1
answer
79
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 ...
- 41
0
votes
2
answers
70
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 ...
0
votes
1
answer
507
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 ...
- 33
1
vote
1
answer
7k
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.
- 11
0
votes
1
answer
878
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 ...
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 ...
- 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 ...
- 1,545
1
vote
0
answers
492
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 ...
- 37
0
votes
1
answer
140
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 ...
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 ...
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. ...
- 101
1
vote
0
answers
154
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, ...
- 379
1
vote
1
answer
2k
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 ...
- 157
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 ...
1
vote
1
answer
254
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 ...
0
votes
1
answer
4k
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 ...
0
votes
1
answer
26
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 ...
1
vote
1
answer
3k
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 ...
- 15
0
votes
1
answer
2k
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
0
answers
371
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 ...
- 11
2
votes
1
answer
14k
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 ...
- 1,281
0
votes
1
answer
614
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.
- 151
1
vote
1
answer
337
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 ...
- 135
2
votes
1
answer
970
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)...
- 23
0
votes
1
answer
26
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
2
answers
485
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 ...
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?
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 ...
- 41
0
votes
1
answer
514
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 ...
- 8,489
1
vote
1
answer
12k
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-...
- 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 ...
- 81
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 ...
- 11
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.
...
- 51
0
votes
1
answer
352
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 ...
- 115
4
votes
0
answers
255
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 ...
- 115
0
votes
1
answer
951
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 ...
- 115
3
votes
1
answer
840
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-...
- 43
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 ...
- 97
4
votes
1
answer
4k
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 ...
- 12.8k