Forum Discussion
Publishing and Interacting with Data
Hey Anonymous ,
yes, you can schedule up to 8 refreshes per day in the standard workspace in Power BI Service.
How did you provide the information?
If the data is taken from a database or an Excel file that is accessible in Sharepoint, Power BI will update the data from the given source with every refresh. If the data is put manually in the file with "Enter data", then it's hardcoded in the file and you really have to open the file and update the values.
For that reason I would recommend to keep the data in an external source.
If you need any help please let me know.
If I answered your question I would be happy if you could mark my post as a solution βοΈ and give it a thumbs up π
Best regards
Denis
Blog: WhatTheFact.bi
Follow me: twitter.com/DenSelimovic
Most Valuable ProfessionalHey Anonymous ,
yes, you can schedule up to 8 refreshes per day in the standard workspace in Power BI Service.
How did you provide the information?
If the data is taken from a database or an Excel file that is accessible in Sharepoint, Power BI will update the data from the given source with every refresh. If the data is put manually in the file with "Enter data", then it's hardcoded in the file and you really have to open the file and update the values.
For that reason I would recommend to keep the data in an external source.
If you need any help please let me know.
If I answered your question I would be happy if you could mark my post as a solution βοΈ and give it a thumbs up π
Best regards
Denis
Blog: WhatTheFact.bi
Follow me: twitter.com/DenSelimovic
Hi Denis,
Thank you so much for the response. The initial excel doc was created via inputs from the team, so I guess you could say that it was hard coded. What happens if I publish the data to powerbi service, does that provide me with what I want?
Regarding your point on sharepoint. How does that work? Do I just create the doc and save it to sharepoint? My org uses one-drive so I can create the doc and then give people access like that. Apologies about the questions, I am just not sure how the connections work.
Currently, I have created everything that I want from a view perspective in power bi desktop and is essentially ready to go. The problem I have is, since this data changes often, I am not sure how to publish it so the team can directly make updates and the data refreshes
Sorry to bother, but just wondering if you happened to see my response. I am unsure how the integration with a workbook on sharepoint works with Power BI.
Are you suggesting that I start new work and save that work book to sharepoint, so that everyone has access to the source data? Then I can import that shared workbook into Power BI create my dashboard then publish it. Once its published, anyone that makes updates to the shared workbook will be updated when power bi refreshes?
- selimovd
Hey Anonymous ,
sorry, I didn't see your answer. Make sure you always tag the person like this: Anonymous .
Otherwise I will not get notified when a new reply is added.
When you hardcode the data in your Power BI file it's in the data model. If the data is changing you have to use something dynamic.
Why don't you put your Excel file with the data in OneDrive. Then you can directly load data from the Excel on OneDrive. When the data in the Excel changes, you will get the changes in Power BI after the next refresh. See here how you can do that:
https://www.c-sharpcorner.com/article/connect-to-onedrive-excel-file-from-power-bi-desktop/
If you need any help please let me know.
If I answered your question I would be happy if you could mark my post as a solution βοΈ and give it a thumbs up π
Best regards
Denis
Blog: WhatTheFact.bi
Follow me: twitter.com/DenSelimovic