Power BI Service Auto-Refresh Failing

[Koray_ECL]

Hi everyone,

I’m looking for some help with an issue in Power BI related to automatic data refresh.

Overview of the setup:

• I’m pulling data from multiple sources that update automatically, storing these in a personal OneDrive account.
• I’ve created a PBIX file that connects to these OneDrive files via a SharePoint path, and I keep this PBIX file on my personal network drive.
• For refreshes, I use Power BI Desktop to pull in the updated data, and then I publish it to my personal workspace where others access it through link permissions.

The problem? Although I can refresh the report manually via Power BI Desktop without any issues, the automatic refresh in Power BI Service keeps failing.

Error Message Details: The refresh history error message says:

Data source error: DataFormat.Error: The specified package is invalid. The main part is missing. The exception was raised by the IDbCommand interface. Table: Power BISource_Data.

I’ve done some digging and haven’t found a clear solution. One suggestion I came across was that XLSX strict format files might cause issues, but I’ve confirmed that all files are in standard format, so that doesn’t seem to be the problem.

Has anyone run into this before? Any ideas or tips on troubleshooting this further would be greatly appreciated.

Thanks in advance!

//Koray

[Koray_ECL]

Hi Power BI people,

Has anyone come across this auto-refresh issue, and potentially know of a workable solution?

Thanks in advance,

Koray

[Koray_ECL]

 

[Koray_ECL]

Evening people, is there anyone out there who can decode this error code and convert it into plain ye old english... 

I can see there's something about IMDB and wasabi but that's about it.

Data source error: One or more errors occurred.;One or more errors occurred.
The specified package is invalid. The main part is missing.. The exception was raised by the IDbCommand interface. Table: ECL_Facts.
Cluster URI: WABI-UK-SOUTH-C-PRIMARY-redirect.analysis.windows.net
Activity ID: 2e9be358-1db1-426e-8323-55e4e84f9eeb
Request ID: 9ce7f094-cf3f-1f4e-cd42-1dda26acf646
Time: 2024-10-29 17:27:17Z

[stephanie_pena]

I have a colleague that is experiencing this same issue with SharePoint connections. The Power BI Desktop refreshes without error, but the Semantic Model in Power BI service is failing with the same error.

The semantic model in Power BI Service was refreshing without error until October 2024 update. 

[Koray_ECL]

Hi Steph, did your colleague find out the reason?? Thanks, K

[stephanie_pena]

Hi K  - No not yet.

[SaiTejaTalasila]

Hi @Koray_ECL ,

You can try to pull data to you a dataflow and see whether the same issue occurs or not.

I hope it will be helpful.

Thanks,

Sai Teja 

[Koray_ECL]

Thanks Sai, I'll give it a go.

[christinepayton]

That's a weird error that I haven't seen before. Scheduled refresh does work with OneDrive sources similar to SharePoint, since it is SharePoint, but you need to enter credentials in the refresh settings in Power BI. I have a tutorial on how to set up the refresh here - this one is for SharePoint, but the concept is the same: https://youtu.be/ba1Akv63GDQ

Make sure that the path you're using in the query for the file source is the cloud path, not the synced local path, assuming you want to avoid using the gateway. 

Keep in mind that if you use OneDrive that your source is tied to your account, so if you leave your org it gets deleted. If you need it to keep running long-term, you might consider moving it to a shared site. 

[Koray_ECL]

Thanks for the reply.

I'm fairly sure it's setup correctly because I got it to work initially. This problem occurred at some point after publishing a change to the report via the desktop app. Could it be a problem related to power query or dax?

When I click the refresh button it just spins for a while and then shows a little triangle with the warning message below...

Data source error: One or more errors occurred.;One or more errors occurred.
The specified package is invalid. The main part is missing.. The exception was raised by the IDbCommand interface. Table: ECL_Facts.
Cluster URI: WABI-UK-SOUTH-C-PRIMARY-redirect.analysis.windows.net
Activity ID: 2e9be358-1db1-426e-8323-55e4e84f9eeb
Request ID: 9ce7f094-cf3f-1f4e-cd42-1dda26acf646
Time: 2024-10-29 17:27:17Z

[christinepayton]

There's a thread on this particular error here, is there any chance that the filetype of the source files changed? https://community.fabric.microsoft.com/t5/Service/Data-Refresh-Error-The-specified-package-is-invali...

[Koray_ECL]

Thanks Christine, I've been through this thread and couldn't see a solution... I've checked the data files and they are definitely in standard format.

[Koray_ECL]

POWER BI SUPER USERS, ASSEMBLE!

[ThomasWeppler]

This froum is not watched quite as much as the Desktop forum, but I am sure someone will read your post within a week. Just be patient. 🙂

[Anonymous]

Hi @Koray_ECL 

In the Power BI service, My Workspace is your personal workspace, and by default, others cannot access its contents. If you want to share content with others, it's recommended to publish the content to a shared workspace and assign appropriate roles to other users.

Try refreshing after publishing the content to the shared workspace to see if the issue still exists.

Best Regards,

Jayleny

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[Koray_ECL]

Thanks for the reply Jayleny,

The report has been published to a new workspace, which has then been shared with my colleagues to access. To reiterate, refreshing manually via the desktop app and then republishing works fine, it's the auto-refresh function on the Power BI service which is not working. All data sources are online so there shouldn't be a need for a gateway. Thanks.

[Koray_ECL]

Afternoon PBI super users... any ideas regarding my original post? Thanks!

[ThomasWeppler]

Hey 
Have you installed a gateway on your computer?

[Koray_ECL]

Hi Thomas,

Thanks for the reply.

The files are on my Onedrive account. Isn't a gateway only required if the files are stored offline?

[ThomasWeppler]

I use a gateway to connect to my online data sources.
And it solved the problem you describe for me.
While you wait for a superuser to see your post you can read a bit about how on-premises gateways works here: https://learn.microsoft.com/en-us/power-bi/connect-data/service-gateway-onprem