Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
11 months ago
Solved

Problem with refresh and scheduled refresh in PowerBi service.

Hi whenever i refresh my semantic model, it throws this error. Anyone knows how to fix it? I have set up gateway to access the data source which is stored in SQL server.    Data source error: [Val...
  • arvindsingh802's avatar
    11 months ago

    it looks you account does not have correct access

    Microsoft SQL: The SELECT permission was denied on the object 'new_contractproduct', database 'SGH_MSCRM', schema 'dbo'.[/ccon]"}},

     

    Validated you are using same credentials that is working fine in desktop