Forum Discussion

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