[GetCatalogExtendedContentData] procedure killing server
Hello there, Im running on-premise PowerBI Report Server on MS-SQL Server and after some time the reports on server become unavailable to users. My monitoring shows that this is caused by resource wait type ASYNC_NETWORK_IO (orange line) and associated stored procedure [dbo].[GetCatalogExtendedContentData]: I assume this procedure is called by server itself, but user action such as report refresh might be calling it. From query I understand what it does, but since values in database are hashed I don't know the purpose of it. Can anyone describe me when and how is this procedure called, so I can find the problematic report / user action causing the problem? Or if there is any documentation regarding these SP, I would welcome it as well.
Power BI Report Server Telemetry
Dear all, I'd like to share information about disabling Power BI Report Server Telemetrie with you. You may have already expected that sometimes you receive a message when opeing Reports WebSite where opening a site at "az416426.vo.msecnd.net". So I've spend some time to get a deaper look in this topic. After I check Telemetrie Settings within API via PowerShell: For deaktivation you need to navigate into Windows Regitry and edit two entries. After changing CustomerFeedback and ErrorReport from "1" to "0" for disable I ran PowerShell again. After changing Regitry setting API request looks different. After that I did several runs of Internet Explorer with Developer Tools ans request about "az416426.vo.msecnd.net" didn't occur so far. Another thing I've expected was, that this only occurs when your systme has an active connection to Internet. When I disconnet my test system from Internet, request wasn't performed. Another thing I've expected was, that when you perform an upgrade you need to re-check registry entries. After upgrading Report Server from 2018-08 to 2019-05 entries were readded to registry. Therefore you should add checking registry to your upgrade tasklist to keep it disabled. Hope you find this helpfull. Best regards DanielDisable/Prevent/Restrict/Block publish to cloud service for Power BI Report Server implementations
Our organization has implemented Power BI on-premise using Power BI Report Server (SA), however we have run into a key blocking issue which is currently preventing us from going live across our organization. Due to our company’s policies, we need to block our users from being able to publish to the cloud service. We only want our users to publish to the on-premise PBI Report Server. However, the licensing model for an on-premise implementation requires that ‘publishers’ (users who want to publish to the on-premise Power BI Report Server) must have a Power BI Pro license. We have procured PBI Pro licenses for our publishers, however this license also enables them to publish to the cloud service as well without any restrictions or controls. For our organization, this is considered a significant risk and we need to disable cloud publishing. Disablement of cloud publishing would seem to go hand-in-hand with an on-premise implementation utilizing Power BI Report Server since most organizations are choosing this implementation route to avoid storing their data in the cloud. This is further complicated since we are a U.S. subsidiary of a global enterprise in which the O365/Power BI cloud region has been set to store our data in the E.U. We are looking for help and guidance for how to configure our Power BI on-premise implementation and/or PBI cloud service to disallow our users the ability to publish to the cloud service; which is administered by our parent and utilized by multiple subsidiaries. We have spent much time researching and applying various configurations without success.Power BI Report Server - Get number of User Sessions/ Report Views/ Frequency of Usage for a Report
Hi, As I can see, there is no specific field that tracks User Sessions on Power BI Report Server. There is no log out option for the user on the web-portal either. Similarly, I found the logs very confusing and I m not sure if the approach taken to count total number of Report Views is Correct. I m inferring count of distinct execution ids where ItemAction != "SaveToCatalog" and != "DataRefresh" from ExecutionLog3 as total number of Report Views. Is this correct? I intend to track the frequency of access to a report by users and track the total number of views by each user. Is there a way I can get the total number of user sessions and frequency of usage. Thanks & regards, MannuHow to license splitting Power BI report server
Hi, We current have a single server SQL Server Enterprise Edition running SQL Server, SSAS and PowerBI in a 2 server AG cluster. The business wants to start moving reports from a different system to reporting services, so its not going to be feasible to continue running everything on a single server. My understanding is that if I split the PowerBI Report Server to its own server, it will mean we will need another Enterprise Edition license for the server. We do not want any cloud functionality so I believe the other licensing option is not the way to go. Would it be feasible to split the SQLServer service into its own server using the SQL Server Standard Edition instead, and having it in an AG cluster. Then Power BI and SSAS services will run on the existing Enterprise license on a separate AG cluster. Does this make sense? Apologies if I am using the wrong terminology, hopefully I am still able to convey what I am trying to do. TLDR Running a single server with SSIS, SSAS, SSRS & Power BI. Need to split things up accomodate increased usage, need advise on most cost effective and effective way to achive this. If things go well, may require additional report servers so scale out needs to be taken into account. Any advise would be appreciated. Thanks
Report Server: How to publish a report to the internet?
Hello all, d_gosbell Currently I am using Power BI Report Server (September 2021) - which is the on-premise version of Power BI. I used Power BI Desktop - Optimized for report server to save my report. I can view it on the Report Server Web Portal at the moment. How do I publish my report on the Power BI Report Server to the internet? Can someone please send a step by step guide on how to acheive this? Kindly require support on the matter. Thanks in advance!
Login credentials not working on published report
Hi, I have a report with a data connection to the Power BI API data (https://<ReportServer>/Reports/api/v2.0). The report works fine when saved in a local folder and refreshed. But when it is published on the on-premise report server, I am unable to get through the authentication. By default, "Anonymous" is selected, and that fails. The local folder version uses the logged in Windows users credentials, but the same Windows credentials fail for "Windows Authentication". I don't have values for the other authentication types. Please advise on how to solve the access issue. Regards, Mohan
PBIRS schedule refresh fails
I created the power BI report using import model and publishee to PBIRS. The report runs fine manually. But schedule refresh fails. SessionID: e004aceb-c4cb-4aff-b89c-84545b4a3117 [0] -1055784932: Credentials are required to connect to the AnalysisServices source. The exception was raised by the IDbCommand interface. [1] -1055784932: The command has been canceled.. The exception was raised by the IDbCommand interface. [2] -1055784932: The command has been canceled.. The exception was raised by the IDbCommand interface. It has two data sources 1. Analysis services and 2. Excel file (which is placed on the shared network) I am using windows credentials to connect to both the data sources. and connected successfully and when run manually data is populated. Thanks in Advance!
