on-premise report server
16 TopicsPower BI Reports on-premise deployment without any cloud access
Hi, We are evaluating Power BI as a potential tool for creating our Dashboards and Reports. We have the below Reuqirement. Objective: Create Dashboards and reports for our clients and deploy them in client machines which are fully on-premise (no public internet access). Development Environment: Our Developers will develop the reports in their local system using Power BI Report Server Desktop. Deployment Environment: Power BI Report Server will be installed in our client's machines and the reports will be deployed thorugh Report Server. SQL Server will also be available in the same machines. Limitation: Our client's systems are fully on-premise and there is no provision for them to connect to any kind of cloud (no public internet). With this limitation, will our above requirement work? Anyone here, who has built or is familiar with a similar setup, can you please share your insights on this. PowerBI Report Server Deployment adviceSolved3KViews0likes5CommentsBulk Permissions to Power BI Report Server
We have a number of users who have historically created reports on PBIRS on-premise (January 2023) with SQL 2019 as the backend Database however the permissions granted to the reports were best described as 'Mixed'. We would really like to push a default set of permissions for an AD Group to all reports on the server however I am unable to locate any details on how do to this. Is there any advice Many thanks in advance447Views0likes0CommentsExport paginated report from on-premise report server
Hi all, I am trying to automate the export of a paginated report to pdf. The reports are stored locally on an on-prem report server and i have a gateway to connect to power automate. My report database is a sql database and i can connect to it via the SQL connector in power automate. But i am struggling with "finding" the paginated report and make it available for the "export paginated report to pdf"-action. I am happy about any help, still very new in the power bi / power automate universe. Thanks!Solved666Views0likes1CommentPower BI Url Parameters
Hello PowerBI Experts, I have one brief question: Is there a way to edit a report url so that the custom url refers to a specific tab in the report? The report is uploaded on the on-premise Power BI Report Server. In addition to that, I'm not the creator nor the content manager of this report / reportarea.Solved969Views0likes2CommentsPower BI Report Server On-Premises licensing cost and configuration requirement
Hello My organization is interested in using Power BI desktop for developing reports and Power BI Report Server completely on-premises on our VM. Want to know about the cost for the same and VM configuration which will be used for the report server. What about consumers and report developers - a) Consumers need to view reports (Power BI report will be embedded in single page application). b) Developers need to publish reports using Power BI Desktop (approx 25 developers). Thanks in advance.Solved30KViews0likes6CommentsHow to take an input string on Power Bi server that then would be passed to a Python script
Hi all, I have a Python script as my data source that that goes something like that: user_date = input() query = "select ... from... where date = '{}'".format(user_date) df = pd.read_sql(query, conn) print(df)" I want the user to enter the data on the Pwer Bi reporting server (or preferably choose from a drop down menu that has the last 30 days' dates) and then this date would be passed to the python script somehow so it'd run and query the correct data. Thank you.Solved924Views0likes1CommentOpen button url in new tab instead of new window
Hi, Is it possible to open the web url (another power bi report) in a new tab instead of new window? I have a report with couple of buttons that links to some other reports, when I click on a button It opens the report in new non-resizable small. Can I open report in new tab instead of new non-resizable window? Problem only on IE, on Chrome works fine. Accoring to the link below is IE still supported https://docs.microsoft.com/en-us/power-bi/fundamentals/power-bi-browsers Current version: Power BI Report Server (on-premises) october 2020 Regards, GanendranSolved3.4KViews1like1CommentIs this a bug? SEARCH box not starting from current folder... instead starting from ROOT/Home
I'm not sure if there's just a configuration that needs to be set. The Search box for PBIRS is searching from Root/Home and not on from the current folder location and traverse down. Some users don't have "Browser Role" on Home but only has browser role in subfolders. How do you configure the SEARCH functionality to start from the current location and cascade down to its subfolders? Users are getting user permission issue because the search function is starting at HOME and it doesn't have the role set at that level. Please help... thanks.Solved638Views0likes1CommentSQL Server
Hi, We have a report we have created using sql server connections and then tables created on the fly in Power BI. The business is now wanting to publish this report but aren't able to as the data needs to be converted to SQL. However, from what I can gather (and I am certainly no expert) as long as the data is coming via a direct query to connect to the tables then this should be able to be published. There are some tables that need to be looked at as the below error message shows when trying to load the report, but once these are sorted you should still be able to transform the data within Power BI? If someone could help that would be greatly appreicated as I don't want to have to create all these new tables in SQL if not needed. TIASolved956Views0likes1CommentAccidentally removed elevated rights AD groups from a report
Hello Experts! I am hoping you can give me some insight or direction. Here is the situation. When i was updating security on one of our reports on Power BI on-Prem report server. I removed the Admin account on accident and now we have no way of accessing or edit/removing that report. Is there another way to see all the reports on the server and remove them if the Admin accounts are not tied to the report?Solved1.6KViews0likes2Comments