Power BI is turning 10! Tune in for a special live episode on July 24 with behind-the-scenes stories, product evolution highlights, and a sneak peek at what’s in store for the future.
Save the dateEnhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.
A little backgroud before I get into the issue. I use SAS to create excel files and in turn the excel files load into PowerBI. I'm trying to automate the process, so I run a batch file to run my sas code, and use the on-premises gateway to have the excel file auto update. This process works fine except for importing a brand new SAS created excel file.
It seems that the SAS excel file must be missing some behind the scenes code and PowerBI gives me the following error when trying to import: Unable to Connect: "Core Properties part: Text data of XSD type 'DateTime' was expected. Line 9, position 44."
I know that it has something to do with the excel product directly create from SAS. If I open the excel file, and just manually resave it works. Problem is that defeats the automation goal I have. I'll be looking into the SAS part as well, but is there a PowerBI side solution as well?
Thank you in advance for any advice or help y'all could provide!
Exported it into .CSV by SAS. It will solve the problem
Did you ever figure out how to solve this without manually resaving as you stated? I have the same issue and cannot figure out how to get around it for automation.
@Hensleyj,
I suspect that the Excel file created from SAS contains special schema or property, and you will need to open the Excel file manually and re-save it.
Are you able to open query editor of Power BI Desktop and see which step returns the error?
Regards,
Lydia
I ran into the exact issue as the OP today and the solution by @v-yuezhe-msft solved the problem. So glad that I found this post as we could not figure out what the problem was. Such a simple solution too! Thanks!
Hi Shezamala, could you please direct to the post with the solution. can't find it and having the same issue. thanks!
Check out the July 2025 Power BI update to learn about new features.