Forum Discussion

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

Power Bi recognizing changing date for a file daily

Hi, I have a csv that automatically updates itself daily with new data. The problem is in the code that was written it changes the name of the csv to the most current date. Is there a way I can get ...
Need Help
  • v-zhenbw-msft's avatar
    v-zhenbw-msft
    5 years ago

    Hi drivas771994 ,

     

    You need to connect a folder, please refer the following steps.

     

    1. Create a folder to put your file.

     

     

    2. Then open Power BI Desktop, select Get date -> folder to connect the folder you create. You need to select Combine and Transform data.

     

     

    3. We need to remove the first column.

     

     

    4. Now it will be updated according to the changes in your data.

    We change the file name and click the refresh,

     

     

     

    If you have any question, please kindly ask here and we will try to resolve it.

     

    Best regards,

     

    Community Support Team _ zhenbw

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

drivas771994's avatar
drivas771994
Icon for Helper II rankHelper II
6 years ago

So I did that method and then just changed the name of the file to 10-9 to test it and got this error still. It seems to make sense but power bi keeps creating a specific file path in my steps with the file name of 10-10. Can I get it to ignore the file name?

drivas771994's avatar
drivas771994
Icon for Helper II rankHelper II
5 years ago

I wanted to follow up and see if anyone can solve this

  • v-zhenbw-msft's avatar
    v-zhenbw-msft
    Icon for Community Support rankCommunity Support
    5 years ago

    Hi drivas771994 ,

     

    You need to connect a folder, please refer the following steps.

     

    1. Create a folder to put your file.

     

     

    2. Then open Power BI Desktop, select Get date -> folder to connect the folder you create. You need to select Combine and Transform data.

     

     

    3. We need to remove the first column.

     

     

    4. Now it will be updated according to the changes in your data.

    We change the file name and click the refresh,

     

     

     

    If you have any question, please kindly ask here and we will try to resolve it.

     

    Best regards,

     

    Community Support Team _ zhenbw

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

  • v-zhenbw-msft's avatar
    v-zhenbw-msft
    Icon for Community Support rankCommunity Support
    5 years ago

    Hi drivas771994 ,

     

    How about the result after you follow the suggestions mentioned in my original post?

    Could you please provide more details or expected result about it If it doesn't meet your requirement?

    If you've fixed the issue on your own please kindly share your solution. If the above posts help, please kindly mark it as a solution to help others find it more quickly.

     

    Best regards,

     

    Community Support Team _ zhenbw

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