Forum Discussion
PowerBI Desktop using HTTP endpoint to connect an OLAP Cube... Why "Connect Live" isn't allowed?
Hi All,
After several hours following the HTTP configuration steps, reading the community posts and trying all the proposed solutions without success, creating, configuring and deleting several Azure VMs… I tried another approach to eliminating any Azure missing configuration. I created a VM locally running SQL SERVER 2016 SP1 dev edition and IIS 10, where I installed the HTTP data pump and Finally worked… I was able to connect Power BI Desktop to the Cube, getting all the metadata using the HTTP endpoint…
I believe the main issue was that our cube is running on SQL Server 2012.... and when using the Azure VMs with SQL Server 2016 SP1 to do my tests using the public IP address Power BI returned always the error shown in the previous post, maybe I miss some Azure configurations... (note if I'm in the Azure Machine and use the internal IP address the HTTP endpoint works)
Before you start using the Power BI Desktop connection live with the HTTP endpoint you need to add a Windows credential with the user and password required by the HTTP end point….
Please got to Control Panel > User Accounts > Credential Manager, and click “Add a Windows Credential”,
After I have the HTTP data pump working and create the first Report using Power BI Desktop Edition I tried to Publish it to the Power BI Service, but once is an Analysis Services on- premises... I needed to install the Power BI on-Premisses Gateway... to do that I added to the VM the AD Role... after promoting the VM to a domain controller and set the gateway configuration, everything worked fine... :)
the following image depicts all components together,
Now, the Power BI on-premisses Gateway working with the HTTP endpoint:
Finally, the dataset using the gateway always up to date,
Hope this information helps others with the same issue I had ;)
Cheers, Luis
Hi All,
sorry only now reply, but I needed to refresh my mind and repeat the POC to have 100% sure that it works, so the conclusion is... it works!!!... (against what Microsoft told you ;)).... apart from all the information already posted, the only thing you need to do is enable the Windows Authentication of your OLAP web application on IIS, (maybe because SSAS only works with Windows Authentication ?????)
If you have created a new Windows Credential on your laptop with an Admin User of the SSAS Server that you want to connect via http endpoint,
You will be able to connect the Cube with an HTTP endpoint using the Connect live option:
Hope this helps, if you have other questions please let me know.
Cheers, Luis
Hi Luis,
Thanks for your prompt reply. I see that you have both Basic and Windows Authentication enabled on your virtual directory and perhaps that is what was missing from my set up.
I will give that a try and post back with my outcomes.
Thanks for your help so far.
Hitesh
Hi Luis,
So, yes I was able to confirm and get Power BI Desktop to connect to OLAP cube using HTTP, but it doesnt seem to work with HTTPS.
Are you aware of any such issues? Have you tried using HTTPS?Thanks,
Hitesh