sharepoint online
11 TopicsSharepoint online and Reporting server
I’m currently evaluating Power BI Report Server as a natural progression from our existing SSRS environment. The server is up and running, and I’m now in the testing phase. So far, connectivity to SQL Servers and APIs works as expected, and I’m aware that SSAS requires being added to the PBIRS trusted servers list due to the newer security restrictions. However, I’ve come across something surprising: SharePoint Online lists are not natively supported in Power BI Report Server. Although they work without issue in Power BI Desktop, PBIRS does not support OAuth authentication or scheduled refresh for SharePoint Online data sources, which means they cannot be used directly or refreshed once published. Instead, the recommended approaches involve exporting the SharePoint list data into SQL Server or using an intermediate connector or automation flow to sync the data to an on‑premises location before PBIRS can access it. Is anyone aware of any future developement to include this or is there any point using PBIRS if you have the Power Bi Service?Solved5.2KViews0likes3CommentsPower BI Image URLs from Tenant-Secured SharePoint – Intermittent Rendering Issues
Hi everyone, I’m experiencing ongoing issues with displaying image URLs in Power BI reports and apps, and I’m struggling to identify a reliable solution. Context We store employee/user headshots as image URLs in a user lookup table within the models. These images are used across multiple reports for UI elements such as: Logged-in user icons Employee of the Month visuals Leaderboards and other internal dashboards The images are hosted in a company SharePoint folder maintained by our Marketing team. All employees have view permissions to this SharePoint location (not anonymous access). Issue 1 – Power BI Service / Teams When opening reports in Power BI Service or via Teams, some images load correctly while others appear as broken image links. If I manually open the SharePoint image folder in my browser (authenticating via our tenant) and then refresh the report, the images display correctly. However, this only persists temporarily, typically by the next day the images are broken again. This makes me suspect an authentication, cookie, or caching issue rather than an issue with the URLs themselves. Issue 2 – Digital Signage We also surface these reports via a digital signage solution on screens around multiple offices. In this scenario, none of the SharePoint-hosted images render, they consistently show as broken links. Interestingly, the images display correctly in the digital signage platform’s preview, but fail once pushed to the physical screens. My assumption here is that the signage devices do not have the required authentication context (cookies / tokens) to access tenant-secured SharePoint images. Question Has anyone encountered similar behaviour when using SharePoint-hosted image URLs in Power BI? Is there a known or recommended approach for handling image authentication/caching issues like this? Are there better-practice alternatives for hosting images used in Power BI (especially for digital signage scenarios)? Would a different hosting method (e.g. public blob storage, CDN, base64 encoding, etc.) be more appropriate? Any guidance or suggestions would be greatly appreciated, as I’ve struggled to find clear documentation or examples covering this use case. Thanks in advance.1.3KViews0likes6CommentsPower Bi Report Server in Sharepoint Online
Hello, i have a server with Power Bi Report Sever, the intention is to insert one the reports in Sharepoint Online. According to the documentation I attach (https://learn.microsoft.com/es-es/power-bi/report-server/quickstart-embed) this should be possible, but I have a couple of doubts. The first thing is if someone who has done it can confirm that this is possible and works correctly for them. On the other hand, I cannot find documentation on how to make the Report Server publicly accessible. Nor if this entails risks or any If anyone can give me some light on this I would greatly appreciate it. Thank you.Solved1.6KViews0likes4CommentsOn premise server refreshing excel document from sharepoint online
we have a PBI report built on prem it has 2 excel spreadsheets as data sources from our sharepoint site -cloud connections work ok from the client, but we are unable to do scheduled refresh how to achieve this?Solved690Views0likes1CommentAuthentication type oauth2 missing for Report Server Schedule Refresh
Dear all, I would like to know, what is necessary to do on a Report Server side configuration in order to support oauth2 authentication type for (data source) Scheduled refresh. I am able to take PBI Desktop and use OneDrive / SharePoint online list or library like a source, I am able to refresh them manually or upload such a report to Report Server, however I am not able to configure Scheduled refresh for them (for any O365/M365 data source). There is simply no choice in the menu to use e-mail format of the credentials. Just Anonymous, Basic & Windows type credentials and none of this works. I also tried to use Web type connection with no luck, I tried to connect OneDrive folder like a network drive and use web type / excel type connection and again, with no luck. Thank you for any hint, tip or helpSolved2.8KViews0likes1CommentEmbeding Power Bi to Sharepoint
Hello Power Bi Community, I have a question regarding embedding a power bi report in SharePoint online. To give a little back context, I basically build a report in the power bi desktop Report server version with the primary purpose of uploading it to our report server so everyone in our organization with the link could get access to the report. This report needs to be manually refreshed and uploaded to the report server since my organization doesnt allow for external databases to have access to our network thus not allowing scheduled refreshes in the report server. I was however yesterday asked by my boss if we could embed the power bi report into our SharePoint online. Below are my questions about this situation: 1) Can you embed reports into SharePoint online without using the power bi cloud service (In the Microsoft Documentations I only saw instructions to embed reports into SharePoint online for the power bi cloud service). Would it be possible to embed the report server page that the report is currently on into SharePoint online? Cause at the moment the report is not in the cloud service of Power Bi but simply on my laptop. Thank you very much for your help in advance! Stay safe! 2) I saw that if you embed a report in sharepoint online all users must at least have a power bi pro or power bi premium license to see the report. Is there a workaround available for this so that even users who don't have a power bi license can see the report?Solved1KViews0likes2CommentsPower BI solution for business
I am trying to come up with best practice to use Power BI online for my/our company. We have Azure SQL on the backend for Power BI reports, and we are moving everything into Microsoft space (One Drive or SharePoint). We are trying to figure out the best way for users in our company to access Power BI online report in a central location (on a browser). I thought SharePoint would be the best approach, but I don't know if there is anything else. Is there different platform/template that users can centrally access Power BI online reports (on a browser)? How does costs related to the license of each user to access Power BI reports work? If we use SharePoint to access PBI reports, how does license cost differ from using PBI online reports directly?Solved1.1KViews0likes3CommentsFull Screen embedded report on Sharepoint online
HI how can i view a report in full screen after embedding it on sharepoint? If I publish the report on the web "public", there is a button at the bottom but I have not found anything similar by embedding it on sharepoint online. Thanks1.1KViews0likes1CommentSharepoint Online Embed - Can't change web part properties
Hello, We have several Power BI reports embedded on Sharepoint Online, and up until this week we have had no issues setting properties in the PowerBI web part. However, since this week we have had a lot of issues changing the properties within the web part. When we are adding a new report, after we paste the link to the report, the web part properties display normally. However, as soon as we try to change any of the properties, the entire properties pane becomes unresponsive and we are unable to change any of the settings. The report itself gets embedded with no issues. I had other colleagues try, and we are all experiencing the same issue. It's impacting both new reports and reports we have previously been able to set up with no issue. We've tried different browsers as well as accessing it outside our corporate environments. We are admins in Sharepoint as well as in the PowerBI workspace. What else is strange, is that it will work for one of us for maybe 1 in 25 tries for one time, and then it will go back to the same behavior. This is only happening with the Power BI web part, we are having no isses with any other web parts. Has anyone experienced something similar? Thanks for your time!1.2KViews4likes1CommentRefresh of Sharepoint Online Odata from power Bi report server
Hello, I was able to create a report in power bi desktop which connect to a Sharpeoint online site using Odata. To do so I had to use Organizational account as the Windows authentication was not working. Now when I publish the report on the report server and shedule a refresh I'm facing the error: The credentials provided for the OData source are invalid. So I want to edit the data source connection which is Odata. Problem is that the option are very limited and using Windows authentication fail "Log on failed. Ensure the user name and password are correct." You can't set up the the report server to use Organizational account. How to plan a refresh from the report server using Odata from a sharepoint online site ?2KViews0likes3Comments