Starting December 3, join live sessions with database experts and the Microsoft product team to learn just how easy it is to get started
Learn moreGet certified in Microsoft Fabric—for free! For a limited time, get a free DP-600 exam voucher to use by the end of 2024. Register now
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!
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 :
the users accessing the same would get authnticated on SSAS using the effective user name.
Hope this helps .
Regards,
Mitsu
Thanks Mitsu, do you know if there's any plan to allow publish to web with ssas data source in the future?
Thanks!
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.
Thanks
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 .
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
Starting December 3, join live sessions with database experts and the Fabric product team to learn just how easy it is to get started.
March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount! Early Bird pricing ends December 9th.
User | Count |
---|---|
29 | |
12 | |
12 | |
11 | |
8 |
User | Count |
---|---|
54 | |
27 | |
15 | |
14 | |
13 |