schedule
14 TopicsUnable To Schedule A Refresh If One Or More Data Sources Are A File
I have two data sources in a report. File SQL Since I have a File data source which can not schedule a refresh, the SQL data source is now also unable to schedule a refresh. This is a clear bug as the SQL data sources should still be allowed to use a schedule.Solved1.1KViews0likes3CommentsSchedule refresh failed with Table.Combine
Hi all, I have created a new table using the function =Table.Combine({BI_fact_aaa_deals, BI_fact_bbb}) The 2 tables are from the same datasource and they have the same fields. I don't want to do a union all in sql statment beacouse the original views are used also for other direct queries If I remove the refresh flag on power query table properties it works correctly but data into reports are not updates Can you help me,please? ThanksSolved900Views0likes1CommentPower BI Report Server - Scheduled refresh does not work
Hi there, We have a problem with PBIRS and its refresh schedule. All new assigned schedules don't work. In debug mode we see errors in RSPowerBI_*.log files: |DEBUG|67|Exception during db accessSystem.Data.SqlClient.SqlException (0x80131904): The INSERT statement conflicted with the FOREIGN KEY constraint "FK_SubscriptionHistory_Subscriptions". The conflict occurred in database "ReportServer", table "dbo.Subscriptions", column 'SubscriptionID'. The statement has been terminated. Any ideas to resolve? Thanks in advance.578Views0likes1CommentSchedule Refreshed Failed ("Invalid Credentials" but authentification are correct)
Hello all! We have some kind of strang behavior with schedules at our Report Server at the moment. Their are Schedules who cant refresh because the SQL-Source Credentials are invalid. If we check the connection string we dont get any error. We use an Service Account and sometimes with different Reports we get this message and cant understand why. We tried to replicate the error when we planned a schedule for the same time with the same account but it worked well. Can somebody explain this behaviour or knows any solution for it? Thank you so much for your help!542Views0likes0CommentsCustom App Visual - Monthly Calendar Schedule
Attached are some sketches below, Refer to the monthly calendar for January 2023. Looking at the first full week as example, this is my desired output for a custom app visual, but it will show the entire Month. You’ll notice that I have “0 hr” and “24 hr” on the left and right sides of the calendar week. Now my question is how can I fill each date “block” with color and text formatting based on START_TIME_DATE and END_TIME_DATE and the type of event (Hi-Lo, Alt2,...ect)? I'm just now tinkering with creating my own custom app visual portion of Power BI, so I have been reading about the "how to get started..." Any tips, tricks, tutorials, or documentation would be appreciated! Thank you in advance!Schedule, Gantt
Hi, I need some Help, I use Excel to create a schedule, like a Gantt Chart, Imagen: I use this formula to calculate de cells : =SE(MÍNIMO($AB$1-SOMA(AD$8:AD19),$Z20-SOMA($AB20:AC20))=0,"",MÍNIMO($AB$1-SOMA(AD$8:AD19),$Z20-SOMA($AB20:AC20))) SE = IF Mínimo = Min Soma = Sum I need to do the same schedule on power BI. I dont have StarDate and EndDate. it´s need to calculate a daily production of 15000 units, from the current day, when the 15000 closes, needs to switch to the next day with the balance of the previous day and count another 15000.1.3KViews0likes4CommentsProblems with schedule resfresh
Hi everyone! I have refresh schedule at my reports on PBIRS and it worked good, before I set the second report server instance for mobile server (I used this instruction Configure a Native Mode Report Server Scale-Out Deployment - SQL Server Reporting Services (SSRS) | Microsoft Learn) After that I faced a problem that my schedule started to go sometimes by my first server, and sometimes by my second report server, and if it go by the second, there are always errors on the moment of DataRefresh ItemAction I tried to follow this steps from Turn Reporting Services Features On or Off - SQL Server Reporting Services (SSRS) | Microsoft Learn And frankly speaking amout of Second(mobile) tries of refreshing became less, then it was, but not zero and i still can see them and thereafter errors in refresh schedule thanks in advance for helping614Views0likes0Commentsproblems with scheduling updates
Good afternoon. I have encountered such a problem that updating reports on a schedule causes such an error, despite the fact that manually clicking on the update, it turns out without problems. The data is taken from the PostgeSQL server with the help of conection to data gateway On-premises data getaway because i need VPN to have access to data. please tell me what the problem may be and how to fix it?878Views0likes1CommentSeveral errors occured during data refresh
I have tried to do everything I see in the post, but I can not solve [0] -1055784932: DataSource.Error: ODBC: SUCCESS_WITH_INFO [01004] Fetched item was truncated.. DataSourceKind = Odbc. DataSourcePath = database=XXXXXXXX;driver={PostgreSQL Unicode};dsn=Postgres;port=5432;server=XXXXXXX. OdbcErrors = #table({"SQLState", "NativeError", "Message"}, {}). . The exception was raised by the IDbCommand interface. i see report all, but cant refresh auto. any can help me please.Solved1.3KViews0likes1Comment