how long does it take for the Reports located in OneDrive to be updated on app.powerbi.com

[Cyrilbrd]

Considering a set of pbix files located on OneDrive and uploaded on app.powerbi.com.

So far the tiles load correctly and all pages are present.

I assumed that the 'refresh' button located in the submenu of the DATASETS would 'refresh' said data, but in fact such just 'crashed' the system, with the apparition of a small yellow triangle with an exclamation point giving the following message:

Oops, something went wrong.

An error occurred while processing the data in the dataset.

Processing ErrorThe credential stored in the cloud is missing.

Cluster URIWABI-SOUTH-EAST-ASIA-redirect.analysis.windows.net

Activity Id4c6e0507-dfdc-4acb-9852-15d31d2f5db2

Request Idbbd9ab12-49ce-4214-c629-d88411f224f9

Time2015-09-02 07:43:12Z

What one should do to ensure that app.powerbi.com reads data from OneDrive on a regular basis?

What would be such basis?

Is there a setiing for such?

Thanks for any feedback.

[Seth_C_Bauer]

This appears to fall under this scenerio from the support page for troubleshooting personal gateways found here.

Error: The credential stored in the cloud is missing.
You could get this error in Settings for <dataset> if you have a scheduled refresh and then uninstalled and re-installed the Personal Gateway. When you uninstall a Personal Gateway, data source credentials for a dataset that has been configured for refresh are removed from the Power BI service.
Solution: In Power BI, go to the refresh settings for a dataset. In Manage Data Sources, for any data source with an error, click Edit credentials and sign in to the data source again.

[konstantinos]

Notice that refreshing from OneDrive and refreshing data sources are different things....The pbix file will updated around every hour..That means that the data model changes / report changes will be upload ( with some limitations ) plus the data that are stored in pbix file..But the actual data sources won't be updated every hour - need to scedule a refresh in the browser, enter source credentials etc..and the data sources needs to be supported for refresh..

[Cyrilbrd]

@Seth_C_Bauer would this apply to free account? Gateway is a feature available for pro account only I believe.

@konstantinos every hour, noted. Here again to your knowledge would this feature be available to free version? Scheduled Refresh might be a pro feature?

[Seth_C_Bauer]

@Cyrilbrd nope, - you are correct, you can't use personal gateway with free account.

[ashishrj]

@Cyrilbrd You can schedule refresh daily or weekly for a free user. 

[Cyrilbrd]

@ashishrj I am not sure if I can find this feature.

This is what i get whenever I try to schedule such refresh:

[ashishrj]

@Cyrilbrd On-premise data sources can be refreshed using Data Management Gateway (DMG). To install and use the same, you need to be a Power BI Pro User. You can only refresh supported online data sources for refresh using a free user. You can try out 60 Days Power BI Pro trial account and install DMG and schedule the same

[Cyrilbrd]

@ashishrj what happens after 60 days? hence would the procedure remain active or would it disappear after trial period?

I am not clear about this sentence:

"...You can only refresh supported online data sources for refresh using a free user..."

[ashishrj]

@Cyrilbrd Definitely it will disappear and services will stop running after trial period.

Data refresh for free users are supported for PBIX and Excel files for online data source as given here. On-prem data sources needs DMG and hence Pro user. Hope things are clear!

[SnoJa10]

What if my data sources contain both online (supported by free users) and on-premise sources, BUT I only want to schedule the free online source for refresh?

[Cyrilbrd]

@SnoJa10 as mentioned by @konstantinos refresh is not an option for free users (maybe said option should be greyed out for non PRO users?), refresh is done automatically by system apparently once daily although I have seen it, I am unable to identify the trigger. Further based on trials it seems that data coming from OneDrive do update too but on a more regular basis (although here again not dynamically and not instantly).

Still the free version offers updates...

[konstantinos]

Up to now the PowerBI recognises the data sources and won't let you schedule refresh for any source.."...contains on premises data.." etc

[Cyrilbrd]

@ashishrj yes things are clear, well they were already made clear from the start as it is mentioned that the free version has a few limitations. I understand that 'trying the pro version for 60 days' may appeal some, but I would not consider this as a valid way to update data located on OneDrive for users that chooses to use the free PowerBI setup.

I shall have a look at the link you sent.

It would however be good however to make such information clearly seen to potential users as it may definitely tip the balance toward either of the two versions...