Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
4 years ago

Please help me on schedule refresh error

Data source error: {"error":{"code":"DM_GWPipeline_Gateway_MashupDataAccessError","pbi.error":{"code":"DM_GWPipeline_Gateway_MashupDataAccessError","parameters":{},"details":[{"code":"DM_ErrorDetailN...
Need Help
Show and Tell
Anonymous's avatar
Anonymous
Not applicable
4 years ago

Hi gabimuenster,

 

I was using same database for other reports which are working fine and refreshing daily.If there is any other solution please suggest,Thank you.

gabimuenster's avatar
gabimuenster
Microsoft Employee
4 years ago

Hi Anonymous ,

using the same database is not necessarily leading to an error. The question is, if you are using the same database objects in all the reports. For example, the user defined function might be used in view A in the database, but not in view B. If you would use view A only in the report that fails to refresh, and use view B in all other reports, that would be a logical explanation. Can you please check if there are database objects in only the report that fails refreshing? If so, my assumption is that the function is used in one of those objects, and the sql login still would require execute permissions on that function.