Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
15 | |
2 | |
1 | |
1 | |
1 |