Forum Discussion

andy808's avatar
andy808
Resolver I
10 months ago
Solved

Backend Error when publishing a composite model through the pipeline

I have a pbix that has a direct query and an import source. Publishing direct to Dev from desktop when connection strings are for Dev refreshes fine OR when I publishe direct to Test when strings are...
Need Help
  • andy808's avatar
    andy808
    9 months ago

    I ended up creating parameters in the pbix for each datasource for each environment. This allowed me to set the parameter in the Settings section after I promoted via pipeline but BEFORE before I applied the new parameters in the pipeline. This allowed me to set the parameters, apply them and then refresh.

v-prasare's avatar
v-prasare
Community Support
10 months ago

Hi andy808,

We would like to confirm if our community members answer resolves your query or if you need further help. If you still have any questions or need more support, please feel free to let us know. We are happy to help you.


anilgavhane, grazitti_sapna & lbendlin ,Thanks for your prompt response

 

 

Thank you for your patience and look forward to hearing from you.
Best Regards,
Prashanth Are
MS Fabric community support

andy808's avatar
andy808
Resolver I
10 months ago

Hi, checking in here to see if there is more quidance. It looks to be my lack of understanding on how to achieve STEP 2 in a GCC Premium Capacity. How do I do this when the data source is greyed out/not manually able to update: 

  • Backend Limitation: Power BI Premium does not support adding a new data source and refreshing the semantic model in the same transaction. This triggers the Premium_ASWL_Error.

How to Fix It

1. Split the Deployment into Two Steps

  • Step 1: Deploy the model from Dev to Test using the pipeline without triggering a refresh.
  • Step 2: After deployment, manually update the data source credentials in Test.
  • Step 3: Perform a separate refresh after the credentials are saved.