PowerBI Datamart error updating - Local Sql execution failed

[RichardBK]

Hi - I am getting the error below when tryning to update my datamart. The datamart consists of an Odata connection and seven queries off the back of those which I created in the Transform Data area of the datamart. There are no connections to any Sql servers, other than the one I assume is between the datamart and the underlying Sql server.

Any ideas as to what I might be doing wrong?

[RichardBK]

Just to follow up on this, I am now getting this error when I try to go back into the model. Not sure what I have done to break it?

[otravers]

Looks like something is broken between the datamart and its underlying SQL database. Are you able to access the datamart's Power Query section and refresh the queries in preview?

Also you might want to obfuscate your database's address in your screenshot.

[v-cazheng-msft]

Hi @RichardBK,

May I know what are the data sources except OData data source? Is the data you retrieving from these data source large? If you separately get data source these data sources, will you get problems?

Best Regards,

Community Support Team _ Caiyun

[anadar]

Hi Team,

Facing same issue, I am getting the data from Dataflow, Dataflow consists of SQL Tables and TableViews from Jira source database.

Any quick help / resolution for the same would help. Pls suggest.