Data won't refresh

[ripstaur]

So, I have a report that I built in Desktop using what I thought was a link to some data in GitHub. At least, the first time I did it, it worked. I scheduled a refresh, and it says it refreshed successfully, but there are no data at all! 

As a result, I am building the same report out connecting to two .csv files. I got the report built, and when the next day's data came out, I downloaded the files and saved them in the same directory (a dropbox folder), using the same filenames. When I clicked the "refresh" button, however, the data stayed the same...the new day's data did not come in. What am I doing wrong? 

[edhans]

1. Are you sure you are downloading them to the same folder your Power BI report is pointing to?
2. Is it local or a online SharePoint library?
3. If local, are your gateway permissions set the same as other data sources in the file? (Private, Org, etc.)

I'd need to see the M code on how those connections are working to troubleshoot much more.

[ripstaur]

Thanks for the questions. I am sure I am downloading them to the same folder. As to whether it's local, that depends on your definition of local. It is not in a sharepoint library. It is in a dropbox folder. I have not touched any gateway permissions, so I have to think they would all be the same. If you could point me to how I can give you the M code, I'd be happy to get it and post it here. 

[edhans · Accepted solution]

Power Query doesn't access Dropbox at all @ripstaur so it must be "local" in that you have sync'd them to your machine. The gateway will have to be propery configured to allow that.

M code can be obtained from the advanced editor. The reverse of these instructions basically:

How to use M code provided in a blank query:
1) In Power Query, select New Source, then Blank Query
2) On the Home ribbon, select "Advanced Editor" button
3) Remove everything you see, then paste the M code I've given you in that box.
4) Press Done
5) See this article if you need help using this M code in your model.

[AllisonKennedy]

@ripstaur
Try following the instructions on this page:
https://docs.microsoft.com/en-us/power-bi/transform-model/desktop-query-overview#advanced-editor

To copy the code from the Advanced Editor in Power Query editor (note these instructions are slightly outdated, so you'll need to click 'Transform data' instead of 'edit queries' to find the Query Editor in Power BI). If you get stuck, just come back with more questions.