User Profile

tcollett0

Frequent Visitor

Joined 1 year ago

3 Posts

View All Badges

User Widgets

Contributions

Re: Dataflow Gen2 - Getting source name
Here is the code: let Source = Dynamics365BusinessCentral.ApiContentsWithOptions("CityWide-UAT", null, null, [UseReadOnlyReplica = true, AcceptLanguage = null, Timeout = null, ODataMaxPageSize = null]), #"Navigation 1" = Source{[Name = "Central Kentucky"]}[Data], #"Navigation 2" = #"Added custom"{[Name = "WebServices"]}[Data], #"Navigation 3" = #"Navigation 2"{[Name = "CW_G_L_Entries", Signature = "table"]}[Data] in #"Navigation 3" I want to get the portion in red and add it as a column (each row will have that value in it).
1 year ago Place Data Engineering
1.7KViews
0likes
2Comments
Re: Dataflow Gen2 - Getting source name
Here is what I have. I am using Dataflow Gen2 so that I can get to the endpoints of a minimum of a dozen databases. Each of these databases are structurally the same, but they belong to different companies and therefore have to be isolated (this was the design before I got there). I go to database "Central Kentucky" and it gives me the list of companies above as the source and then you can see that the next level in Navigation 1 it starts breaking it down into only "Central Kentucky". As I go through Navigations 2 and 3, I have the records for "Central Kentucky", but I want to add "Central Kentucky" as a new location column. My goal was to find a way programmatically that I could copy the query and change the source name only and have the location as an additional column in any layer that I choose by adding a new column. Does that make sense?
1 year ago Place Data Engineering
1.8KViews
0likes
0Comments
Dataflow Gen2 - Getting source name
Now to Dataflow Gen2 and Power Query: I have a list of sources (individual databases in Business Central) and from there I want to pull data from each source (which I can do). Here is a sample list of the sources (shows up as my source): In the next step (Navigation 1), my data shows up and this is what it is using to get the data. However, I want to have the source name (Central Kentucky) also in the next applied step in the table and on each column. When I try to do this, I either get all the names from above. I would like to get this all the way down into the Navigation 3 step if possible. How do I do this programmatically? Basically I want my source name on each record at the most granular level possible in my data.
Solved
1 year ago Place Data Engineering
Data Engineering
Lakehouse
1.8KViews
0likes
8Comments

Data Privacy

Microsoft Fabric Community and Privacy

To learn more about how we manage your data, please review the Microsoft Fabric Community Data Privacy guide.