How can I connect my HDI Container of my SAP Hana Cloud with my SAP Datasphere?

[vinicius_anjos_inacio]

Hi everyone,

I need help with this problem. I need to extract some data from an HDI Container in my Hana Cloud to use in my PowerBi. However, I cannot access the data because it says I don't have permission. I have already tried to use the SAP Data Datasphere trial. So, here is my question: how can I connect my HDI Container in my SAP Hana Cloud with SAP Data Intelligence? All my accounts are free, so is there some problem? I created this HDI Container with the SAP BAS.

[ghennac · Accepted solution]

Hello, my understanding is that you already tried to connect from power bi to hana cld and it worked you just got insufficient privileges, right?
If yes , then the way i solved this issue, you have to create a hdbrole in your project which would have sufficient privileges on that hdi. Then login in database cockpit with dbadmin and assign that role to the user which you're using for connection. 
Normally i would assume it solves your issue.