Forum Discussion
Solved
Sharepoint Folder not refreshing
I have a connection just to a OneDrive link, registered as "a SharePoint folder", Power BI Service tells me that I don't need a gateway, but it tells me the following error: Excel Workbook: The 'Micr...
It seems your source file is either .xlx or .xlsb
You can follow any of below
1. Update your source file to .xlsx
2. Configure a gateway and install 64bit version of Microsoft.ACE.OLEDB.12.0 on gateway server, then create a data source for your source file (even it's on SharePoint) and use that to refresh your dataset.
It seems your source file is either .xlx or .xlsb
You can follow any of below
1. Update your source file to .xlsx
2. Configure a gateway and install 64bit version of Microsoft.ACE.OLEDB.12.0 on gateway server, then create a data source for your source file (even it's on SharePoint) and use that to refresh your dataset.