topic Several Oracle Database With DirectQuery in Report Server

Several Oracle Database With DirectQuery

Anonymous — Tue, 19 Oct 2021 13:03:39 GMT

Hello dear community, 
I hope you are doing well.
I have a question about using DirectQuery and Power BI Report Server.
I would like to connect 2 Oracle tables as the source.
They are in 2 different databases. I looked on the community, I found an article from 2017 saying it was limited to a database put by clicking on the link, I no longer see this restriction (docs.microsoft.com/en-us/power-bi/connect-data/desktop-use-directquery#limiitations-of-directquery)
But when I try to connect to another table I have this message:
The data source you are trying to connect to is different from the existing DirectQuery data source. To continue, you must put all queries in Import mode, which can cause a large amount of data to be loaded.
I have the latest version of the Power BI ReportServer and the September 2021 version for the thick client.
Do you have an idea ?

Thank you 

Dimitri

Re: Several Oracle Database With DirectQuery

Anonymous — Fri, 22 Oct 2021 02:11:27 GMT

Anonymous

This limitation is removed in the Power BI Desktop normal version but not in the Power BI Desktop for RS version. For now, if you don't have very larges tables, you can just switch them to import mode.

Normal Desktop Version:

Desktop for RS version:

Paul Zheng _ Community Support Team
If this post helps, please Accept it as the solution to help the other members find it more quickly.

Re: Several Oracle Database With DirectQuery

Anonymous — Mon, 25 Oct 2021 11:29:13 GMT

Hello,

Thank you Paul.

Have a nice day