Forum Discussion
Nondescript error in Power BI service for dataflow refresh
Sorry for the late reply, I figured out the issue.
Power BI recently, apparently had an update to how it connects to SQL CLR databases. 0-length passwords used to be allowed but now are not. I had to change my password from nothing to something in SSMS and then update my password in power bi connection settings. Everything worked fine after that.
I should note that there was no error with my nothing-password until I erased it and put nothing as my password again, which was not allowed and I was asked to input a password. That's why it took awhile to track down.
This is very strange, I checked your code carefully and found no errors.
What is your data source? SQL Server?
Best regards,
Lionel Chen
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Sorry for the late reply, I figured out the issue.
Power BI recently, apparently had an update to how it connects to SQL CLR databases. 0-length passwords used to be allowed but now are not. I had to change my password from nothing to something in SSMS and then update my password in power bi connection settings. Everything worked fine after that.
I should note that there was no error with my nothing-password until I erased it and put nothing as my password again, which was not allowed and I was asked to input a password. That's why it took awhile to track down.