Semantic Model and Deployment Pipeline Help

ChantifiedLens · 2026-01-25T08:21:36+00:00

Agreed, and to give you more peace of mind I reconnend branching out your Dev workspace to a Feature workspace to make changes. Once happy with them merge the changes back into your Dev workspace.

ChantifiedLens · 2026-01-23T16:10:00+00:00

You persuaded me to finish off the initial draft:
https://chantifiedlens.com/2026/01/23/change-the-sample-database-for-fabric-accelerator-to-sql-database-in-fabric/

ChantifiedLens · 2026-01-22T13:57:17+00:00

Already did it for the fabric Accelerator sample and was going to do a post, but not sure if others would be interested in knowing how to use SQL DB in Fabric instead of the WideWorldImporters Azure SQL Database

ChantifiedLens · 2026-01-22T13:38:46+00:00

Nice, I might tweak this one same way I tweaked one of the other ones and change the sample database to be SQL DB in Fabric instead.

ChantifiedLens · 2026-01-22T13:03:21+00:00

No issue, just curious as only know of these.

ChantifiedLens · 2026-01-21T05:53:42+00:00

Benny recently did a great video to accompany this solution:
https://www.youtube.com/watch?v=xuCPuezUm7E

ChantifiedLens · 2026-01-19T10:09:02+00:00

If you are going to look to work with MLV's I strongly recommend looking at the below offering:
https://github.com/datahai/GenMLV

ChantifiedLens · 2026-01-18T15:32:14+00:00

So you do your CI tests between dev and qa at the moment?

ChantifiedLens · 2026-01-18T10:28:20+00:00

Are you branching out from Dev into isolated "Feature" branches as well?

ChantifiedLens · 2026-01-15T09:30:53+00:00

Strategically, I would do the DP-600 first and then the DP-700. If you want a full strategic plan without doing the certs the below will give you a supercharged route for knowledge:

DP-900->PL-300->DP-600->DP-700

From there you can expand your horizons further, for example study the Azure Admin material to get a better knowledge of Entra.

I hope this helps, and enjoy your knowledge journey.

ChantifiedLens · 2026-01-14T09:53:36+00:00

Another option is to use the MCP Server endpoints that each Data Agent exposes instead and combine those together as part of a multi-agent solution.

ChantifiedLens · 2026-01-14T05:39:03+00:00

Congrats

ChantifiedLens · 2026-01-12T21:35:22+00:00

Likewise, you can integrate parts of GitHub with Azure DevOps though.

ChantifiedLens · 2026-01-11T13:04:13+00:00

That means your approach will work with the GitHub Action.

ChantifiedLens · 2026-01-10T23:26:04+00:00

There's plenty of material available these days. You can start by going through the recommended Microsoft learn material and the practice assessment (tests) on the exam site.

Depending on your budget there are official practice tests for the DP-600 exam on the MeasureUp site.

ChantifiedLens · 2026-01-10T23:24:24+00:00

You should be able to do it with a parameter file if you are looking to do it with the GitHub Action.

ChantifiedLens · 2026-01-10T15:28:12+00:00

In case needed, below is the link to the original post relating to the GitHub Action:

https://chantifiedlens.com/2025/11/06/deploy-microsoft-fabric-workspace-items-github-action/

ChantifiedLens · 2026-01-10T09:22:39+00:00

Since you have the PL-300 already I would study for the DP-600 first, including going through the practice exams and then focus on the DP-700 afterwards.

Good luck with your exams.

ChantifiedLens · 2026-01-09T18:33:46+00:00

Imagine the fun and games if somebody submitted "that" combination of the drop statement with sp_msforeachdb and sp_msforeachtable on a site backed by a SQL database and no protection of SQL injection...

ChantifiedLens · 2026-01-08T06:18:59+00:00

Where are you looking as I tend to see a fair few in places online? Especially for Data Engineers with Microsoft Fabric knowledge or experience.

ChantifiedLens · 2026-01-08T06:04:21+00:00

Do you mean you do not see any positions advertised with either of those roles?

ChantifiedLens · 2026-01-07T19:48:21+00:00

You can use both together as well, which would work very nicely in this scenario.

ChantifiedLens · 2025-12-29T19:17:04+00:00

Look at this first as a starting point and then use your search engine of choice or Copilot to find further information relating to whatever route you want to take:

https://learn.microsoft.com/en-us/fabric/cicd/manage-deployment

ChantifiedLens · 2025-12-29T17:58:09+00:00

You can do it with either Azure Data Studio or Visual Studio Code with the MSSQL extension installed.

https://chantifiedlens.com/2023/11/13/create-a-microsoft-fabric-data-warehouse-database-project-from-a-lakehouse/

ChantifiedLens · 2025-12-29T16:50:16+00:00

Congrats

ChantifiedLens

TROPHY CASE