Forum Discussion
Helper IVError with Access whil refreshing dataset
Hi. In order to connect with Access data at PowerBi Service, you need to use an OnPremise Data Gateway. You might wonder why if it's at sharepoint. That's because the power query connector for accesss need a driver to read it that will only run at a windows. The thing with Access it's that it's an old way of keeping data.
You can read about this here: https://learn.microsoft.com/en-us/power-query/connectors/access-database
This is the driver you need: https://www.microsoft.com/en-us/download/details.aspx?id=54920
I hope that make sense
Super UserHi. In order to connect with Access data at PowerBi Service, you need to use an OnPremise Data Gateway. You might wonder why if it's at sharepoint. That's because the power query connector for accesss need a driver to read it that will only run at a windows. The thing with Access it's that it's an old way of keeping data.
You can read about this here: https://learn.microsoft.com/en-us/power-query/connectors/access-database
This is the driver you need: https://www.microsoft.com/en-us/download/details.aspx?id=54920
I hope that make sense
Arkhos94I'm not sure I understand everything in your link but it seems to be the solution to my problem => thanks
I will work on it with my IT department