Forum Discussion

cheskafausto's avatar
cheskafausto
Frequent Visitor
8 years ago

direct query dashboard , report,dataset not refreshing

Hi Everyone,   I am using powerbi desktop to direct query a 12cr2 Oracle database. When I manually refresh on the desktop, it refreshes.    I published a simple graph onto the powerbi service, th...
Need Help
Show and Tell
Tutorial Requests
Anonymous's avatar
Anonymous
Not applicable
8 years ago

cheskafausto,

Please replace the localhost with machinename/servername in connection string of Power BI Desktop and gateway.

In addition, are you able to connect to the Oracle database using the credential in Oracle client such as SQL developer? Make sure the Oracle client is installed on the same machine as gateway.

Regards,
Lydia

cheskafausto's avatar
cheskafausto
Frequent Visitor
8 years ago

Hi Lydia, 

 

Apologies for not having update this thread. 

 

I have already got it to work. I had to install the latest ODAC tools, restarted my computer and I used the connection string I defined in the TNSnames.ora during the installation. 

 

I am able to refresh now manually on my report in the powerbi service, however when i tried to setup the scheduled refresh, it won't refresh the visuals on the report as stated on the schedule. The refresh history would say that the refresh is complete. 

 

I have also been reading about the on-premise gateway and direct query with data sources and I should not even be needing to schedule the refresh, just as long as I "interact" with the visuals, it will automatically update the data. here is what i read: https://docs.microsoft.com/en-us/power-bi/refresh-data#live-connections-and-directquery-to-on-premises-data-sources

 

Also, what is meant when they say interact? Does interacting mean just by clicking on the visuals? using a slicer that is related to the said visual? please enlighten me 

 

 

Related content