Forum Discussion
Adding measure while using SSAS tabular datasource corrupt the whole report
I have a Dataset created in PowerBI Service that is based on an SSAS Tabular model. The Dataset was created with 'Connect live' option.
Then I open up PowerBI Desktop, connect successfully to the Dataset in PowerBI Service and begin to create a report. I Selected something from my Date dimension and several measures. This worked fine. But there's was one particular Measure that was causing the report to fail with the error message: 'Can't display visual'.
I asked one of my colleagues at work to try the same set of actions that I did and for her it worked without any issues even when adding the measure that made my report crash. Weird!
At first I thought it was some permission issue but then if that is the case then I shouldn't have been able to connect to the Dataset and create the report in the first place (at least with the measures that were working).
I really don't know what the cause this but there was one action I took that solved the issue. I simply went to my SSAS Tabular model and did a Full Process through SSMS. And that solved the problem. But I really don't have an explanation for why this worked because if it did work for my colleague then why not for me?