Forum Discussion

fbittencourt's avatar
fbittencourt
Helper IV
4 months ago
Solved

Duplicating values from different environments ( dev. uat, prod)

Hi guys !!

 

 My datasource filters are duplicating the files from uat and dev when we filter

 

 

 

On the applied steps I have the following steps:

source - SharePoint.Files("https://XXXXXXXXXX/sites/Pilotagedelaperformance", [ApiVersion = 15])

= Table.SelectRows(Source, each Text.Contains([Folder Path], "DataSource"))

= Table.SelectRows(#"Filtered Rows", each Text.Contains([Name], "Feature_Cycle_Time_Q"))

 

my selection is ok

 when I check the folder path, shows both environments

 

https://xxxxxxxxxxxx/88-Power BI/UAT DataSource/FCT - JIRA/

https://xxxxxxxxxxxx/88-Power BI/UAT DataSource/FCT - JIRA/

 

whats the reason of this problem?

 

Thanks in advance

 

 

 

 

 

 

Need Help
  • danextian's avatar
    danextian
    4 months ago

    In addition to Deku , use DataSource not "DataSource". The one inside the double quotes is treated as a string literal not a parameter.

2 Replies

  • Deku's avatar
    Deku
    Super User
    4 months ago

    In this section you are looking for the folder path to contain the string "Data Source" and you are not passing the parameter

     

    Table.SelectRows(Source, each Text.Contains([Folder Path], "DataSource"))

     

    BTW the two folder paths you supplied are indentical but assume that is a typo

  • danextian's avatar
    danextian
    Super User
    4 months ago

    In addition to Deku , use DataSource not "DataSource". The one inside the double quotes is treated as a string literal not a parameter.