topic Software development process for power query and dax in Developer

Software development process for power query and dax

jaryszek — Fri, 28 Mar 2025 09:56:22 GMT

Hi Guys,

I am coming from software engineering background, and thinking how can i make unit tests for DAX and power query ?

It is possible with power bi?
What tools I can use?

Scenarios:
1) Imagine that somebody is creating new power query to connect to postgres database tables.
How to make a unit test to check connections?
2) Another power bi report developer wants to get all DAXes connected to specific data source table and change some of them.
How the process should be look like ?
3) I want to add new DAX but besure that I can test it before publishing into report. How to do this?

Best,
Jacek

Re: Software development process for power query and dax

lbendlin — Fri, 28 Mar 2025 15:49:30 GMT

look into Deployment Pipelines, Version Control options (which are limited) and API based CI/CD.

Re: Software development process for power query and dax

jaryszek — Mon, 31 Mar 2025 07:19:26 GMT

Thanks for the clue!

Re: Software development process for power query and dax

Anonymous — Wed, 02 Apr 2025 12:05:07 GMT

Hi @jaryszek,

Thanks @lbendlin for Addressing the issue.

we would like to follow up to see if the solution provided by the super user resolved your issue. Please let us know if you need any further assistance.
If our super user response resolved your issue, please mark it as "Accept as solution" and click "Yes" if you found it helpful.

Regards,
Vinay Pabbu

Re: Software development process for power query and dax

Anonymous — Mon, 07 Apr 2025 11:49:59 GMT

Hi @jaryszek,

May I ask if you have gotten this issue resolved?

If it is solved, please mark the helpful reply or share your solution and accept it as solution, it will be helpful for other members of the community who have similar problems as yours to solve it faster.

Regards,
Vinay Pabbu

Re: Software development process for power query and dax

Anonymous — Fri, 11 Apr 2025 13:33:06 GMT

Hi @jaryszek,

Regards,
Vinay Pabbu