cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
whereismydata
Resolver II
Resolver II

What tool to use to enrich/map data

here is my case:
Given there are two tables [tableA] and [tableB]. [tableA] is automatically filled with data from an external system. [TableB] contains let’s say only two columns,

- [columnA] = PK from [TableA] and
- an empty column [columnB]

What I'm looking for is a way to provide an interface to an end user to insert values into [tableB] for each value of [columnA].

So, normally this would be done through a dedicated application, but since money is tight, I'm looking for a solution in the Microsoft 365 landscape.

Requirements:
- Active Directory integration for access control
- Direct DB access for end use is not allowed

Solutions I came up with:
- First, I thought about 'classic' Excel files. Creating an SSIS package that loads the data from [tableB] to an Excel file and puts the file on a fileshare. But honestly, I don't like data manipulation in Excel since things can get messy if the end user messes around with datatype or deletes rows etc.

- Another solution would be writeback to SSAS, but since we have only tabular enabled, and I want the data to be in [tableB], this is also not an option.

- Also, I thought about using PowerAutomate (aka Flow) and Sharepoint. My solution would include a flow that loads the data from [tableB] and puts it into a sharepoint list. Once an edit was made, an update or insert would be made through another flow.

- PowerAutomate/PowerApps. I know this is maybe the most elegant solution, but it is still not quite clear if we are allowed to use PowerApps in our enterprise.

- Will Master Data Services do the job?

What tools do you use or which solution do you have in place?

Thank you for your help!

0 REPLIES 0

Helpful resources

Announcements
PBI_User Group Leader_768x460.jpg

Manage your user group events

Check out the News & Announcements to learn more.

MBAS on Demand

2021 Release Wave 2 Plan

Power Platform release plan for the 2021 release wave 2 describes all new features releasing from October 2021 through March 2022.

Get Ready for Power BI Dev Camp

Microsoft named a Leader in The Forrester Wave

Microsoft received the highest score of any vendor in both the strategy and current offering categories.

R2 (Green) 768 x 460px.png

Microsoft Dynamics 365 & Power Platform User Professionals

DynamicsCon is a FREE, 4 half-day virtual learning experience for 11,000+ Microsoft Business Application users and professionals.