Forum Discussion
Super UserTemporary scheduled refresh fails after database update in Postgres
Hi zenisekd ,
Changes in data source table structure, or schema, such as a new, renamed, or removed column can only be applied in Power BI Desktop, and in the Power BI service they can cause the refresh to fail. For a quick reference on what they impact, refer to the following table.
For more details, you could read related document: Data refresh in Power BI - Power BI | Microsoft Learn
Best regards,
Community Support Team_Binbin Yu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
- zenisekd
Hi Anonymous,
I don't think your comment is touching my issue at all. The changes happen on the database side, but they don't influence the structure of my model created in desktop and published. In desktop I am carefully selecting the columns that I work with and remove the other columns (in which might be a change). If they changed the name of a column or perhaps the type of it, it would cause and error, which would be obvious and I would have to go to Desktop and adjust the queries.
BUT THIS IS NOT THE CASE. The error ( ErrorCode = 2147467259 or "The exception was raised by the IDbCommand interface") , the service is giving me, tells me nothing that I can grab on. All I have to do is wait and hope that the refresh will go through and ask for on-demand refresh. And eventually, it catches up, just like in the current case.
I am just frustrated that nobody is able to help. We have had this problem for over a year now.
Will anybody be able to help me?
