Forum Discussion

JamesLow's avatar
JamesLow
Frequent Visitor
5 years ago
Solved

Folder Data Refresh

Hi,   I have a dashboard that reads a csv file from a folder and will only read the most recent file within the folder. I have a new csv file with different columns and when i have now refreshed th...
Need Help
  • v-yingjl's avatar
    v-yingjl
    5 years ago

    Hi JamesLow ,

    When you load the latest file into power query, the number of colums has been wriiten into the function so that you can only see the new data when adding rows data. However, if you add new columns data into the file, you need to change the column number of the function in power query as you needed:

    Best Regards,
    Yingjie Li

    If this post helps then please consider Accept it as the solution to help the other members find it more quickly.

amitchandak's avatar
amitchandak
Super User
5 years ago

JamesLow , new column means new rows of data. And Dashboard means you are lloking at power service.

 

If there is an issue at power bi service. make sure the scheduler refresh is running there. Clear cache and check again.

 

If it is for the desktop . open Power query /transform data mode and check for any error

 

refer how to handle error in power query
https://www.youtube.com/watch?v=OE6DPmKqN7s
https://www.youtube.com/watch?v=9-Lag0VOiTs

debug issue
https://www.youtube.com/watch?v=OE6DPmKqN7s