How can we make it easier for our users to set up a connection to a SSAS-cube via Analysis Services?

[niklas3000]

Hi!

We need to set up a solution where users can connect with power bi to the SSAS-cube that they choose.

It is a bit hard for them the choose the right source type, type the server name, and choose model. We aslo have both tabular and multi-cubes that are on two diffrent servers.

Is there a Users Freindly to allow the users to choose cube via a file? Or is there other ways that is easier than to set up a connection to a Analysis Services-connection?

[v-lili6-msft · Accepted solution]

hi, @niklas3000

     You may try to create a PBIT file as a template and share with them。

for example:

you can connect to a SSAS-cube via Analysis Services and select the related content,

then click File->Export->Power BI template to create a PBIT file.

You can share the pbit with them, and they don't need to choose the right source type, type the server name, and choose model.

If source or type or model has changed, you just need to recreate the pbit file and share with them.

Best Regards,

Lin

[niklas3000]

Thanks!

I thought about saving an pbix-file as a template, but this will work better, because: 1) no risk that users saves over the the template-file by mistake with the report they are making 2) i dont think that a template file will get outdated when new versions of pbi desktop are released.