Forum Discussion
Data source error: Value was not specified..
Ok, I've found the solution. Last month, I enabled the 'New Snowflake connector implementation' feature which is still in preview. The refresh obviously didn't like this! Anyway I've disabled it and all works fine now.
The most likely explanation I can think of given your notes you have multiple queries in that model from the same source that are set up differently. Power BI accepts both (ServerName) and (ServerName:Database) as data source when setting up a data query from SQL Server. Both setups work the same in power bi desktop i.e. no exceptions. However, the exception of IDbCommand interface will be thrown if there were more than one query and at least one of these queries used different setup to the rest of queries.
What do you mean when you say 'set up differently'?
For added context, I have 7 active queries from Snowflake. And 5 custom-made ones created with DAX/M (things like date tables, indexes, etc.). Also, after refreshing multiple times I get the same error but the table name changes. Originally it was the students table, but now it's something else. I feel like even if I had one query it would still error out.