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
How to add the Last Date Time refresh with two simple DAX functions
Hi all - I have figured out a way to add the automatic Last Date-Time Refresh to local timezone with two simple and straight-forward DAX functions that I'd like to share with you. If you have tried to set-up the local time on desktop version but the dashboard always reflects the GTW time whenever auto-refresh occured, it's because the Last Date-Time refers to the last refresh of Power BI server based on GTW. You can follow step by step below and it will work flawlessly no matter which local timezone you are. Create a custom column as UTC time.I use a Brand logo table to create a custom column since the data table is very small. If you pull data from direct source, you should create a new table and custom column by New Source/Blank Query. Why UTC? Because there is no time difference between GWT and UTC. However, GWT is a timezone while UTC is a timestandard. Click here for more details. DAX= Table.AddColumn(#"Renamed Columns", "Last Refresh Date Time", each DateTimeZone.FixedUtcNow(), type datetimezone) Add one more custom column by DAX switch zone function: I switch from UTC timezone to my local PST timezone by -7 hours. If your local time is different more than PST, you can adjust -/+ hours based on the difference time between UTC and your local timezone. You also add more other timezone by repeating this step 2. DAX= Table.AddColumn(#"Added Custom", "PST", each DateTimeZone.SwitchZone([Last Refresh Date Time], -7), type datetimezone) Use the PST column for the Last Refresh DateTime. This will work on the app as well.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)
