Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

The ultimate Microsoft Fabric, Power BI, Azure AI & SQL learning event! Join us in Las Vegas from March 26-28, 2024. Use code MSCUST for a $100 discount. Register Now

Reply
gerotutu
New Member

How to skip the processing of a file when datasource.notfound in Power Query?

Power Query takes from a cell the path it should go for the source files.

I want to handle the situation when there are no files in that folder or when there isn't any text in the cell referring to the path. The goal is to skip the following steps (or maybe to cheat the next steps with an empty table).

I tried, among many things, the functions try... otherwise without any success.

This is how my code starts:

let
DataAcesPath = Excel.CurrentWorkbook(){[Name="DataAcesPath"]}[Content][Column1]{0},
Origen = Folder.Files(DataAcesPath) ,
#"Archivos ocultos filtrados1" = Table.SelectRows(Origen, each [Attributes]?[Hidden]? <> true),

 

Could you please help me out with this? 


Many many thanks for your support,
Geronimo

3 REPLIES 3
gerotutu
New Member

Thanks @lbendlin

 

Would you teach me how to do it?

 

I've been trying several ways, but I cannot find the way to write in the code, "if the folder is empty, use this empty table"

 

Cheers

Folder.Files() produces a lot of columns. Which of these do you need in the next steps?

 

Read about #table()

lbendlin
Super User
Super User

(or maybe to cheat the next steps with an empty table)

Sounds like the most robust option.

Helpful resources

Announcements
Fabric Community Conference

Microsoft Fabric Community Conference

Join us at our first-ever Microsoft Fabric Community Conference, March 26-28, 2024 in Las Vegas with 100+ sessions by community experts and Microsoft engineering.

February 2024 Update Carousel

Power BI Monthly Update - February 2024

Check out the February 2024 Power BI update to learn about new features.

Fabric Career Hub

Microsoft Fabric Career Hub

Explore career paths and learn resources in Fabric.

Fabric Partner Community

Microsoft Fabric Partner Community

Engage with the Fabric engineering team, hear of product updates, business opportunities, and resources in the Fabric Partner Community.

Top Solution Authors
Top Kudoed Authors