cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
stevo Frequent Visitor
Frequent Visitor

Publish to web with SSAS data source

Hi, Can anyone help with me a couple of questions regarding embedding a report that uses SSAS mutildimenisonal data source:

 

1. Will it be real-time as per running the rpeort from the web app? If not how often will it be updated?

2. Which credentials will it use to access the datasource when running the report. In the web app it uses the login user credentials to access analysis services but if it's in a public website how would this work?

 

Thanks!

6 REPLIES 6
mitsu Member
Member

Re: Publish to web with SSAS data source

Currently Publish to web is not supported for dashboards created on the SSAS live connection . 

 

You can integrate Power BI tile or report into an app as explined in the link below :

 

https://powerbi.microsoft.com/en-us/documentation/powerbi-developer-integrate-a-power-bi-tile-or-rep...

 

the users accessing the same would get authnticated on SSAS using the effective user name. 

 

Hope this helps .

 

Regards,

Mitsu

 

 

stevo Frequent Visitor
Frequent Visitor

Re: Publish to web with SSAS data source

Thanks Mitsu, do you know if there's any plan to allow publish to web with ssas data source in the future?

 

Thanks!

mitsu Member
Member

Re: Publish to web with SSAS data source

Not sure on that . Some one from  MS Power BI team will have to comment on it . Pesonally I do not think that would be a high prioity Item for MS Power BI team , SSAS being an entrprise source the data from that being published to web does not seem to be a popular requirement .

stevo Frequent Visitor
Frequent Visitor

Re: Publish to web with SSAS data source

Ok thanks, just to clarify then, if I wanted to display a report (using ssas) on an intranet site that we would want every employee to be able to view we would need a power bi pro license for each employee and they would all need access to analysis services?

 

Just seems a bit costly, say if we have 500 employees and we just want the majority of them to view one report.

 

Thanks

mitsu Member
Member

Re: Publish to web with SSAS data source

Yes, that could get a bit costly for One Dashboard. However you should look at getting the same created using the power BI free feature . You will not be able to use the live connector but you can import data in PBI desktop from SSAS and schedule the refresh for the same once a day . 

stevo Frequent Visitor
Frequent Visitor

Re: Publish to web with SSAS data source

Yep good idea, could I use the publish to web using that method? Or would it mean signing up 500 Power BI free accounts?

 

Thanks

Helpful resources

Announcements
New Kudos Received Badges Coming

New Kudos Received Badges Coming

Kudos to you if you earned one of these! Check your inbox for a notification.

Microsoft Implementation for Communities Wins Award

Microsoft Implementation for Communities Wins Award

Learn about the award-winning innovation that was implemented across Microsoft’s Business Applications Communities.

Power Platform World Tour

Power Platform World Tour

Find out where you can attend!

Top Solution Authors
Top Kudoed Authors (Last 30 Days)
Users online (3,610)