Stored procedures in Analysis server

• don075

  SSC-Addicted

  Points: 425

  More actions

  October 6, 2023 at 4:51 pm

  #4302870

  I have written a stored procedure to format data and return them as a table with custom columns. In this sp, I use #temp table to do some formatting / calculations. Now our powerBI report writers want to access to this SP from Analysis service. For them our admin created SQL analysis service. PowerBI users connect to this and create the required reports. What I want to know is, whether it is possible to move a stored procedure from my SQL server to Analysis service? I am very new to Analysis service, so I don't know much.

  Any help is greatly appreciated.

• Site Owners

  SSC Guru

  Points: 80325

  More actions

  October 7, 2023 at 5:10 pm

  #4303484

  Thanks for posting your issue and hopefully someone will answer soon.

  This is an automated bump to increase visibility of your question.