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.
68
questions
0
votes
0
answers
12
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 ...
- 559
0
votes
0
answers
27
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 ...
- 4,070
0
votes
0
answers
109
views
How can I insert Postgres rows using Power Automate from a PowerBI Table?
Problem: In Power Automate I cannot get the rows from a PowerBI table source - using the 'First table rows' to populate the Insert Row (Postres) Action in order to insert the rows into my postgres ...
- 101
0
votes
0
answers
12
views
SharePoint site to display all report, published with in "My workspace" in Power BI
I want my SharePoint site to display all reports (titles & URLs), published within "My workspace" in Power BI. It should be automated so that in the future if new reports are added or ...
0
votes
0
answers
65
views
How to show count of SharePoint list column in Power BI Table Rows?
How we can show SharePoint list column count in power BI Table Rows as shown below:
SharePoint List Columns:
Power BI Table Count: ( we need to create this table of counts)
- 49
1
vote
1
answer
3k
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
0
answers
48
views
How do I create an auto-updating chart on my Sharepoint site
I have a seemingly simple usecase, that I can't figure out how to do, so here it is:
The Setup:
I gather a set data via PowerShell and write it into a CSV. For simplicity, just assume it's the amount ...
- 101
0
votes
0
answers
11
views
What is some useful information that can be extracted from the SharePoint_Logging DB using Power BI Desktop?
I've just started evaluating Power BI Desktop to expand on the built in reports in SharePoint Health Analyzer.
Does anyone has any tips about what data in SharePoint_Logging DB that is worth getting ...
- 111
0
votes
1
answer
594
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,136
0
votes
1
answer
1k
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,533
1
vote
0
answers
335
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
75
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
23
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
93
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
0
votes
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 ...
- 137
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
147
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
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 ...
0
votes
1
answer
24
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
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 ...
- 15
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-...
1
vote
0
answers
310
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
11k
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,221
0
votes
1
answer
489
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
270
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
904
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
24
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
418
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
8k
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
938
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
469
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,481
1
vote
1
answer
10k
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
343
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
204
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
798
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
817
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
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 ...
- 12.6k
2
votes
1
answer
73
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
1
answer
440
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 ...
- 196
0
votes
3
answers
516
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" ...
- 61
0
votes
0
answers
583
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 ...
- 1
2
votes
2
answers
4k
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 ...
- 1,069
0
votes
2
answers
830
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
0
answers
121
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 ...
- 351