Forum Discussion

martaredondo's avatar
martaredondo
Icon for Helper II rankHelper II
6 years ago
Solved

If statement when importing excel

Hey all,

 

I have an Excel file that I need to import to Power BI once a week. The problem is that sometimes a specific sheet exists, sometimes it doesn't.

 

Is there a way to do an if statement when importing the sheet? Something like IF "SheetName" doesn't exist THEN do nothing/put only headers. I'm getting constant errors because in certain weeks Power BI can't find the sheet.

 

Thanks for you help,

Marta

 

Need Help

5 Replies

  • parry2k's avatar
    parry2k
    Icon for Super User rankSuper User
    6 years ago

    martaredondo not sure how you are importing the excel file, are you reading file from a folder or what? Can you share M code?

    • martaredondo's avatar
      martaredondo
      Icon for Helper II rankHelper II
      6 years ago

      parry2k i'm reading the excel from sharepoint online, basic import.

       

      The problem is the number of sheets in that excel is not fixed. It is an extraction from a tool our company uses and if there is no data asssociated to that export the sheet "disapears".

       

      Imagine I have 2 sheets "Orders from Client A" and "Orders from Client B", if in that week I have no orders from client B the only sheet in my excel is "Orders from Client A". This is why I need to have a verification like IF "Orders fro Client B" do not exist THEN do nothing/put table in blank