I have a Power BI file that its data sources are stored in a sharepoint folder.
Some of these data sources are xlsx files that I receive by email daily.
I tried to use power automate to avoid having to save all these files manually on a daily basis. I've created a flow, it works, and I'm able to open the file, though the size is slightly smaller than if saved manually.
But no matter the flow I created, in the end, Power Query cant read that file, showing the following message: "The input couldn't be recognized as a valid Excel document. Details: [Binary]"
I tried to search for help and etc, but never been able to find a workaround to make it work.
Thanks if anybody could help me.