Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!

Reply
hdigrandi
New Member

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!

1 ACCEPTED SOLUTION

@hdigrandi

 

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

 

Best Regards,
Herbert

View solution in original post

3 REPLIES 3
v-haibl-msft
Employee
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

@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

@hdigrandi

 

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

 

Best Regards,
Herbert

Helpful resources

Announcements
April AMA free

Microsoft Fabric AMA Livestream

Join us Tuesday, April 09, 9:00 – 10:00 AM PST for a live, expert-led Q&A session on all things Microsoft Fabric!

March Fabric Community Update

Fabric Community Update - March 2024

Find out what's new and trending in the Fabric Community.