Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
I found one issue after updagrading to the latest dev version of Power BI desktop. So I reverted back to the prevoius version and then published my data to the cloud after changing dataset without any issue. But when I set the data refresh automatically, the refresh failed all the time. I changed many things but it is still in error. Can anyone help me out?
Solved! Go to Solution.
It is said that the issue has been fixed and will be released in Feb. Let's see.
It is fixed in Feb Release. Thanks to the Power BI Dev team.
I updated my power bi to the latest and the error is like below:
DataSource.Error: Microsoft SQL: Case expressions may only be nested to level 10.
Incorrect syntax near '$Outer'.
Details:
DataSourceKind=SQL
DataSourcePath=********.database.windows.net,1433;********
Message=Case expressions may only be nested to level 10.
Incorrect syntax near '$Outer'.
Number=125
Class=15
But when using the previous version, there is no issue at all. Who can help to fix it?
Hi @simontaylor,
Please follow the update and try other workaround is provided by @v-jiascu-msft in this similar thread.
Best Regards,
Angelia
Hi @simontaylor,
You're welcome, it's my great pleasure to help you.
Best Regards,
Angelia
It is said that the issue has been fixed and will be released in Feb. Let's see.
User | Count |
---|---|
98 | |
89 | |
82 | |
70 | |
67 |
User | Count |
---|---|
114 | |
104 | |
101 | |
72 | |
65 |