Hi,
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 ?
SSAS - A datatable in DSV works nicely alone _but_ causes the entire build to fail
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
-
Lukas Yu -MSFT 5,821 Reputation points
2020-11-27T08:56:03.293+00:00