cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
hassieidris
New Member

Report fails to connect to data server

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.

Screenshot 2020-09-28 082152.jpg

Kind regards,

Hasaan 

1 REPLY 1
FarhanAhmed
Super User
Super User

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? 

 







Did I answer your question? Mark my post as a solution! Appreciate your Kudos!!

Proud to be a Super User!




Helpful resources

Announcements
Carousel_PBI_Wave1

2023 Release Wave 1 Plans

Power BI release plans for 2023 release wave 1 describes all new features releasing from April 2023 through September 2023.

Power BI Summit Carousel 2

Global Power BI Training

Make sure you register today for the Power BI Summit 2023. Don't miss all of the great sessions and speakers!

BizApps LATAM 2023

Business Application LATAM Summit 2023

Join the biggest FREE Business Applications Event in LATAM this February.

Power Platform Bootcamp

Global Power Platform Bootcamp

In this bootcamp we will deep-dive into Microsoft’s Power Platform stack with hands-on sessions and labs, delivered to you by experts and community leaders.