SSAS - A datatable in DSV works nicely alone _but_ causes the entire build to fail

Arto Kilponen 21 Reputation points

I have a SSAS project that is otherwise ok, but as soon as I try to modify one view in DSV to use a more complex GROUP BY clause (a pretty simple case-when-then), two things happens:

1) In the Edit Named Query window, running the query works just fine. Gives the results that I want and doesn't even take all that long to calculate. Also running the same query in SSMS works fine.

2) Performing a build to the project fails. Error list is empty, I get no warnings, it just simply fails with "========== Build: 0 succeeded or up-to-date, 1 failed, 0 skipped =========="

I switch it back to the original query, everything is again fine.

What should I check?

Visual Studio version is SQL Server Data Tools for Visual Studio 2017, 15.9.21

SQL Server Analysis Services
SQL Server Analysis Services
A Microsoft online analytical data engine used in decision support and business analytics, providing the analytical data for business reports and client applications such as Power BI, Excel, Reporting Services reports, and other data visualization tools.
1,241 questions
0 comments No comments
{count} votes

Accepted answer
  1. Lukas Yu -MSFT 5,816 Reputation points

    The error is quite general and not useful for debugging.
    Would you mind to share sample data and query so we could replicate your issue and see what we can do ?

0 additional answers

Sort by: Most helpful