Forum Discussion
Scheduled Data Refres Failure IDbCommand
We are suddenly facing the below errors in our scheduled refreshes on the service.
Data source error - The credentials provided for the Snowflake source are invalid. (Source at xxxx.snowflakecomputing.com;<Schema Name>.). The exception was raised by the IDbCommand interface. Table: <Table Name>. No change in the credentials made.
DataSource.Error: The table has no visible columns and cannot be queried.. <Table Name>. </ccon>;<ccon>The table has no visible columns and cannot be queried.</ccon>. The exception was raised by the IDbCommand interface. Table: <Table Name>
When we refresh the reports on the desktop, we do not face any errors and the refresh is fine.
Can someone please help?
Regards
Thank you bug_finder for the response.
We found that the snowflake warehouse that was assigned to us was incorrect. After the team pointed it to the right warehouse, the reports strated refreshng again without any issues.
5 Replies
Hi sanjyot_firke ,
Please try updating the data source credentials in Power BI Service or attempt an on-demand refresh, and then check if the issue is resolved.
Best Regards,
Bof
We havew tried on demand refresh and it is still failing with either of the errors.
Refreshing on desktop is absolutely fine
Hi sanjyot_firke ,
Try this -
Export that data to a dataflow and complete all possible transformations and pull the data to your semantic model from it.
Thanks,
Sai Teja
With my recent experience with this error, I had republished the report after manually refreshing it on the Power BI desktop and that solved the scheduled refreshers failure issue. Try to do that and see if this will resolve this for you.
Best Regards,
Thank you bug_finder for the response.
We found that the snowflake warehouse that was assigned to us was incorrect. After the team pointed it to the right warehouse, the reports strated refreshng again without any issues.
