Forum Discussion

miner182's avatar
miner182
Regular Visitor
2 years ago
Solved

Data Project publish into Azure Warehouse (_rsc schema problem)

Hi, I am trying to publish (from Azure Data Studio) a simple project (containing only 1 table) into Warehouse in Azure Fabric. But I am getting this error: "Deploy dacpac: Could not deploy package. ...
warehouse
  • AndyDDC's avatar
    AndyDDC
    2 years ago

    HI miner182 this issue is currently with MS as it has been raised previously.  In the meantime and something that I do, is add the _rsc and queryinsights schema to your project.  Easy to do with the schema compare.  This then means you don't have to disable the "drop objects not in source".  

     

     

     

     

Anonymous's avatar
Anonymous
Not applicable
2 years ago

HI miner182,

I think these operations does not have the permissions to directly modify or delete the existing contents during publish steps. So these operations can work when you turn off the option "drop objects not in source".

In my opinion, I think these data shaping and cleaning operation can be processed on the fabric warehouse instead of directly executed in the publish steps.

Regards,

Xiaoxin Sheng