Forum Discussion

jaideepnema's avatar
jaideepnema
Icon for Solution Sage rankSolution Sage
6 years ago
Solved

Unable to Publish Report with DirectQuery and Incremental Refresh with PostgreSQL as a Data Source

I am trying to publish a report  with incremental refresh enabled on one of the tables using import mode and also having another table using directquery as storage mode with PostgreSQL as a data sour...
Need Help
Show and Tell
  • jaideepnema's avatar
    jaideepnema
    5 years ago

    Here is the reply i received from the Microsoft Support Team

     

    We checked with our technical team and they confirmed Postgrey SQL direct query mode data and import mode with incremental refresh data pbix file is not possible to publish

Icey's avatar
Icey
Icon for Community Support rankCommunity Support
6 years ago

Hi jaideepnema ,

 

According to the errors, there is a restriction. Please try to use enhanced dataset metadata to see if the restriction can be removed.

 

If this doesn't work, it is suggested to create a support ticket to get further help.

 

 

Best Regards,

Icey

 

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