Forum Discussion

VRENEE's avatar
VRENEE
Frequent Visitor
8 years ago

Problems retrieving data on prem via gateway connection to SSAS Tabular

Hello everybody   I need your help. Try to deploy tabular model with SSDT tools on AZURE and use the GATEWAY. This Gateway is able to retrieve metadata. On SSDT I am able to import data from ORacl...
Need Help
v-juanli-msft's avatar
v-juanli-msft
Icon for Community Support rankCommunity Support
8 years ago

Hi VRENEE

Do you connect to Azure Analysis services database within Power BI Desktop, then publish it to Power BI Service? While the the data in Azure is deployed with SSDT tools on AZURE from ORacle database.

If so, you need to  give the azure credential under connetions when managing the gateway in powerbi.com.

As for the error with mashup process when  deploying tabular model with SSDT tools on AZURE and using the GATEWAY, you'd better post on the Azure community to get better answer.

 

Best regards

Maggie

  • VRENEE's avatar
    VRENEE
    Frequent Visitor
    8 years ago

    Hello Maggie

     

    Thanks for answer. 

    My issue is resolved - just for this part. 

    Just to give explanations and overview on the whole process :  

    The problem was the Gateway was under my O365 subscription - so my active directory. And the guy from MICROSOFOT I am working with was unknown from my AD and unfortunately I was also unknown from his AZURE subscription where the SSAS cube has been settled. So he invited me and now he can see the gateway. Now the next problem is that ORACLE credential are OK from my side with SSDT tools but when deploying the solution credentials are lost. We found a solution where it explains to modify connexions  with SSMS tools ..... what a pity ! Proxy problems for now :-(.  

     

    Thanks again. 

    Best Regards

     

    Valérie RENEE.