Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and a 50 percent discount on exams.
Get startedEarn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
Hi!
I have a D.B. in Microsoft Access that is the source of a report. At the same time this D.B. is reading from other databases, these databases upgrade automatly every morning.
Every morning, I do the same process in order to update my Power BI report: I execute a "macro" developed in Aceess in order to update my D.B. , then I open and update the report in Power BI desktop. At this moment, I have the report upgrade for my colleges.
There is any kind of macro in Power Bi that could make all this routine: execute a macro in Acess, update the report and publish it.
Thanks
Edu
If you mean update the DataBase Data within Power BI Desktop, then it is not available, based on what I know.
For DataSets published into Service, you may take a try with Data Refresh:
Or consider use the REST API to update the DataSet directly with Add Rows or Delete Rows Action:
The whole REST API reference.
Regards,
Michael