Forum Discussion

3 Replies

  • v-kelly-msft's avatar
    v-kelly-msft
    Icon for Community Support rankCommunity Support
    6 years ago

    Hi adeelnazir786 ,

     

    Try to use the web API to connect the data source,steps are as below:

     

    In desktop, Go to Home > Edit Queries > Advance Editor. Here is some Power Query code to issue a GET request to an API endpoint.

     

     

    Best Regards,

    Kelly

    • adeelnazir786's avatar
      adeelnazir786
      Icon for Helper I rankHelper I
      6 years ago

      v-kelly-msft 

      Please guide in detail if i'm in wrong direction

      I dont want to prefer use of api, as we have big data, through this way we have to create all ETL, Modeling and warehousing on Power BI which leads to slowness.

      First we want to load in some data warehouse like in Alibaba Cloud MaxCompute is available for that, then load data into some RDBS tables (Like apsara rds) then use in power bi.

       

      • v-kelly-msft's avatar
        v-kelly-msft
        Icon for Community Support rankCommunity Support
        6 years ago

        Hi adeelnazir786 ,

         

        If so, you need to create a custom connector first,as  power bi doesn't have an existing connector for Alibaba Cloud.

         

        For reference,pls click here.

         

        Best Regards,

        Kelly