Forum Discussion
Analysis Services Community
Hi everyone,
I'm not sure if this is the right place for this question, but I can't find a specific community for SSAS projects.
Anyway, I hope you can help me with this doubt:
I have a Tabular project using Visual Studio and SQL Server Analysis Services (SSAS), with the aim of viewing the data in a Power BI report in Direct Query mode. My question is, why do I have to process the table in Visual Studio, deploy the solution, and then process it again in SQL to see the data refreshed in Power BI when I make changes to the project?
Is there a more efficient way to handle this? Why do I need to process the table twice—once in Visual Studio and once again in SQL after deploying?
For example: I changed the data type of a column in my table, and I don’t see the change until I go through the previous steps I detailed.