Refrsh Error

[Tevin]

Hi I am getting this error when refresh my power bi can anyone assist I have tried refreshing as well as reconnecting the datasource, keep in mind this error happens ocassionaly sometimes the report does refresh but if you upload it to the powerbi service then it throws an error like this:
Data source error: DataSource.Changed: PostgreSQL: The data source appears to have been modified since it was last accessed. Refreshing may resolve this error.. Microsoft.Data.Mashup.ErrorCode = 10649. DataSourceKind = PostgreSQL. DataSourcePath = pg-gateway.synatic.com;mcdatawarehouse-flat_objects-190b. ;PostgreSQL: The data source appears to have been modified since it was last accessed. Refreshing may resolve this error.. The exception was raised by the IDataReader interface. Please review the error message and provider documentation for further information and corrective action. Table: public global-flat--budget-full-set.
Cluster URI: WABI-WEST-EUROPE-B-PRIMARY-redirect.analysis.windows.net
Activity ID: d114e196-8817-471b-9146-26ea5e3ccb5e
Request ID: 855f9899-d477-46e3-9e5d-10efbc2bb376
Time: 2024-11-28 07:25:01Z

I go and check the table it's referring too but there is no error.

[Anonymous]

Thanks for rajendraongole1's concern about this issue.

Hi, @Tevin 

Have you had this error before?

Have you tried the methods provided by rajendraongole1 and do the methods provided by rajendraongole1 apply to your situation?

You need to make sure that the data source itself has not changed, as rajendraongole1 says, even seemingly minor changes can sometimes cause this error.

You can also try clearing the cache of Power BI Desktop. You can clear the cache by going to File > Options and Settings > Options > Data Load.

I hope my suggestions give you good ideas, if you have any more questions, please clarify in a follow-up reply.
Best Regards,
Fen Ling,
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[rajendraongole1]

Hi @Tevin - Verify if any changes were made to the PostgreSQL database schema (e.g., renamed tables, updated column names, or data types).Even seemingly minor changes, such as altering constraints or indices, can sometimes cause this error.

Use the "View Native Query" option in Power BI for the query associated with the problematic table. Check if the query executes without issues directly in a PostgreSQL client (like pgAdmin or DBeaver).If the dataset is large, consider implementing incremental refresh. This approach reduces the chances of conflicts during full refreshes by only updating newly modified rows.

Enable "Enable Parallel Loading of Tables" in Power BI Desktop (under Options > Current File > Data Load). This can sometimes handle metadata mismatches better.