After a scheduled refresh the report has no data
After updating to October release of Power BI Report Server we were very excited to be able to upload reports used with imported data from SQL Server directly. When we refresh the report with latest data in desktop then upload to the report server it renders fine and all is well. I then setup the scheduled refresh, after the scheduled refresh happens all the data becomes blank. The outline of the report is there but no data is visible. I then use the desktop edit the report and the data shows, I refresh on the desktop and save it to the report server and the data is visible again. In the logs is shows the report is being refreshed successfully. 2017-11-28 02:00:01.9115|INFO|222|Processing Data Model Refresh: SessionId: 16766b77-0766-454a-9a77-109fbb2e66c3, Status: Starting Data Refresh. 2017-11-28 02:00:01.9428|INFO|222|Processing Data Model Refresh: SessionId: 16766b77-0766-454a-9a77-109fbb2e66c3, Status: Starting Retrieving PBIX AsDatabaseInfo. 2017-11-28 02:00:01.9740|INFO|222|Processing Data Model Refresh: SessionId: 16766b77-0766-454a-9a77-109fbb2e66c3, Status: Starting Verifying all the data sources are embedded. 2017-11-28 02:00:01.9896|INFO|222|Processing Data Model Refresh: SessionId: 16766b77-0766-454a-9a77-109fbb2e66c3, Status: Starting Verifying connection strings are valid. 2017-11-28 02:00:02.0521|INFO|222|Processing Data Model Refresh: SessionId: 16766b77-0766-454a-9a77-109fbb2e66c3, Status: Starting Streaming model to Analysis Server. 2017-11-28 02:00:05.9583|INFO|222|Processing Data Model Refresh: SessionId: 16766b77-0766-454a-9a77-109fbb2e66c3, Status: Starting Refreshing the model. 2017-11-28 02:00:22.4579|INFO|222|Processing Data Model Refresh: SessionId: 16766b77-0766-454a-9a77-109fbb2e66c3, Status: Starting Removing credentials from the model. 2017-11-28 02:00:22.7704|INFO|222|Processing Data Model Refresh: SessionId: 16766b77-0766-454a-9a77-109fbb2e66c3, Status: Starting Saving model to the catalog. What am I doing wrong? Would appreciate any help.
Report Date/Time is changing on scheduled
Hello, I currently have a Power BI Report that is displaying data from a MySQL Server. I have a daily scheduled refresh that occurs at 11:00 PM daily. I have noticed that after the scheduled refresh, the report date/time has been changing. However, when I select the option to Edit in Power BI Desktop, the report opens and display the correct Date/Time information. I have tried recreating the report to see if there was an error with my table setting, but date/time is still changing. I have attached two images. The one on the left reflects the correct date/time, and the one on the right reflects the date/time displayed after the scheduled refresh. Any advice would be greatly appreciated. Thank you
Error while scheduling refresh for reports on Power BI report server
While trying to schedule a refresh for any report on my report server, the following error is returned (Screenshot attached). All data source verifications are sucessfull and the report is manually refreshed without errors. The older schedules are working perfectly but I am unable to schedule a new one. Please help
Scheduled refresh failure across reports
Hi, I have got data refresh scheduled for many reports on the on-premise report server. Different reports fail on each refresh cycle with error message as one of the below. On manual refresh without any change, it runs fine on the first or second try. Please assist.Scheduled refresh of SQL source but with R script transformstions
Hello. I am exploring using PBIRS as the server to host Power BI reports, which will extract/source data from a SQL Server Database, and which will subsequently use R scripts to transform the data in various ways. Per the link below, as far as I understand R scripts themselves are not a source which can have PBIRS scheduled refreshes applied to them. As such, I'm wondering the following: 1.) Is there a way to work around this so that I can in fact schedule refreshes of a single R script which will hold the code for the entire ETL, 2.) If SQL Server Database is the source and transformations are applied using R scripts, does scheduled refresh work in this scenario? https://docs.microsoft.com/en-us/power-bi/report-server/data-sources#list-of-supported-authentication-methods-for-model-refresh
Data refresh takes too long
Hello, we have installed and running Power BI Report server for several month. Actually running the very last version: Version 1.2.6690.34729 (March 2018). We are facing with refresh issues. Sometimes the scheduled refresh takes too long (more than hour) and crash on timeout: "Message":"Timeout expired. The timeout period elapsed prior to completion of the operation.. The exception was raised by the IDbCommand interface. On other times the same report it's running smoothly and data refresh takes about 20 seconds. PBIX report on server has been not modified, the ammout of data to be refresh are the same and manual refresh in Power BI desktop do not takes longer that 30 seconds. Any idea why the refresh of the data can have such kind of strange behaviour? Thanks. Marian
