connect PBI template to ssas

[Anonymous]

Hey all,

Im trying to connect the data with tabular(ssas) to built in PBI template. 

I'd like your help with the connection becuase when im trying to import the template it opens in a new PBI file and when im trying just to connect directly with the SSAS it won't let me(although I can connect to the ssas from a new file with no issues).

Thanks!

[v-lionel-msft]

Hi @Anonymous ,

"im trying to import the template it opens in a new PBI file and when im trying just to connect directly with the SSAS it won't let me..."

What is the pop-up window and what do you need to provide when you are importing a template?

Best regards,
Lionel Chen

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[Anonymous · Accepted solution]

The solution: I deleted in the power query all the data sources/tables I connected and then it let me connect to the ssas.

[harshnathani]

Hi @Anonymous ,

See if these posts help

https://community.powerbi.com/t5/Desktop/PBI-Desktop-could-not-connect-to-SSAS/m-p/485188

https://docs.microsoft.com/en-us/power-bi/connect-data/desktop-ssas-multidimensional

https://docs.microsoft.com/en-us/power-bi/connect-data/desktop-analysis-services-tabular-data#:~:text=In%20Power%20BI%20Desktop%2C%20on,mode%2C%20and%20then%20select%20OK.

Regards,

HN