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.
Hi precisionandskl ,
Thank you for reaching out to us on the Microsoft Fabric Community Forum.
As you mentioned the error during refresh in Power BI Service, even though the report refreshes fine in Power BI Desktop and other reports using the same data sources work.Please go through the below steps:
Check Gateway issues ,If you're using an On-Premises Data Gateway, make sure it’s online and up-to-date.
Open Power Query Editor and check if any transformation relies on local parameters or dynamic values that may not be resolving in Service.
And also please go through the below link in which the issue is same:
Solved: Re: Data Refresh Error - Microsoft Fabric Community
If this post was helpful, please give us Kudos and consider marking Accept as solution to assist other members in finding it more easily.
1) Not using an On-Premises Gateway
2) The only transformations are a few conditional columns, which are identical to the transformations in the reports that are refreshing successfully