Trying to get incremental refresh to work but getting error upon publishing

[olimilo]

I'm trying to get incremental refresh to work on our dashboard but I keep running to the error upon publishing it. Archived data is only 1 year and data to be refreshed is 1 day. Data source is a SQL DB that we have configured in a gateway.

Upon checking the error, it says 'Invalid object name TABLE' which is not right because the table does exist and the refresh completes without issues when run from the desktop app.

This is the error I'm getting:

{"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":"Microsoft SQL: Invalid object name 'TABLE'."}},{"code":"DM_ErrorDetailNameCode_UnderlyingHResult","detail":{"type":1,"value":"-2147467259"}},{"code":"Microsoft.Data.Mashup.ValueError.Class","detail":{"type":1,"value":"16"}},{"code":"Microsoft.Data.Mashup.ValueError.DataSourceKind","detail":{"type":1,"value":"SQL"}},{"code":"Microsoft.Data.Mashup.ValueError.DataSourcePath","detail":{"type":1,"value":"DATASOURCE;DATABASE"}},{"code":"Microsoft.Data.Mashup.ValueError.ErrorCode","detail":{"type":1,"value":"-2146232060"}},{"code":"Microsoft.Data.Mashup.ValueError.Message","detail":{"type":1,"value":"Invalid object name 'TABLE'."}},{"code":"Microsoft.Data.Mashup.ValueError.Number","detail":{"type":1,"value":"208"}},{"code":"Microsoft.Data.Mashup.ValueError.Reason","detail":{"type":1,"value":"DataSource.Error"}},{"code":"Microsoft.Data.Mashup.ValueError.State","detail":{"type":1,"value":"1"}}],"exceptionCulprit":1}}}

Does anyone know what is wrong here or is there any way I can troubleshoot this further?

[v-rongtiep-msft · Accepted solution]

Hi @olimilo ,

Please have a check.

Ensure that the table name and schema are correctly specified in your Power BI queries. Sometimes, differences in case sensitivity between SQL Server and Power BI or missing schema information can lead to such errors. It's also a good idea to verify that the table name in the Power BI Desktop matches exactly with what's in the SQL Database, including the correct casing.

Verify that the gateway is correctly configured and pointing to the correct SQL database and table. Sometimes, the issue might be with the gateway not being up-to-date or not properly linked to the correct data source. Ensure that the data source settings in the gateway match those in Power BI Desktop.

More details: Troubleshoot incremental refresh and real-time data in Power BI - Power BI | Microsoft Learn

Configure incremental refresh and real-time data for Power BI semantic models - Power BI | Microsoft...

How to Get Your Question Answered Quickly - Microsoft Fabric Community

If it does not help, please provide more details.

Best Regards
Community Support Team _ Rongtie

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[PijushRoy]

Hi @olimilo 

Is there any data/column for State?
If yes, can you please check any data error or parameter error in State

Let me know if that works for you

If your requirement is solved, please mark THIS ANSWER as SOLUTION ✔️ and help other users find the solution quickly. Please hit the Thumbs Up 👍 button if this comment helps you.

Thanks
Pijush
Linkedin