ANALYSIS IN EXCEL FUNCTION DOES NOT WORK IN SSDT

[杰克逊1300]

VISUAL STUDIO 2022 OPENS THE SSAS TABULAR MODEL PROJECT FILE, AND THE ANALYSIS  IN EXCEL FUNCTION DOES NOT WORK, AND THE EXCEL PIVOT TABLE CANNOT POP UP, WHAT IS THE REASON?

[#2]

@杰克逊1300 , NO NEED TO YELL, WE CAN HEAR YOU 

Netiquette of Capitalization: How Caps Became Code for Yelling | The New Republic

"Does not work" means what in detail?

[#3]

@olafhelper when I click the button "analysis in excel", the excel not pop up. 

[#4]

@杰克逊1300 

Did you ever found a solution to this? I'm struggling with the same problem.

/Steen

[#5]

@steensp sorry, no solution so far.

[#6]

@杰克逊1300 Most likely related with corrupted excel installation. Try repairing the office installation (or just excel).

[#7]

@Tiago_Meireles 

That was not the case for me. I tried to reinstall Excel and Office etc. several times. It have started to work again though, and I think that happened after one of the latest updates of Visual Studio 2022. I'm not sure which of the updates, but since that's the only thing I have updated lately on my PC, I'm quite sure that this was the reason.

/Steen

[#8]

@Tiago_Meireles thank you