Forum Discussion

sstockda's avatar
sstockda
Regular Visitor
4 years ago
Solved

Incremental refresh on Datamart - Error

Hi,   I've configured a table in a Datamart to extact data from a PostgreSQL database via n On Prem Data Gateway. If I do a full load I can grab all the data which is abuot 1.7M rows - its a little...
Dataflow
  • v-yanjiang-msft's avatar
    v-yanjiang-msft
    4 years ago

    Hi Maximum_Attakk ,

    We have reproduced your issue and have submitted to internal icm 311746938 , engineers are doing their best to fix this issue . please be patient and I will give you feedback here once there is any progress.

    Best Regards,
    Community Support Team _ kalyj

sstockda's avatar
sstockda
Regular Visitor
4 years ago

Hi, 

 

I'm not connecting to a SQL Server database. As I said I'm connecting to a PostgreSQL database. My guess is that the SQL database the error is talking about is the SQL instance behind Datamart. 

 

Simon

v-yanjiang-msft's avatar
v-yanjiang-msft
Community Support
4 years ago

Hi sstockda ,

I think so, when you create a Power BI Datamart, Three objects behind the scene is created; A dataflow, an Azure SQL database, and a Dataset. Some of these components are exposed as individual components, but some are hidden.

In this blog, there're steps about how to see the SQL database in the datamart: Power BI Datamart Components 

Best Regards,
Community Support Team _ kalyj

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