sharepoint folder

5 Topics

sharepoint folder as a data source
Hi guys, Is that possible to refresh the Power bi files(reports) which are getting data from a sharepoint folder? I can connect my power bi desktop to sharepoint folder with no issue with Microsoft Authentication. However, when I upload this to report server, it does not refresh. When I try to use microsft authentication in Data source setting, it doesn't have that option. Any help would be much appreciated.
Solved
Anonymous
4 years ago Place Report Server
2.3KViews
0likes
2Comments
Unable to display image from sharepoint document library in power bi report builder
I am trying to display images that is stored in Sharepoint Document Library on the Power BI Report Builder. What I have done was, creating a table, insert the image object into the field and assigning the image url from dataset. an example of the Image URL is: https://[server]/sites/[sitename]/[subsite]/SiteAssets/Lists/a9ec4a6c-0f27-4ae7-8430-bd55924786ec/POCA%20diagram.jpg When I published the report and tried to generate the report. It does not display any image I suspect that it might the security issue, but I am not entirely sure cause I do have access to to the Sharepoint Site. Need some guidance here. Thanks in advance.
Anonymous
5 years ago Place Report Server
1.7KViews
0likes
2Comments
Best Option for Power BI Data Repository
The current Finance role that I am in involves standardizing reports for a wide audience to use. I have developed multiple Power BI reports that others are using, and I want to have a data repository for all current and future Power BI reports. The current location of my data is on my personal computer, but I want the data to be available for other analysts to grab when they want to develop their own Power BI reports/analysis. Unfortunately, I cannot connect directly to SAP HANA (IT will now allow it) but instead have to query the data out of SAP HANA using Analysis for Microsoft Excel and connect to flat files/workbooks that hold the data. I am currently trying to decide on the best location to house the data for the Power BI reports, and I am currently looking into using SharePoint, SQL database, a shared server, or Azure. I think Azure is the least likely option due to cost and the required involvement of IT, but I still want to include it as an option, nonetheless. Is there someone that can give the pros and cons of each (to use as a data repository) for the organization’s Power BI reports? I have never used SQL or Azure as a data connection in Power BI, so any information would be helpful. It is just me that will be maintaining this data repository, so I am trying to keep it simple but efficient. Ideally, I would not be adding a week’s working hours as a database administrator on top of my current role. Below are what I have so far as my options: SharePoint- This is the option I am leaning towards mostly as of now. Pros -It would not require an on-premises data connection for Power BI Service. -Can use a macro to refresh the queries held in each excel workbook that would be held on SharePoint and then refresh the reports in Power BI Service -The team I work for manages the SharePoint site for the organization -It would not require additional cost unless we start to get close to the storage capacity of our SP site Cons -Takes a long time to bring data into Power BI Desktop and slower refresh connecting to an online data source -Can potentially be a lot of excel workbooks and folders SQL database Pros -Can use Select statements within Power BI reports to gather only the data I would need instead of pulling in an entire dataset (Not a huge benefit I think but a benefit, regardless) -Additional capabilities in Power BI because of connection to database? (Direct Query?) -Can create relationships between datasets (Not sure if I would use/need this feature) Cons -Would have to use an on-premises data connection for Power BI Service. Would maybe require a virtual machine to run scheduled refreshes. -Would require the skill and time to manage the database Shared Server Pros -Would be faster than using SharePoint (Online data repository) Cons -Would have to use an on-premises data connection for Power BI Service. Would maybe require a virtual machine to run scheduled refreshes. Azure- Do not know too much about this option. Pros -Can handle a lot of data (More than a SQL db I believe) -Additional capabilities with Power BI? -Would I need an on-premises data connection in Power BI Service for this, since the data is housed in the cloud? Cons -Most complex solution -Costly -Would most likely require assistance of IT
Solved
astanfo
5 years ago Place Report Server
13KViews
0likes
13Comments
Emails triggered by changes within a SharePoint Folder Excel file - Can it be done?
We have a user who has a PowerBI Report/Dashboard that connects to a SharePoint folder, more specifically, an excel document. There's a column that shows Open/Closed status, and she would like to know how to get an email notification triggered every time someone changes a status from Closed to open or adds a new row of data. I feel like there's a better way (SharePoint List w/ PowerAutomate), but wanted to know if anyone uses PowerBI to accomplish what we're trying to do...
JMACND
5 years ago Place Report Server
631Views
0likes
1Comment
Power Bi Report Server couldn't connect to SharePoint
HI All, Im try to connect to SharePoint via Server Report but I couldn't because the Power bi Server didn't accept my credentials also I use another credentials the same issue i see two Options only to connect (windows Auth , anonymous ) i didnt find organizational as I setup in the Power Bi file I use SharePoint Folder data source in the Power Bi file is any setup or configuration needed to do that ? Thanks
IslamAmer
6 years ago Place Report Server
1.6KViews
0likes
4Comments