Forum Discussion
Error when publishing Power BI report with multiple connections!
Community ChampionAre you using the latest version of Power BI Desktop - currently March 2023? I would use that and retry. then we can dig deeper to see what the issue is.
Yes, I am using the latest version
- edhans
I would test it this way.
- Save a copy of the PBIX.
- Delete one of those tables and publish.
- Keep doing that until it works.
- Once you figure out which one was causing it post that code here and let's see if we can figure out what the issue was.
You could also make a new connection for that table and copy the M code into it, then load that. It will delete any measures you have stored in that table, so move them first.
Great idea! The only data source that didn't work was the one coming from Sharepoint. It's a folder in Sharepoint documents, and when I query it, I combine all the .xlsx files from the folder. As mentioned before, there are no errors in the Desktop version, and through the connection manager, I see that this query is online. I wonder what happened with this one?
File contains corrupted data.. The exception was raised by the IDataReader interface. Please review the error message and provider documentation for further information and corrective action.
I also ran the query on different accounts to ensure there was nothing different.
