Forum Discussion

SofiaFernandez's avatar
SofiaFernandez
Copper Contributor
Sep 12, 2024

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.

No RepliesBe the first to reply

Resources