on premise report server

13 Topics

Using SSO (Keycloak) authentication for PowerBI on premise (ReportServer)
Dear Community, We are currently using an on-premises ReportServer, with PowerBI, and are exploring options to authenticate our users through a Single Sign-On (SSO) IdentityProvider. In our case, we are utilizing Keycloak, and we would like to use either SAML or OAuth (OIDC) as the authentication type. We are seeking advice on how to achieve this. Is there anyone who has implemented this using OIDC or SAML? Are there alternative methods we could consider? Any guidance would be greatly appreciated. Thank you!
Solved
nickibrochner
1 year ago Place Report Server
4.3KViews
0likes
3Comments
Integrate SSO/SAML or OIDC authentication in PowerBI on premise (ReportServer)?
Dear Community, we are currently using an on-premises ReportServer, with PowerBI, and are exploring options to authenticate our users through a Single Sign-On (SSO) IdentityProvider. In our case, we are utilizing Okta, and we would like to use either SAML or OAuth (OIDC) as the authentication type. We are seeking advice on how to achieve this. Would we need to create our own SecurityExtension, similar to the Custom Security Sample provided on this link: https://github.com/Microsoft/Reporting-Services/tree/master/CustomSecuritySample? Is there anyone who has implemented this using OIDC or SAML? Are there alternative methods we could consider? Any guidance would be greatly appreciated. Thank you!
Anonymous
1 year ago Place Report Server
7.1KViews
2likes
3Comments
On 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?
Solved
Anonymous
2 years ago Place Report Server
691Views
0likes
1Comment
PowerBI Report Server Deployment advice
Hi Everybody, I wanted advice on the deployment setup we are using for a use case we are developing: - PowerBI Reports need to connect to on premises SQL Server - These PowerBI reports then need to be accessed over the public internet Current Deployment Setup: - PowerBI Report Server and PowerBI Destkop (Report Server) on an on premises Windows VM which has access to the on premises SQL Server I want to understand whether we would need the PowerBI Gateway or connection to the SQL Server might just be done through the PowerBI Report Server? Also, how do I make these reports available in the public domain? Any links to tutorials or docs will be appreciated Thanks.
Solved
hellodfkh
2 years ago Place Report Server
1.1KViews
0likes
1Comment
Take too long to Upload to PBIRS
Hi, I am considering to upgrade Power BI Report Server from 202209 to 202305, so I make some tests. There are two VMs in the same machine and these two are using the same settings when building. They are unable to connect internet and only for intranet usage. The only difference is the version of PBIRS version. Based on my testing, it works fine except uploading .pbix. It takes about 49.77 seconds to upload a14.7MB file for the 202305 version. By contrast, 202209 version only takes 7.04 seconds. Is there any difference to the v2.0 catalogItems API between 202209 and 202305 version? I list the timeing that Edge developer tool shows: 202305: Request sent: 36.58s Waiting for server response: 10.35s Content download: 2.78s 202209: Request sent: 297.51ms Waiting for server response: 4.65s Content download: 2.03s
Vanchy_Liao
3 years ago Place Report Server
306Views
0likes
0Comments
Export Power BI report to Powerpoint (on-premise)
Hi, Is that possible to export a report to Powerpoint from Power BI Desktop or from Power BI Report Server On-Premise please? Thank you in advance, Regards, Camille
Anonymous
4 years ago Place Report Server
3.2KViews
0likes
3Comments
Power bi report server on premise, memory
When a power bi report is deployed to report server it can be refreshed on a certain schedule But where is the in memory power bi model loaded ? I tried to analyze report server memory usage when activating report and not much happened on server Then i saw the browser increasing memroy on client - is the load mostly on the client ? But there has to be a tabular in memory model somewhere ?
Solved
mivar99
4 years ago Place Report Server
1.3KViews
0likes
1Comment
Solution for Power BI reports using Sharepoint list as data source?
I'm working on a company that has several Power BI reports launched in the report server and they all have data refresh that works great because all the data sources are inside the local network (//company/files/etc). I'm building a brand new system that uses Sharepoint lists as the main database and powerapps as a way to manipulate this database by adding and removing items from those lists. So all data is in there. After ceating a new power bi desktop report using it as the data source, it all went fine. But then I figured out it does not work at all when uploaded to the report server. After reading a bit the documentation it is clear and it does not support auto refresh or whatever for sharepoint lists sources, so it won't work. I've been digging the internet to find the best solution but I just cant find any. I have thought of using the Power Automate flows to create a schedule to download all the lists in the sharepoint list to the local network and then use this as the datasource instead, but I'm stuck with this "on-premise gateway", no idea how it works. Does anyone know a way to work around it?
Solved
Anonymous
5 years ago Place Report Server
3.5KViews
0likes
2Comments
On-Prem Report server User access + on-prem Sharepoint embed
Hello, I have been working on a powerbi report that i finished and uploaded to a report server. i would like to ask about letting other users in my orgnization view the report. i have added my friend ( user ) into the site settings of the report server + i added him to the folder + the report itself ( i added him into manage > secuirty folder level + report ). when i tried to open the report server in his PC its shows no folder and says contact your administrator . im not sure where i did wrong. added him to site settings + folder + report. in my orgnization we are using powerbi - premium 1) do i need to add his user to AAD powerbi to view (on-prem powerbi report server reports ) 2) if i embed my on-prem report into an on-prem Sharepoint using Iframe does the secuirty permission on reportserver work or do i have to use SQL permission?
Solved
azizalfarhan
5 years ago Place Report Server
1.8KViews
0likes
4Comments
How to save snapshots of your data to generate trendlines on PBI Report Server
I would like to ask a question regarding snapshot data for Power BI On Prem. I am having a lot of requirements lately regarding looking back at previously loaded information (to generate trendlines based on quantity deltas) Is there a way to store the result of a SQL query, attach it a timestamp, and generate a table that contains all the snapshots? Thanks!
Anonymous
5 years ago Place Report Server
929Views
1like
1Comment