Forum Discussion
Data Refresh
As far as the short term solution, once I export it and store my file on a cloud-based platform, all the data in my report should be updated in both the deskop and online web service or just one location? And when I export that new file, will the measures I previously created still be available to me? Or do I need to create new measures since it is technically a new table?
You will need to manually refresh from the desktop (at least once) and publish the report with the updated reference. You don't need to create any new measures or edit them as long as you keep the same table structure (column names and number of columns). Then you can schedule your refresh.
Independently of the type of solution, when working with Power BI Desktop you will always need to manually refresh the data from Power BI, but that's only required when you need to develop or update the report. Else, the Power BI Service will run the refresh for you automatically on your scheduled periods.
I've moved my files into my OneDrive and my reports have been refreshing on the desktop side. However I am still strugglign to get them to refresh on the web service. I haven't been able to schedule a refresh because my data source credentials are not being received.
I've tried editing and configuring the credentials but it say it is failing to update.
Is there a way to fix this?
Which authentication method did you select? Should be OAuth2 Organizational. If you still struggle, DM me and we can see how to connect to address your issue 🙂