Forum Discussion
Memorable MemberDataset Refresh error Microsoft.ACE.OLEDB.12.0 provider is not registered on the local machine
Super UserHi there
Could a potential work around be for now, to use Power Flow, and download the file to OneDrive, and then from there Power BI can then connect to the file via OneDrive?
In doing it that way, the Power BI Service will be able to refresh every 15 minutes which is the default setting. As well as the Power Flow downloading the file to the same location?
dcrespAdvocate IV
GilbertQ your sugested work around of using MS FLow could be an option. However, I have looked at Flow and can not see any easy way to be able to download a file from the web to One Drive. Can you give me some pointers on how you would do this. Thank you very much.
- GilbertQ
Hi there, here is an example from Microsoft
https://flow.microsoft.com/en-us/documentation/get-started-logic-flow/
And when you get to adding an action, change that to an Excel File.
NOTE: You will have to see the format of the data you are getting and create a table in Excel that represents this dataset.
NOTE II: Also ensure that you save your Excel File in OneDrive for Business, as this will mean that you can quickly connect to it via the Power BI Service or Power BI Desktop (and get 15 minute automated refreshing)
So when you make the action to an Excel file, you will be able to map the output columns to columns in your Excel File.
Then once that is done your data source should be updated automatically.
- mike_honey
GilbertQ that sounds interesting, but that link you posted gives a 404. I tried browsing from the home page but couldnt find what you described.
