I need help, I am trying to figure out how to deal with the missing file in Power query. Note: Inside the Current Year folder; Current_Year_Sales.csv file is available & Inside Previous Year folder; Previous_Year_Sales.csv file is available. I am following below steps in PQ: Step 1: I am using power query to extract data from two different folders. E.g., Current Year and Previous Year Step 2: Then Combining those two-query result E.g., CurrYear and PrevYear to generate a report by applying some transformation. Problem: Sometimes user does not supply one of the file i.e., either Current Year csv file or Previous Year csv file then the query is breaking and showing some error. Temporary Solution: User needs to store empty file to run the query. Can you help me how to handle this?
I provide 10 Advance Tableau Dashboards Training, if you want to join the live classes, contact me - abhishek.agarrwal@gmail.com
Also do videos on power bi dashboard please. Thank you.
Hello sire I created a poivote table in Qlik sense it has plus sign with each column dimention so how can I remove these pluse symbol
thanks
I need help, I am trying to figure out how to deal with the missing file in Power query.
Note: Inside the Current Year folder; Current_Year_Sales.csv file is available & Inside Previous Year folder; Previous_Year_Sales.csv file is available.
I am following below steps in PQ:
Step 1: I am using power query to extract data from two different folders. E.g., Current Year and Previous Year
Step 2: Then Combining those two-query result E.g., CurrYear and PrevYear to generate a report by applying some transformation.
Problem: Sometimes user does not supply one of the file i.e., either Current Year csv file or Previous Year csv file then the query is breaking and showing some error.
Temporary Solution: User needs to store empty file to run the query. Can you help me how to handle this?