Connect to a Microsoft Access DB stored in OneDrive for Business?

[s15]

Is there a way to work with my Microsoft Access DB stored in OneDrive for Business? I can use Power BI Desktop to connect but saying a case that my work requires different computers that doesn't store Access file. That's why I need to put in on OneDrive.

[v-ljerr-msft]

Hi @s15,

As far as I know, it is not possible to connect to Microsoft Access DB stored in OneDrive for Business currently. 

Is there a way to work with my Microsoft Access DB stored in OneDrive for Business? I can use Power BI Desktop to connect but saying a case that my work requires different computers that doesn't store Access file. That's why I need to put in on OneDrive.

---

There is a new feature called Power BI service Live connection, with which you can create your perfect data model in Power BI Desktop, publish it to the Power BI service, then you and others can create multiple different reports (in separate .pbix files) from that same, common data model.

So I'm wondering if you could store your Microsoft Access DB file on a specific computer, and create your data model there and publish it to Power BI service, then connect to this dataset on other computers that doesn't store the Access file with this feature(Power BI service Live connection). 

Regards

[majdya]

Hello,

But he will still face the same problem, he will not be able to update the Power BI dataset when the MS Access DB is changed, until he goes to his own computer and force refesh and publish to his pbix file to the service, and the other shall wait.

Microsoft is simply killing MS Access by disabling all web functionalities, I do not really know the reason, I feel it is because they want to invest in Power Apps, and for me I still can't find it convince-able reason.

Regards