Forum Discussion
Power BI Report Server doesn't refresh data from IBM DB2
speranzaa wrote:
the refresh process doesn't work, or better, clicking on the Refresh link nothing happens.
The refresh link on the report is really only useful for reports in Direct Query mode, it only tells the visuals to requery the model. It does not do a data refresh for a model in import mode.
speranzaa wrote:
I also tried to use the scheduled refresh, with no result...
On my client I have installed the IMB DB2 ODBC driver. Am I missing something to set at Power BI Report Server level?
What do you mean by "no result". Was there an error in the refresh or did it say it completed successfully? Have you installed the DB2 client driver on the Report Server as this is not a part of the default install and would be required to do a scheduled refresh against DB2.
speranzaa wrote:
the refresh process doesn't work, or better, clicking on the Refresh link nothing happens.
The refresh link on the report is really only useful for reports in Direct Query mode, it only tells the visuals to requery the model. It does not do a data refresh for a model in import mode.
speranzaa wrote:
I also tried to use the scheduled refresh, with no result...
On my client I have installed the IMB DB2 ODBC driver. Am I missing something to set at Power BI Report Server level?
What do you mean by "no result". Was there an error in the refresh or did it say it completed successfully? Have you installed the DB2 client driver on the Report Server as this is not a part of the default install and would be required to do a scheduled refresh against DB2.
Hi,
thanks a lot for your reply.
Most probably, the problem, as you mentioned in your second reply, is that we didn't still install the DB2 client driver on the Report Server. I am still waiting the installation, to see if the refresh will work properly from report server.