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
gabimuenster's avatar
gabimuenster
Microsoft Employee
4 years ago

Hi,

the user you are using to access the SQL data source is missing EXECUTE permissions on the user-defined function udf_StripHTML that is used somewhere in the data source artifact. Please make sure you are using the user to authenticate or contact your database admin to grant required permissions.

  • 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.