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!
Data Modeling
  • v-haibl-msft's avatar
    v-haibl-msft
    8 years ago

    hdigrandi

     

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

     

    Best Regards,
    Herbert

v-haibl-msft's avatar
v-haibl-msft
Microsoft Employee
8 years ago

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
8 years ago

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
    Microsoft Employee
    8 years ago

    hdigrandi

     

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

     

    Best Regards,
    Herbert