Forum Discussion

jglasgow's avatar
jglasgow
Frequent Visitor
6 years ago

Dataset Auto Update (Onedrive Business > Power BI Dataset)

Hello,

 

I have seen many topics similar to my situation but can't seem to find a solution so I apologize in advance if this has been covered.   

 

I have a report/app that gets updated daily.   The .csv files are refreshed to a folder on Onedrive automatically at 2am.  These files all load to one dataset for my reports/app.   Every morning I come in and click refresh in power bi desktop, then click publish.    I feel like I'm halfway there...I have the files updating every day to onedrive, but can't get the dataset to update automatically.   

 

  1. This can't be a personal gateway due to workflow (but that did function properly)
  2. I have the .pbix file also saved in the onedrive folder
  3. I tried using microsoft flow and that worked for a little while but then stopped
    • is this possibly because it's multiple files loading to one dataset?

There must be a way to have the dataset pull the data from onedrive daily but still allow me to work on and update the file with power bi desktop occasionally.   

 

Any help with this appreciated!

 

Thank you

 

JG

 

 

2 Replies

    • mwegener's avatar
      mwegener
      Icon for Most Valuable Professional rankMost Valuable Professional

      Hi jglasgow ,


      is your problem solved?
      If I answered your question, please mark my post as solution, this will also help others.
      Please give Kudos for support.