Scheduled Data Refres Failure IDbCommand

[sanjyot_firke]

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

[bug_finder]

Hi @sanjyot_firke 

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,

[sanjyot_firke · Accepted solution]

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.

[Anonymous]

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

[sanjyot_firke]

We havew tried on demand refresh and it is still failing with either of the errors.

Refreshing on desktop is absolutely fine

[SaiTejaTalasila]

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