Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
We currently use Power BI Embedded to provide access to Power BI Dashboards and Reports that are built off of SSAS Tabular cubes. The Gateway, Data Source setup and Row Level Security work great. Internally when we create the initial dashboards and reports we have to do the following for our dashboard designers:
1) Setup them up with VPN accounts
2) Create a Run AS script to Launch Power BI Desktop with their user account on the server.
3) Provide the connection information -
Although not ideal this is workable for internal users.
For External users - we purchase and assign a Power BI Pro license to the designated person at the our client. They use that account to create and manage reports and dashboards with the Power BI Service. However we often get requests from users to use Power BI Desktop to design reports. Ideally the MSMDPUMP.dll which is used to connect to the SSAS Tabular cubes via Excel and Tableau would also work for Power BI Desktop. We have not been able to get this to work. Attempting to LIVE CONNECT to SSAS Tabular cubes results in the following error:
So three questions:
1) Is this supported? If not why are we can Tableau users able to connect via MSMDPUMP but not PBI Desktop users to SSAS Tabular cubes.
2) If this is supported what am I doing wrong? (the specific MSMDPUMP.dll URL works in Excel. The PBI Desktop application is being launch via a RUN AS USER command with the same credentials that are used to connect in EXCEL / Tableau.
3) Is there another way to accomplish what I am trying to do which is allow external users connect to SSAS tabular cubes via MSMDPUMP instead of setting them up with VPN accounts?
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.