Forum Discussion
Scheduled Refresh error Access database error code -2147467259
There was a Power BI Service version change.
If you have a Pro license you can open a Pro ticket at https://admin.powerplatform.microsoft.com/newsupportticket/powerbi
Otherwise you can raise an issue at https://community.fabric.microsoft.com/t5/Issues/idb-p/Issues .
There was a Power BI Service version change.
If you have a Pro license you can open a Pro ticket at https://admin.powerplatform.microsoft.com/newsupportticket/powerbi
Otherwise you can raise an issue at https://community.fabric.microsoft.com/t5/Issues/idb-p/Issues .
I met the same promblem, and bothered me for almost one month.
Has anyone solved this kind of errors? I want to ask for some suggestion, thanks!
I encountered a similar error a few years back and was able to resolve it with an ODBC connection on the Gateway instead of a file connection. This article was helpful: Using MS Access as a data source with On-Premises Data Gateway
A few things learned:
1. DateGateway user has to have security to the access datatabase location. May be a service account.
2. For the ODBC connection we are using the Micosoft Access Driver.
3. The access file format matters. When using compact and repair it can revert depending on what data types are in the database.
4. Under File>Options>Current File>Data Load in PowerBI we select One (disable parallel loading)
There is aso some rwx access that needs granted on the PowerBI server, this is what I have in my notes:
- Note that this says rwx access needs to be granted to C$\Users\PBIEgwService\AppData.
- Added these permissions to \Windows\ServiceProfiles\PBIEgwService\AppData\
- Noted online that this path may be OS version dependent; this is not documented well online.
