Forum Discussion
Data Refresh Schedule Error while processing the data in the semantic model
Yes I would. Those old formats will require a driver. That means a VM with a gateway and driver in order to read it. If you want to read it from cloud, you should convert it to xlsx.
Regards,
Hi. Cloud it be that the file is "xls"? If so, please convert it to xlsx so you can read and connect directly to sharepoint. Otherwise you will need a gateway in order to install an OLEDB client that reads xls in the machine.
I hope that helps,
Hello. Thanks for your input. I have 1 file that is in .xlsb format. Does it also affect the refresh ? Do I need to convert other formats into .xlsx ? 🙂
Yes I would. Those old formats will require a driver. That means a VM with a gateway and driver in order to read it. If you want to read it from cloud, you should convert it to xlsx.
Regards,
Thank you. I'll consider this solution final once we've made the necessary changes and the refresh is successfully completed. Have a good day 🙂