Forum Discussion

RobertSlattery's avatar
RobertSlattery
Icon for Responsive Resident rankResponsive Resident
9 years ago
Solved

Evaluate my Data Model/Table Structure!

Expression.Evaluate environment breaks visual   I have a function that operates on tables with similar names, it works fine in the preview in the Edit Query window but throws an error in the visual...
Need Help
  • v-haibl-msft's avatar
    v-haibl-msft
    9 years ago

    RobertSlattery

     

    I’ve got response from the Product Team.

     

    This is effectively "by design" and will not be changed.

     

    Best Regards,
    Herbert

RobertSlattery's avatar
RobertSlattery
Icon for Responsive Resident rankResponsive Resident
9 years ago

Anonymous

 

Thank's Lydia, in case it helps, I took a deeper dive into the root cause of this here. 

v-haibl-msft's avatar
v-haibl-msft
Icon for Microsoft Employee rankMicrosoft Employee
9 years ago

RobertSlattery

 

I’ve got response from the Product Team.

 

This is effectively "by design" and will not be changed.

 

Best Regards,
Herbert

  • RobertSlattery's avatar
    RobertSlattery
    Icon for Responsive Resident rankResponsive Resident
    9 years ago

    Thanks Herbert, I think that iws a sensible design based on my notes above.

     

    If anyone is looking for a better way to do this I ended up using this pattern

     

                        file = Excel.Workbook(File.Contents(Text.Replace(baseName, "$", Text.From(_))), null, true),
                        MyTable = file{[Item="MyTable",Kind="Table"]}[Data]
     
    Where baseName is the full path to the similar files with "$" where the unique part needs to be.