cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
Helper III
Helper III

There was a data source access error in Power BI Service

Hi, hope you could help or explain.

There is a report using Direct Query to SQL server and on the desktop it is
fine and refreshes successfully. When we publish it to service unable to see any visuals.
We tried to map to the Gateway as well as not to. Still same issue. Any ideas ?

 

Service error.JPG

1 ACCEPTED SOLUTION

Accepted Solutions
Highlighted
Microsoft
Microsoft

Re: There was a data source access error in Power BI Service

Hi @aleksandra_stan ,

 

Sorry for my late reply...

Since the refresh operation could be implemented in the Desktop, it means that there is no problem with the data source itself.

In my opinion, the high probability is that the gateway configuration is incorrect. You could follow these steps for trouble shooting:

 

1.Please restart the Gateway(enterprise version) firstly to make sure the gateway is online and you could use it.

2.Ensure that each data source has been configured gateway.

3.Perhaps the server/ database name or the credentials has been changed ,so re-enter the basic information in Date Source Setting (pay attention to the Authentication Method)

 

You could take a look at this blog for detailed information.

  

Did I answer your question ? Please mark my reply as solution. Thank you very much.

If not, please upload some insensitive data samples and expected output.

 

Best Regards,

Eyelyn Qin

View solution in original post

2 REPLIES 2
Highlighted
Microsoft
Microsoft

Re: There was a data source access error in Power BI Service

Hi @aleksandra_stan ,

 

Sorry for my late reply...

Since the refresh operation could be implemented in the Desktop, it means that there is no problem with the data source itself.

In my opinion, the high probability is that the gateway configuration is incorrect. You could follow these steps for trouble shooting:

 

1.Please restart the Gateway(enterprise version) firstly to make sure the gateway is online and you could use it.

2.Ensure that each data source has been configured gateway.

3.Perhaps the server/ database name or the credentials has been changed ,so re-enter the basic information in Date Source Setting (pay attention to the Authentication Method)

 

You could take a look at this blog for detailed information.

  

Did I answer your question ? Please mark my reply as solution. Thank you very much.

If not, please upload some insensitive data samples and expected output.

 

Best Regards,

Eyelyn Qin

View solution in original post

Highlighted
Helper III
Helper III

Re: There was a data source access error in Power BI Service

@Eyelyn9 , thank you.

 

We sorted it out. Appears that the select was pretty complex and included couple of diffrent DB's. So by fact it was single query but gateway was confused since there was 2 data sources. We switched it to a single view and now it is working fine.

Helpful resources

Announcements
Community Conference

Power Platform Community Conference

Check out the on demand sessions that are available now!

Upcoming Events

Experience what’s next for Power BI

See the latest Power BI innovations, updates, and demos from the Microsoft Business Applications Launch Event.

secondImage

Power Platform 2020 release wave 2 plan

Features releasing from October 2020 through March 2021

Get Ready for Power BI Dev Camp

Get Ready for Power BI Dev Camp

Mark your calendars and join us for our next Power BI Dev Camp!.