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
cheskafausto's avatar
cheskafausto
Frequent Visitor
8 years ago

Hi Bajee and Lydia, 

 

I tried deleting dataset and dashboards and republishing the pbix, but it still wouldn't refresh!

 

I tried now checking the gateway settings. All seemed ok, since it states that it is connected as shown below in the 1st pic. 

 

 

I tried to re enter my credentials and pressed apply. It would state that connection was successful BUT i noticed that the apply button was not greyed out ( like it has not applied the settings yet). So, I cliccked apply AGAIN, then an error popped out in the 2nd picture. 

 

The credentials I entered are that of the database i am using currently. I have other client softwares that are working on that database using the same credentials, so i doubt that it has anything to do with the invalid credentials.

1st2nd

 

 

 

when i expanded the error it showed the following :

 

Unable to connect: We encountered an error while trying to connect to localhost:1522/XE. Details: ""Hide details
Activity ID: 0556cf93-a495-417d-a8af-2d6a21875697
Request ID: f751ecc2-53e5-ea01-7d40-8b5224102068
Cluster URI: https://wabi-south-east-asia-redirect.analysis.windows.net
Status code: 400
Error Code: DMTS_UpdateClusterDatasourceCredentialsErrorCode
Time: Wed Jan 10 2018 09:40:38 GMT+0800 (Malay Peninsula Standard Time)
Version: 13.0.3671.248
forecast: Invalid connection credentials.
Underlying error code: -2147467259
Underlying error message: The credentials provided for the Oracle source are invalid. (Source at localhost:1522/xe.)
DM_ErrorDetailNameCode_UnderlyingHResult: -2147467259
Microsoft.Data.Mashup.CredentialError.DataSourceKind: Oracle
Microsoft.Data.Mashup.CredentialError.DataSourcePath: localhost:1522/XE
Microsoft.Data.Mashup.CredentialError.Reason: AccessUnauthorized
Microsoft.Data.Mashup.MashupSecurityException.DataSources: [{"kind":"Oracle","path":"localhost:1522/XE"}]
Microsoft.Data.Mashup.MashupSecurityException.Reason: AccessUnauthorized

 

please advise. 

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