Forum Discussion
Data won't refresh
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.
- Are you sure you are downloading them to the same folder your Power BI report is pointing to?
- Is it local or a online SharePoint library?
- 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.
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.
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.- 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.
