Power Platform Community Forum Thread Details

We are loading data from SQL Server into a CDS entity. During the load, I would like to assign the 'Owning Business Unit' based on values that are included in the data being loaded. I've seen a number of articles on using Business Unit and Teams to control security, but none so far on assigning the values. Any guidance on how to assign the correct 'Owning Business Unit' at the time of data load?

Thanks in advance for help and guidance.

Categories:

Microsoft Dataverse with Power Apps

Hi @RStanley ,

How do you load your data from SQL Server to CDS Entity? Using Data Integration Project task?

Do you want to assign the 'Owning Business Unit' based on values that are included in the data being loaded?

Based on the needs that you mentioned, I suppose that you loaded your data from SQL Server to CDS Entity using Data Integration Project task, is it true?

If you want to assign the 'Owning Business Unit' dynamically based on values that are included in the data being loaded, i afraid that there is no way to achieve your needs in PowerApps currently.

If you would like this feature to be added in PowerApps, please submit an idea to PowerApps Ideas Forum:

https://powerusers.microsoft.com/t5/PowerApps-Ideas/idb-p/PowerAppsIdeas

If you just want to share the data from your SQL Table when importing into your CDS Entity, I think the Power Query functionality could achieve your needs. Please check and see if the following article would help in your scenario:

https://docs.microsoft.com/en-us/power-platform/admin/data-integrator#advanced-data-transformation-and-filtering