Change datasource for a dashboard

[hdigrandi]

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!

[v-haibl-msft]

@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]

@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 · Accepted solution]

@hdigrandi

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

Best Regards,
Herbert