Forum Discussion
Scheduled Refresh failing immediately with COM error: "not found"
Hi all,
We've started testing Power BI Report Server recently and are trying to configure automated refreshes. Our report is currently hosted on powerbi.microsoft.com and automated refreshes work without issues. Unfortunately, when trying to configure refreshes with the same credentials we receive the following error:
[0] -1056505856: COM error: Microsoft.PowerBI.ReportServer.ASEngineManagedRoot, Datasource {"protocol":"tds","address":{"server":"xxx.database.windows.net","database":"xxx"},"authentication":null,"query":"IF OBJECT_ID(\u0027tempdb..#xxx\u0027) IS NOT NULL\n\tdrop table #xxx\n\nIF OBJECT_ID(\u0027tempdb..#last_info_date\u0027) IS NOT NULL\n\tdrop table #last_info_date\n\nSELECT xxx[long SQL query]} is not found..
Does anyone have any experience with this error? I am not sure why this seems to be happening.
- Anonymous5 years ago
Just wanted to provide an update to this thread, we released a new build of Power BI Report Server yesterday which fixed the issues described in here. In case you still experience problems after the upgrade, I suggest to open a separate thread specific for that issue so we can better track. Feel free to tag me directly in those as well.
You can find more details about the update in this thread:
39 Replies
- AnonymousNot applicable
Hello,
any idea how can this error:
COM error: Microsoft.PowerBI.ReportServer.ASEngineManagedRoot, No credentials were found
without upgrading the PBI report server. This is not an option that we can do now.
Thank you
- marcosffmFrequent Visitor
Good Morning,
I also have the same problem with updating reports. I have specific reports working, but I couldn't identify why one report works and another doesn't work, both with the same data source.
The error follows:
SessionID: 7ffa4417-874c-42e5-9367-0fa2ad259e2d
[0] -1056505856: COM error: Microsoft.PowerBI.ReportServer.ASEngineManagedRoot, No credentials were found for the datasource.
[1] -1055784932: The command has been canceled .. The exception was raised by the IDbCommand interface.
[2] -1055784932: The command has been canceled .. The exception was raised by the IDbCommand interface.
If anyone can solve the problem, please share. Thanks
- AnonymousNot applicable
Same problem here:
0] -1056505856: COM error: Microsoft.PowerBI.ReportServer.ASEngineManagedRoot, No credentials were found for the datasource. [1] -1056505856: COM error: Microsoft.PowerBI.ReportServer.ASEngineManagedRoot, No credentials were found for the datasource. [2] -1056505856: COM error: Microsoft.PowerBI.ReportServer.ASEngineManagedRoot, No credentials were found for the datasource. [3] -1055129594: The current operation was cancelled because another operation in the transaction failed. - metoxFrequent Visitor
yes, we have the same problem too. After last PBIRS update all scheduled refreshes still don't work. Especially PBI reports with many data sources.
- jamiestevens28Frequent Visitor
Anonymous
We are still having issues with PowerBI reports that were newly created or updated using the Oct 2020 Desktop version (with the November 718th release date), where the scheduled refresh does not work.We have confirmed that once we have had all our developers uncheck the preview feature (Enhanced Meta Data), that other reports appear to be fine upon publishing to PowerBI.
Some questions:
- Will there be a hotfix to address report refreshes on the SSRS portal that have the new Enhanced Meta data preview feature applied? When will the fix be coming?
- On the install, why was a preview feature enabled by default? If enabled by default, why wasn't scheduled refreshes tested prior to release of the October 2020 (November 18th)?
- BokaFrequent Visitor
HI Mike_Mellis , Anonymous as you said everything is working with October 2020 when option for preview features is unchecked.
Anonymous just to clarify once again: problem I mentioned in first message is about model with two queries on the same data source. One of them with indexed column. Scheduled refresh didn't work. Second one is model with one data source and two direct queries. Simply edit and save back to the server produce report that doesn't work on server. Details in messages 13 and 14.
Have a nice weekend.
- AnonymousNot applicable
Just wanted to provide an update to this thread, we released a new build of Power BI Report Server yesterday which fixed the issues described in here. In case you still experience problems after the upgrade, I suggest to open a separate thread specific for that issue so we can better track. Feel free to tag me directly in those as well.
You can find more details about the update in this thread:
- AnonymousNot applicable
i have the same problem and this update didn't solve it.
i still update my dashbords manually
- blynn
Helper I
I had a may 2020 copy on another computer. I remote desktop to that computer, and opened a blank report. I copy and pasted the controls and the queries. I fixed the relationships and saved the file . Then I published it. I saved the file and loaded it with the oct 2020 release (with the meta data disabled) and it loaded and I have published it with no issues. Thats the best work around I've found so far and the fastest.
- blairblair
Helper I
Anonymous / YonghunLee Your files are now "infected" since you saved them prior to unchecking the metadata preview feature box. You must revert to a file that was saved with May 2020 or earlier and then as long as the metadata preview feature is not enabled it will work with October 2020 Desktop / Report Server
- YonghunLee
Helper I
Thanks a lot. It's very helpful. But my files have already infected. It' so sad.
Preview option should have been defaulty unchecked when It's installed.
- YonghunLee
Helper I
Another Big issue.
when using "Folder" data connection and connect to Sharepoint.
the File cannot be saved to Server.
this is first time to see "save error". I have nerver seen the error in the series of previous version.
Please help me.
- YonghunLee
Helper I
Hello. I have also made a thread about the Octobar version error but no rely.
In this thread MS empolyee is working, so I reply issue again in this thread.
But In my case, after removing the "enter data", still there is error on refreshing on the server.
error message is like this.
there is no problem with previous version. as soon as i open the file with new version Power BI Desktop, with no change, refresh in the newer verison power bi desktop is fine.
but when to save again to new version Report server. refresh in report server, error occurs as below.
there are many report in service in my company. But after update, i have to update manually every day. ever hour the all report.
as you know. once pbix file is saved in newer version, I cannot rever the file to previous version.
i am in a hell.
please help me.
SessionID: a31e4ae3-8034-47af-b979-c4ee6756dc1c [0] -1055784932: Information is needed in order to combine data;Information about a data source is required.. The exception was raised by the IDbCommand interface. [1] -1055784932: The command has been canceled.. The exception was raised by the IDbCommand interface.