SAP BW connection to Power BI with Direct query with some dimension tables from excel.

[NikhilChenna]

Hi Everyone, 

@amitchandak

@Greg_Deckler 

@Mikelytics 

@Pragati11 

@mangaus1111 

@FreemanZ 

@aj1973 

@v-frfei-msft 

I want to understand can we create a Power BI report where our data connectivity mode is both direct query and import?

1. My main data is coming from SAP BW and I want to connect it through Direct query mode.

2. I have few dimension tables which are Excel files in a Sharepoint folder and I want to connect it through import mode.

Is this possible?? If yes, can you please share some links or sources that would be really helpful.

Regards, 
Nikhil Chenna 

[aj1973]

@NikhilChenna 

Yes it possible, please refer to this

https://community.fabric.microsoft.com/t5/Desktop/can-i-combine-direct-query-and-import-in-a-power-b....

https://learn.microsoft.com/en-us/power-bi/transform-model/desktop-composite-models

[NikhilChenna]

Hi @aj1973 ,

Thank you for replying..

I'm connected to SAP BW it is a OLAP source, check the attached image I have already connected to a SAP BW through direct query and then if i go to Get data option all the options are greyed out.

Regards,

Nikhil Chenna

 

[aj1973]

@NikhilChenna 

Looks like you are in Live connection mode, therefore your model falls into this limitations

[NikhilChenna · Accepted solution]

Hi @aj1973 , 

Yes, I have connected to SAP BW Application server through Direct Query and that's why I think we are not able to connect to other sources. 

Thank your for help..

Regards,

Nikhil Chenna

[aj1973]

Welcome