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 the M-File desktop version I'm using but then, a local copy of it is getting created in my SharePoint personal folder. Unfortunately in this way, the file used by PowerBI is not any more connected with the real source. I've found on the network the suggestion to work in the opposite way around. Something like: - Store the Excel working file in SharePoint - Link PowerBI to SharePoint (very easy) - Copy the file to M-File when approval is needed ... but I need to secure that my PowerBi is using only the latest approved data from the source. Is there any official best practice on this matter that I can use? Thanks!!!