Forum Discussion
Refresh data in report from updated MDB file
I have a Power BI Desktop report based on a locally stored MDB file, the MDB file was exported from a larger database.
I've downloaded an updated version of that MDB file with some new records and a new table.
How can I update my report to reflect that new data? It's not seeing the new records so the report is out of date; it's also not seeing the new table and I'd like to use the columns there to exhance my report.
Hi caseyh,
We may just replace the old file with the new one as described by CahabaData, new records for the same table would be refreshed as expected.
For the new table, if we didn’t add it before, then refresh won’t add it into current report.
To add a new table as data source, you need to click Edit Queries->Query Editor, then click New Source, then open the new MDB file and select the newly created table.
If any further help needed, please feel free to post back.
Regards
3 Replies
in PBI desktop; in data view; in the ribbon, the Home tab has a Refresh icon; presuming the identical file type, identical name, identical location as the original - that refresh should do what you seek......
have you tried this?
Hi caseyh,
We may just replace the old file with the new one as described by CahabaData, new records for the same table would be refreshed as expected.
For the new table, if we didn’t add it before, then refresh won’t add it into current report.
To add a new table as data source, you need to click Edit Queries->Query Editor, then click New Source, then open the new MDB file and select the newly created table.
If any further help needed, please feel free to post back.
Regards
