Forum Discussion

Kees's avatar
Kees
Helper I
2 years ago
Solved

Select datafile that changes monthly

Hi,   Although I found some some suggestion for my problem I could not find one that suits my need.   I have a XLSX datafile that I need in my PBI queries that changes monthly (Always in the same...
Need Help
Tips and Tricks
  • lbendlin's avatar
    lbendlin
    2 years ago
    let
Source = SharePoint.Contents("https://fakename.sharepoint.com/sites/fakefolder/", [ApiVersion = 15]),
#"Shared Documents" = Source{[Name="Shared Documents"]}[Content],
#"Filtered Rows" = Table.SelectRows(#"Shared Documents", each Text.StartsWith([Name], "Billing Cumulative"))
#"Imported Excel Workbook" = Excel.Workbook(#"Filtered Rows"{0}[Content]),

     

    I'm looking for a way to select the datafile starting with: Billing Cumulative_Raw Data.

    Your files don't start with that.  You have the region name in between.

lbendlin's avatar
lbendlin
Super User
2 years ago
let
Source = SharePoint.Contents("https://fakename.sharepoint.com/sites/fakefolder/", [ApiVersion = 15]),
#"Shared Documents" = Source{[Name="Shared Documents"]}[Content],
#"Filtered Rows" = Table.SelectRows(#"Shared Documents", each Text.StartsWith([Name], "Billing Cumulative"))
#"Imported Excel Workbook" = Excel.Workbook(#"Filtered Rows"{0}[Content]),

 

I'm looking for a way to select the datafile starting with: Billing Cumulative_Raw Data.

Your files don't start with that.  You have the region name in between.

Kees's avatar
Kees
Helper I
2 years ago

Got it working!

 

Thanks very much, making my day!

 

Brgds Kees