Forum Discussion

Mithraveer's avatar
Mithraveer
Frequent Visitor
1 year ago

Power BI report server points to Old database when automatic refresh kicks in

Hi,   We have a on-premise Power BI report server and have hosted a number of power bi dashboards in here. All the PBI dashboards are sourced in a oracle database. Recently we moved to a new Oracle...
"Power BI Report Server"
Mithraveer's avatar
Mithraveer
Frequent Visitor
1 year ago

Hi Anonymous ,

 

Thanks a milion for your response,

 

I checked the link you provided. It has a note stating that this only works for DirectQuery. But whenever I add the Oracle database in my PBI Desktop it only enables the Import options in the Data Connectivity mode and not the DirectQuery as shown below. So will this cause any issues ? Kindly advice.

 

Kind regards,

Mithra

 

Anonymous's avatar
Anonymous
Not applicable
1 year ago

Hi,Mithraveer .Thank you for your reply.
Thank you for your reply.
According to the documentation, the way I provided is currently only applicable to direct query, while for import connection mode, Microsoft is under development (in the process of launching).
For the data source connection mode, I do not recommend you to change it directly, because the change of data connection mode will lead to a lot of functionality limitations, in short, this document does not seem to be suitable for you at the moment, and I recommend you not to try to change the data source connection mode either. This is likely to cause unexpected situations.
I will continue to follow up with you on this current issue and will keep you informed of any suitable developments.

Thank you for your understanding.

I hope my suggestions give you good ideas, if you have any more questions, please clarify in a follow-up reply.
Best Regards,
Carson Jian