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.
Data refresh
Hello everyone, I don't understang why I can Auto refresh from my old laptop with an out of date gateway but when I configure a new gateway on my new laptop I can't refresh and I get this error. Erreur de source de données: {"error":{"code":"DM_GWPipeline_Gateway_MashupDataAccessError","pbi.error":{"code":"DM_GWPipeline_Gateway_MashupDataAccessError","parameters":{},"details":[{"code":"DM_ErrorDetailNameCode_UnderlyingErrorCode","detail":{"type":1,"value":"-2147467259"}},{"code":"DM_ErrorDetailNameCode_UnderlyingErrorMessage","detail":{"type":1,"value":"The table has no visible columns and cannot be queried."}},{"code":"DM_ErrorDetailNameCode_UnderlyingHResult","detail":{"type":1,"value":"-2147467259"}},{"code":"Microsoft.Data.Mashup.ValueError.Detail","detail":{"type":1,"value":"TRANSACTIONS_SOURCE"}},{"code":"Microsoft.Data.Mashup.ValueError.Reason","detail":{"type":1,"value":"DataSource.Error"}}],"exceptionCulprit":1}}} Table: TRANSACTIONS_SOURCE. URI du cluster: WABI-SOUTH-AFRICA-NORTH-A-PRIMARY-redirect.analysis.windows.net ID d'activité: a363e721-3106-4859-af5e-b509d5616914 ID de demande: 9d9541c3-feb7-9d68-8f57-32925c70e1ce Heure: 2023-07-27 16:26:19Z I ve already check the credentials and the different settings I'm desperate for some 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
