Forum Discussion
Append two tables using left antijoin
workmonitored as a rule of thumb and best practice, do transformation/data preparation as upstream as possible, and as close to the source.
if you can do this in an SQL server then better to do it there so that it can be used for other reports/projects as well instead of doing it in Power BI.
Hope this helps.
workmonitored anhow you have both the solution, should be easy to test without too much efforts, not sure what else to tell. Thanks!
Thank you. Is there a recommended programming language for integrating SQL Server with a rest api endpoint ?
Hi workmonitored ,
You can integrate SQL Server with a Rest API endpoint through C#.Please check the links below.
Calling REST API Service From SQL Server Using C# SQL CLR
Best Regards,
Dengliang Li
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.