Subscribe a report on last day of the month
Hello, i am currently working on paginated reports, one the reports need to be shared with users on the last day of the month as some months have 31 days some have 30 days, can it done by creating a single subscribtion or should i create two seperate subscribtions one for months with 30 days and other for months with 31days. Thanks and Regards
OData exception occurred: System.Net.WebException:The request failed with HTTP status 401.Unauthoriz
Hello Microsoft Support & community, After the installation of power bi report server (may 2023 version) the users are getting the error message "An error has occured. Try again later" on scheduling creation or modification on Power BI Report Server portal. (users have content manager profile on the directory where the reports are saved; they have also “system user” on security site parameters level) The error in the log RSPortal_2024_01_25… ==> 2024-01-25 11:10:45.7026|ERROR|19|OData exception occurred: System.Net.WebException: The request failed with HTTP status 401: Unauthorized. at Microsoft.SqlServer.ReportingServices2010.RSConnection2010.SetConnectionProtocol() at Microsoft.SqlServer.ReportingServices2010.RSConnection2010.SoapMethodWrapper`1.ExecuteMethod(Boolean setConnectionProtocol) at Microsoft.SqlServer.ReportingServices2010.RSConnection2010.SetCacheRefreshPlanProperties(String cachRefreshPlanId, String description[] parameters) at Microsoft.ReportServices.Portal.Services.SoapProxy.SoapRS2010Proxy.<>c__DisplayClass1_0.<ExecuteWithCorrespondingAuthMechanism>b__0()..... When adding a user to the local admin group on the server (BUILTIN\Administrators) creating or modifiying scheduling works as expected. But the point is, we don't want to make every report developer/author server admin.) Thank you for your help.
Trying to understand Power BI Server and SSRS.
Hi, I am new to Power BI and have been asked to look at he benefits of going with Power BI Server... From my initial readings, it seems the advantages are that we can brand the dashboard as our own, as well as host both our Power BI Dashboards and reports alongide our existing SSRS reports in a single web portal, with Power BI Server essentially superceeding SSRS? I have a few queries regarding the SSRS Reports. 1, Will Power BI Report Server essentially replace the need for our exisiting SSRS Report Home? Is it just a case of deploying our .rld reports and data sources to the BI Report Server? 2, Can we still maintain folder security for the report? 3, Can I still schedule (subscribe) the reports to run and email to users as and when we choose? 4, Can the reports to continue to run, via stored procedure calls to our SQL server database? I think I read that they must connect to a SSAS instance? Thanks in advnace for any thoughts. Mark
Schedule a data refresh
Hi, i would like to schedule a refresh of the data but through another scheduling software. I can see you can schedule a refresh but can't see an option to run via dos powershell command which will be the option here i think. Also i noticed You can also trigger a data refresh programmatically by using the Power BI REST API but just want to do it via DOS/ powershell or similar. Thanks.An error occured when creating a subscription
Hello, I try to create a subscriptions for either PBI report or SSRS Report and in both cases I receive an error when I click the Create subscription button. An error has occurred. An error occurred within the report server database. This may be due to a connection failure, timeout or low disk condition within the database. I am running this version Power BI Report Server © 2017 Microsoft Version 1.1.6582.41691 (October 2017)
