Forum Discussion
Power BI report server points to Old database when automatic refresh kicks in
Hi,Mithraveer .Thank you for your reply.
Have you tried to modify the connection string of the report, you mentioned that the oracle database name has not changed, but the hostname has changed, please try to modify the hostname in the connection string
If you can't modify the connection string properly, you can also do it via API.
Change data source connection strings with PowerShell - Power BI | Microsoft Learn
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
Hi Anonymous,
The connection string is automatically populated from my tnsnames.ora file. When I changed the alias in my connection string, it is working fine in my PBI Desktop, but not in the PBI Report server since the alias name comes into my connection string.
Also the connection string is automatically populated and not allowing me to add the server name in the Report server. Since both my report server and desktop are May 2020 version, I am not sure If I can use the Power shell method, you highlighted above.
Could you please let me know if there is a possibility to edit my tnsnames in such a way that it picks up the host name as well.
Thanks a million for your responses so far. Any more suggestions will be much helpful.
Kind Regards,
Mithra
Hi,Mithraveer .Thank you for your reply.
Given that your situation is unique and your repot server version is May 2020. So I have found the following relevant documentation which I hope will help you.
URL:
Change data source connection strings with PowerShell - Power BI Report Server pre-October 2020 - Power BI | Microsoft Learn
The reportserver version is very important, while changing your report server version is generally not recommended.
For your question: does the report server support editing your tnsnames so that it can also pick up hostnames.
The report server itself has a lot of limitations, so it is best to operate according to the official documentation itself to avoid data loss and other accidents. As for the report server's ability to recognize tnsnames, I suggest you contact your team's IT department and ask them to let you know if they are skilled in the use of power shells to avoid accidents.
You can try to modify the connection string of some databases to see if it works.
I hope my suggestions give you good ideas, if you have any more questions, please clarify in a follow-up reply.
Best Regards,
Carson JianHi 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
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