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 database. So I opened the dashboards in PBI desktop and updated the oracle database and it can point to the new oracle database successfully. I saved the updated PBI file and uploaded it into the PBI report server. But as soon as the scheduled refresh kicks in the PBI report server, the dashboard goes back to the old oracle database. The 

 

Is there a way to clear DB cache in the On premise PBI report server. Please advice.

 

Thanks in advance

Mithra

"Power BI Report Server"

10 Replies

  • Anonymous's avatar
    Anonymous
    Not applicable
    1 year ago

    Hi,Mithraveer .I am glad to help you.
    Please try to clear the data source and credentials information in Power BI Dektop and reopen the pbix file that is causing the problem and remove the pbix file from your report server.
    Restart Report Server Configuration Manager and re-upload the report from Desktop to your report server.
    Take care to modify the Connection string in the report DataSource to make sure it points to the new Oracle database, not the old one.
    Sometimes clearing the cache may solve the refresh issue, please try clearing your browser cache.

    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,
    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

    • Mithraveer's avatar
      Mithraveer
      Frequent Visitor
      1 year ago

      Hi Carson, 

       

      Thanks a million for your response back to my query. I tried the exact sequence of steps as mentioned in your solution. 

      1. Open the file in PBI Desktop. Cleared cache from the Options --> Data Load menu. Cleared Permissions from the data source settings. Saved the file an closed it.

      2. Reopened the file, hit refresh and gave the credentials and the report refreshed correctly pointing to the New database. This report refreshes correctly everytime I refresh it in the PBI Desktop. Saved the report

      3. Cleared all the existing files from the PBI RS

      4. Logged into the PBI RS and Opened Report Server Configuration Manager. Stopped and Started services.

      5. Now refresh the PBI RS website and uploaded the latest file as per step 2. When I upload it, it shows the latest data. Then I confirm the DB details and save the successful connection. Then I setup the automatic refresh. 

       

      But still as soon as the first automatic refresh/refresh now option kicks in, the report goes back to the old Database again. 

       

      I also took a backup and deleted the Encryption key in the Report server Configuration Manager in the same sequence as above. But still the report is pointing to the old database.

       

      One thing to note here is the service name of the old and new oracle database are the same and only the host name has changed. So not sure if this is causing the issue.

       

      Kindly let me know what else I could try in this instance.

       

      Kind Regards,

      Mithra

       

      • Anonymous's avatar
        Anonymous
        Not applicable
        1 year ago

        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