data refresh failure after publishing to the cloud, but No issue mannually with Desktop previous ver

[simontaylor]

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?

[simontaylor]

It is fixed in Feb Release. Thanks to the Power BI Dev team.

[simontaylor]

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?

[v-huizhn-msft]

Hi @simontaylor,

Please follow the update and try other workaround is provided by @v-jiascu-msft in this similar thread.

Best Regards,
Angelia

[simontaylor]

thank you. i contacted tier 2 support and he filed an incident internally. i will wait for the fix and try again.

[v-huizhn-msft]

Hi @simontaylor,

You're welcome, it's my great pleasure to help you.

Best Regards,
Angelia

[simontaylor · Accepted solution]

It is said that the issue has been fixed and will be released in Feb. Let's see.