Dataset not refreshing when using Power Bi Datamart as data source for power bi dataset

[Niel_79]

Hello Everyone, 

I have a dataset in power bi service thats using power bi datamart as data source and I have been getting below error whenever i try to refresh the dataset:
After the last "}}" we have the table name thats coming from datamart.

has anyone else gotten this type of error, i would really appreciate if some one can help me understand the issue here?

[collinq]

Hey @Niel_79 ,

The first thing is to confirm that your gateway is updated to the latest version (On-premises data gateway April 2023 release | Microsoft Power BI Blog | Microsoft Power BI)  .

Also - if the connection is ODBC or other type that needs special drivers, are those drivers installed on your gateway?

Also - the error message indicates that you may have parameters as well?  Are you using incremental with Start and End date?