Forum Discussion
Dataset Refresh error The 'Microsoft.ACE.OLEDB.12.0' provider is not registered on the local machine
Super UserThe idea of a Gateway is installing that on a Machine that will be turned on when refresh happens. It's usually recommended on a VM or a Server that is turned on 24 hours a day to let you refresh any time.
If you don't have IT support or VMs to install it, you can install it in your personal environment. It will refresh while your PC is turned on. It's not the best practice because the entire solution depends on your PC, but it's a start.
You can learn more about the gateway with this two videos:
Get started: https://www.youtube.com/watch?v=Vlv1tbuZNcM
GW new look: https://www.youtube.com/watch?v=L18HEAnBqTo
I hope that helps,
Hello,
What about the Microsoft Fabric? How to make a gateway that connects to it.
I try to use Dataflow that extract data from .xlsb in Sharepoint and yes error message showed up require me to install ACE OLEDB
(I know the "save as .xlsx" solution but I want to connect dataflow with .xlsb)
Any solution to solve it?
Thank you,
Best regards,
- ibarrau
Hi. It's the same gateway for Fabric than for Power Bi.
If you have more troubles and issues you need help, please consider writing a new post so we can keep track just in case it's a different solution.
I hope that helps,