Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
Hi,
First, I hope the subject makes sense as a summary of this issue! I had some difficulty trying to summarize into a few words.
The issue: If you have two source paths in the same query to two separate paths or two separate files in the same path you can not edit the second path through the UI, but only through the Advanced Editor in Edit Queries.
Here is a sample query:
let
SourceFile1 = Excel.Workbook(File.Contents("C:\Scenario\Heights\Heights.xlsx"), null, true),
Heights_Table = SourceFile1 {[Item="Heights",Kind="Table"]}[Data],
SetInitTypeHeight = Table.TransformColumnTypes(Heights_Table,{{"Direction", type text}, {"Name", type text}}),
SourceFile2 = Excel.Workbook(File.Contents("C:\Scenario\Sides\Sides.xlsx"), null, true),
Sides_Table = SourceFile2{[Item="Sides",Kind="Table"]}[Data],
SetInitTypeSides = Table.TransformColumnTypes(Sides_Table,{{"Direction", type text}, {"Name", type text}}),
SourceHeights = SetInitTypeHeight,
SourceSides = SetInitTypeSides,
FinalDataSet = Table.Combine({SourceHeights, SourceSides})
in
FinalDataSet
This example is not quite as confusing as what happened to my end user. In the real life case there were two different paths showing, but when he edited the second one they compressed into one data source. We are getting the same data from the same path twice in the real query, but doing separate manipulations on the results and then merging them back together into one overall set of data. As you might expect this what quite confusing for my end user and he didn't know what to do to fix it.
We can work-around this issue, but I wanted to report it so someone can take a look and decide if it should be handled differently by the Data Source editor.
It may be unorthodox to have two or more datasources in one query, but it works great!!!
Thanks for looking into this issue...
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.