Forum Discussion
Consume Excel file stored in M-File from PowerBI
Hello, Is there anyone who has configured PowerBI or a Dataflow in a way to consume an Excel file directly from an M-File Vault? By using the "Get Data" from PowerBI, I'm able to find the file from...
Hi GiulianoB,
An update on this from my side in the hope it helps others...
We currently have two solutions:
1) Connect with the file via the local M-files M:/-drive and use a personal on-premises gateway for scheduled refresh.
2) Create a Power BI Custom connector for connecting to files in M-files, including authentificatio logic. And install an on-premises gateway to connect to the custom connector .MEZ file.
Best regards!