We have been successfully running these reports for many months. The only change is upgrading Apache Poi 4.1.2 to 5.2.3 which the generating application uses to generate the excel file with dynamic data programatically. I can supply an example filing excel file if required. Dont seem to be able to attach here.
The files are saved directly onto sharepoint by the generating program and Power BI reads them from there wih a web connection.
Now we get the following error when performing a schedule refresh, or manual refresh, through Power BI online. If we load the report, refresh the data and republish it in Power BI desktop it works successfully.
Also, if I open the excel file, force a save, and then retry the Power Bi online/scheduled refresh works.
In order to get the files under Apachi 5.2.3 to load to power BI Desktop I had to make the following change to the Transformation code navigation step:
From: = Source{[Item="Metric Report",Kind="Sheet"]}[Data]
To: = Source{[Name="Metric Report"]}[Data]
Refresh is fine in Power BI Desktop
Helpful resources
Join our Fabric User Panel
This is your chance to engage directly with the engineering team behind Fabric and Power BI. Share your experiences and shape the future.
Power BI Monthly Update - June 2025
Check out the June 2025 Power BI update to learn about new features.
Fabric Community Update - June 2025
Find out what's new and trending in the Fabric community.
