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?
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 .
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.
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 .