Forum Discussion
Where does the excel file data go?
HI Anonymous,
Sorry to bother you again, but I think my new question is still related with what you mentioned yesterday...
Let say I create a report with Visualizations in Power BI Desktop by using the GetData option from an Excel file, but the Excel file gets modified either in structure (new column) or data, is there a way to get those updates into my report before publishing it into the service? in order to still keep my data local, at least for now.
Thanks a lot in advance!
Brenda
brendaivett No bother. You can refresh your data set at any time. Up in the "Home" tab of the top header toolbar you will see "Refresh" - just click that any time to update your dataset. Both data and column changes will appear in your Desktop file.
Anonymous, you just saved my life, thank you soooo much!
Brenda
Hi Anonymous,
I have been building my reports with Power BI Desktop, getting the data from the excel files I already had, refreshing them as you recommended, with the Refresh button, and everything was going smoothly until today, when I tried to look into one of my reports, updated, I noticed it's not refreshing the information, I tried open the report double-clicking on it, I tried first opening Power BI and from there opening the report and nothing seems to help, do you have any idea/recommendation on how I can get the reports refreshed again?
Thank you so much in advance!
Brenda
Hi Anonymous,
I have been building my reports with Power BI Desktop, getting the data from the excel files I already had, refreshing them as you recommended, with the Refresh button, and everything was going smoothly until today, when I tried to look into one of my reports, updated, I noticed it's not refreshing the information, I tried open the report double-clicking on it, I tried first opening Power BI and from there opening the report and nothing seems to help, do you have any idea/recommendation on how I can get the reports refreshed again?
Thank you so much in advance!
Brenda
brendaivett can you clarify, you are doing all this checking and refreshing in the Desktop only - correct?
Have you tried to right click on the Fields that are populating the reports and refreshing those individually? Are you just refreshing the info, and no model changes?
Anonymous
Yes, I'm working right now in the Desktop only...I really don't know what happened, but now it's working again...I had been trying to refresh even from the Advanced Editor to see if that would help and nothing, although what was weird is that it "refreshed partially" I could see more records in one of the tables only, but not all of the records in that table and in the rest of the tables, no change at all.
After reading your message I tried refreshing one table, and it refreshed, then another one, and it did, then I did the full refresh and it worked...so, did that got it "unstuck"?
Thanks for your advice!
Brenda