refresh a dataset within a workspace

[Anonymous]

hi

please help, nhs pbi developer

my app refreshed fine on the desktop

published to a workspace and made sure the gateway management is ok

... however when i attempt to refresh from within the workspace (i am looking to automatethe refreshing)

... the refresh keeps failing, different tables each time, it appears to be trying to access a database that is not even referred to in my queries

please help, struggling nhs pbi developer

Krs, Clive

[v-cazheng-msft]

Hi @Anonymous ，

May I know if you refresh your dataset manually by on-demand refresh, will you get same issue? Did you get any refresh errors info that containing request id, timestamp, activity id and cluster in the refresh history of your dataset?

Best Regards,

Community Support Team _ Caiyun

[Anonymous]

Hi v, thanks for reaching out.

The errors occur wether the refresh is scheduled or ad hoc.

Heare is an example of the error message:

An error occurred while processing the data in the dataset.

Refresh failed:

TRC_SimplePeriodMetricsNoFriends has failed to refresh.
Failure details: The last refresh attempt failed because of an internal service error. This is usually a transient issue. If you try again later and still see this message, contact support.

{"error":{"code":"DM_GWPipeline_Gateway_MashupDataAccessError","pbi.error":{"code":"DM_GWPipeline_Gateway_MashupDataAccessError","parameters":{},"details":[{"code":"DM_ErrorDetailNameCode_UnderlyingErrorCode","detail":{"type":1,"value":"-2147467259"}},{"code":"DM_ErrorDetailNameCode_UnderlyingErrorMessage","detail":{"type":1,"value":"<pi>Microsoft SQL: The server principal \"PIMS_Reporter\" is not able to access the database \"BlitheSystem\" under the current security context.</pi>"}},{"code":"DM_ErrorDetailNameCode_UnderlyingHResult","detail":{"type":1,"value":"-2147467259"}},{"code":"Microsoft.Data.Mashup.ValueError.Class","detail":{"type":1,"value":"14"}},{"code":"Microsoft.Data.Mashup.ValueError.DataSourceKind","detail":{"type":1,"value":"SQL"}},{"code":"Microsoft.Data.Mashup.ValueError.DataSourcePath","detail":{"type":1,"value":"hvsqlicts03;BCSCore_Lilie"}},{"code":"Microsoft.Data.Mashup.ValueError.ErrorCode","detail":{"type":1,"value":"-2146232060"}},{"code":"Microsoft.Data.Mashup.ValueError.Message","detail":{"type":1,"value":"The server principal \"PIMS_Reporter\" is not able to access the database \"BlitheSystem\" under the current security context."}},{"code":"Microsoft.Data.Mashup.ValueError.Number","detail":{"type":1,"value":"916"}},{"code":"Microsoft.Data.Mashup.ValueError.Reason","detail":{"type":1,"value":"DataSource.Error"}}],"exceptionCulprit":1}}} Table: KPI27d.

Next refresh for TRC_SimplePeriodMetricsNoFriends is scheduled for February 28, 2022 17:30 UTC.

addditional notes:

1.I have approx 30 tables in the dataset

2.I though there maybe a limit on the number of tables so reduced the count - made no difference

3.The database in use is BCSCore_Lilie, no data being used in BlitheSystem

4.The table referenced inthe message changes, (e.g. KPI27d pops up a lot as do some others), very confusing - as the SQL looks very similar to the there i.e. nothing special about it 

my name is Clive, i am working for the NHS and i think in order to equalize the NHS, the NHS needs to GO digital much quicker than it is doing at the moment, how about yourself v?

Thank you

H & SC DATA Analyst

There is no Person/Patient Identifiable Data (PID) in the email

[v-cazheng-msft]

Hi @Anonymous ，

Thanks for your reply! May I know whether this report dataset is in a Shared workspace or Premium workspace(For Premium workspace, there will be a diamond icon besides the workspace name)? Could you please try to download your report related to this dataset as a pbix file and try to refresh it in Power BI Desktop to see whether you will refresh successfully? This operation can help us learn whether there is any error in the report itself will cause the refresh failure. Thanks in advance!

Best Regards,

Community Support Team _ Caiyun

[Anonymous]

Thanks for staying connected.

The diamond is visible.

The pbix  refreshes ok using desktop PowerBI.

Krs

[Anonymous]

==========

this has now been sorted, a database view was referring to data in another database which i did not have access to, this has now been sorted thanq

[v-cazheng-msft]

Hi @Anonymous ,

Thanks for your reply! Noted with thanks.

Best Regards,

Community Support Team _ Caiyun

[v-cazheng-msft]

Issue is caused by referring  to data in another database that is no permission.