Report fails to connect to data server

[hassieidris]

Good day

I have been stuck with this issue for the past couple of days. I am building powerBi reports as part of my job using direct queries and accessing data from a SQL server. Before everytime i would open up the report powerBI would have a pop up asking to validate the data and i would click 'ok' and the report would work. Ihave not changed any credentials or settings but for some reason that pop up does not come up and the model opens but then i get the error shown in the following screenshot, cannot find any fix online, any assistance would be greatly appreciated.

Kind regards,

Hasaan 

[FarhanAhmed]

Looks like a permission issue on the Data source side.

What is your actual data source? Are you able to access this database in your machine on other applications? like SSMS or Excel?

Can you please check whether the user that is being used in the model has the proper permissions to database or tables?

Is this happening when you open your report on the PBIRS desktop?