I am also experiencing inconsistent report refresh both when uploading a changed Desktop file and when using the REST API to add rows. The dashboard tiles seem to update in real-time but often report charts do not even when I navigate away and come back...
Could you please verify that you are not dealing with caching issues? I have seen this behaviour before, but every time I hit F5, the page reloaded and the chagnes where there. Without page refresh, clicking around would just bring cached/old version of the report.
I believe the issue is that the dataset (connection to Azure SQL database) published by Power BI Desktop are does not support refresh, I get the message below when I click on the 'schedule refresh' on the dataset
|Time:||Wed Jul 29 2015 11:03:29 GMT+1200 (New Zealand Standard Time)|
But if I upload the same pbix via 'Get Data' from powerbi.com then schedule refresh setting are available.
"You cannot schedule refresh...." when publishing directly from the desktop is a known issue. This is fixed and in the process of rolling out to the production system after going through the quality gates. Until then, if you need to schedule refresh, then the workaround is to upload the same pbix via 'Get Data' as you mentioned.
Was this issue fixed? I am having this issue currently.
I have a desktop pbix file that gets data from DYnamics Online. Once in PowerBI, the refresh is saying that my personal gateway is offline, but it shouldn't require it. right?
If it only contains Dynamics CRM online, then it should not require gateway. Could you check your pbix and see if there are any unused queries in the file connecting to other sources.