Forum Discussion

hdigrandi's avatar
hdigrandi
New Member
8 years ago
Solved

Change datasource for a dashboard

Hi experts,

 

I have SAP Hana FI Accounts receivable and sales on an Informix data base.

 

Can I load both data bases and relate say by customer code?

 

thank you!

  • hdigrandi

     

    I don't have an Informix on my side, but this should be possible using Import mode.

     

    Best Regards,
    Herbert

3 Replies

  • v-haibl-msft's avatar
    v-haibl-msft
    Icon for Microsoft Employee rankMicrosoft Employee

    hdigrandi

     

    Does the topic title related to your description? Hope I understand your requirement properly. You can get data from SAP Hana and Informix in one PBIX file using Import mode. Then you can create relationship between related tables from using the customer code column.

     

    Best Regards,
    Herbert

    • hdigrandi's avatar
      hdigrandi
      New Member

      v-haibl-msft

       

      Herbert,

       

      Correct, your re wording explains precisely what I am trying to research, is it possible?

       

      You can get data from SAP Hana and Informix in one PBIX file using Import mode. Then you can create relationship between related tables from using the customer code column.

       

      cordially,

       

      Héctor J. Digrandi

      • v-haibl-msft's avatar
        v-haibl-msft
        Icon for Microsoft Employee rankMicrosoft Employee

        hdigrandi

         

        I don't have an Informix on my side, but this should be possible using Import mode.

         

        Best Regards,
        Herbert