Forum Discussion
Solved
Excel xlsb file type Refresh Fails
I have a data source of an excle binary file type in onedrive. I have successfully create a report and published in Power BI service. But if i try to refresh from Power BI service. It shows the erro...
In conclusion, Excel binary file type cannot be refresh from Power BI service. But I found the way out, we can refresh it using Gateway. Although Gateway is not necessary for Onedrive files, but for binary file type it is helpful.
Hi.
I know it's a little bit late, but I just solved this problem installing the Microsoft Access Database Engine on the Data Gateway server:
https://www.microsoft.com/en-us/download/details.aspx?id=54920
Hope this information helps someone.
Could you explain us how you did it? You need to install on which local? Do we need to set up a gateway first and then installing it in the same machine? Thanks