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
1 answer
76 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 ...
user avatar
0 votes
0 answers
4 views

CDS for apps table "admin_apps" does not contain data about portal apps

I want to fetch the last date an app was run on. For Model-Driven and Canvas apps I do so by quarrying the data in the CDS table named "admin_apps". But this table only contains data about ...
user avatar
0 votes
1 answer
97 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 ...
user avatar
  • 1,126
0 votes
0 answers
24 views

Is Power BI supported in SharePoint Server Subscription Edition?

As per below article, SharePoint 2019 supports Power BI along with power apps and power automate. https://docs.microsoft.com/en-us/sharepoint/what-s-new/new-and-improved-features-in-sharepoint-server-...
user avatar
0 votes
0 answers
108 views

Power BI - Display quantities for overlapping categories

I have slicer with categories. If I select category A and C then other visuals will show me all of the data for A and all of the data for C. However, the same product can belong to multiple ...
user avatar
  • 37
0 votes
1 answer
295 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 ...
user avatar
0 votes
0 answers
12 views

Import Excel custom 3D Maps to Power BI

any step available to show how to import custom 3D Maps from Excel to Power BI?
user avatar
  • 29
1 vote
0 answers
97 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 ...
user avatar
  • 37
0 votes
0 answers
16 views

Unable to connect to SharePoint list from Power BI

After working with a SharePoint list for a number of weeks and having successful data import to Power BI, we made some changes to the list to remove old columns and change the value types on a couple ...
user avatar
0 votes
0 answers
10 views

SPO Specific Activity Reports w/ Power BI

Is there any solution (MSFT provided, w/o custom solutions e.g. PowerShell etc.) to being able to view a list of any documents stored on an SP tenant - regardless of what site/list they're in - and ...
user avatar
  • 1
0 votes
1 answer
38 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 ...
user avatar
  • 972
1 vote
0 answers
16 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 ...
user avatar
0 votes
1 answer
2k 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. ...
user avatar
  • 101
1 vote
0 answers
33 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, ...
user avatar
  • 377
0 votes
1 answer
464 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 ...
user avatar
  • 137
0 votes
1 answer
32 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 ...
user avatar
1 vote
1 answer
36 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 ...
user avatar
0 votes
1 answer
1k 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 ...
user avatar
0 votes
1 answer
23 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 ...
user avatar
1 vote
1 answer
1k 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 ...
user avatar
0 votes
1 answer
994 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-...
user avatar
1 vote
0 answers
219 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 ...
user avatar
  • 11
2 votes
1 answer
9k 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 ...
user avatar
0 votes
1 answer
305 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.
user avatar
  • 151
1 vote
1 answer
136 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 ...
user avatar
2 votes
1 answer
784 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)...
user avatar
0 votes
1 answer
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 ...
user avatar
0 votes
2 answers
333 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 ...
user avatar
1 vote
1 answer
5k 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?
user avatar
1 vote
1 answer
677 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 ...
user avatar
  • 41
0 votes
1 answer
391 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 ...
user avatar
1 vote
1 answer
7k 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-...
user avatar
  • 147
0 votes
1 answer
19 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 ...
user avatar
1 vote
0 answers
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 ...
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. ...
user avatar
0 votes
1 answer
305 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 ...
user avatar
3 votes
0 answers
167 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 ...
user avatar
0 votes
1 answer
646 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 ...
user avatar
3 votes
1 answer
725 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-...
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 ...
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 ...
user avatar
  • 12.3k
2 votes
1 answer
57 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(...
user avatar
4 votes
1 answer
383 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 ...
user avatar
  • 196
0 votes
3 answers
461 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" ...
user avatar
0 votes
0 answers
439 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 ...
user avatar
  • 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 ...
user avatar
  • 1,069
0 votes
2 answers
821 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 ...
user avatar
1 vote
0 answers
117 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 ...
user avatar
1 vote
1 answer
52 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....
user avatar
  • 896
0 votes
0 answers
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 ...
user avatar
  • 972