Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago

PowerBI Service - Scheduled Refresh

Hi    I've been trying to schedule refresh a report which works perfectly on PowerBI desktop (Ignore privacy level setting).  PowerBI service  has been throwing the following error when I refresh t...
Need Help
AlexDantin's avatar
AlexDantin
Helper I
5 years ago

I have several datasets that were working fine, now suddenly all my credentials were invalid and getting several different error messages like the above when trying to refresh using the Personal Gateway (which new version has come out and I have uninstalled and re-installed) -

Underlying error code-2147467259
Underlying error messageInformation is needed in order to combine data
DM_ErrorDetailNameCode_UnderlyingHResult-2147467259
Microsoft.Data.Mashup.MashupSecurityException.DataSources[{"kind":"Odbc","path":"dsn=[connect_string]"},{"kind":"File","path":"O:\\[file_info].xlsx"}]
Microsoft.Data.Mashup.MashupSecurityException.ReasonPrivacySetting
Cluster URIWABI-US-NORTH-CENTRAL-H-PRIMARY-redirect.analysis.windows.net
Activity ID1cff351d-839d-462f-ba04-694ea2365b7a
Request ID7014232d-23bc-7cc8-87a7-bde4968496e6
Time2021-06-10 13:26:38


a prior message spoke about "need to rebuild the data source"

 

none of these were an issue previously.

AlexDantin's avatar
AlexDantin
Helper I
5 years ago

none of the proscribed solutions helped. I had to adjust the connection string to our PostGRES AWS db in order to enable the refresh to occur.