Update Acess and Report, publish directly from PowerBI

[Eduardo_Jimenez]

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

[v-micsh-msft]

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:

Data refreh in Power BI

Or consider use the REST API to update the DataSet directly with Add Rows or Delete Rows Action:

Add Rows/Delete Rows

The whole REST API reference.

Regards,

Michael