Get Data from two or more DataSources of SAP BW using DirectQuery

[amirmollaei1]

Hi experts,

I want to load load two or more DataSources to Power BI, but when I load the first DataSource using DirectQuery the Get data button beome disabled and I can't load the second one. Is there a limitation from SAP or Power BI? and can this limitation be lifted?

I have SAP BW 7.4, and Power BI Desktop RS (January 2022).

Thanks in advance

[amitchandak]

@amirmollaei1 , There are quite a few limitations

https://docs.microsoft.com/en-us/power-bi/connect-data/desktop-directquery-sap-bw

As this is treated as cube, I doubt you can add other sources

[amirmollaei1]

Thanks @amitchandak . Can you please explain a little more for me, I'm new in this area. Why when treated as cube we can't add any other sources?

[v-xiaotang · Accepted solution]

Hi @amirmollaei1 

yep, it has some limitations, please check the articles below,

Use composite models in Power BI Desktop - Power BI | Microsoft Docs

https://sqlserverbi.blog/2021/12/12/are-we-there-yet-composite-models-using-directquery-over-power-b...

Or you can try to change DQ mode to Import mode, however, please note that once it has been converted to import mode it cannot be converted back to DQ.

FYI: https://epmstrategy.com/power-bi-changing-storage-modes-ie-changing-from-direct-query-to-import/

Solved: How to Switch mode in PowerBI from Direct to Impor... - Microsoft Power BI Community

Best Regards,

Community Support Team _Tang

If this post helps, please consider Accept it as the solution to help the other members find it more quickly.