Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!

Reply
Anonymous
Not applicable

Cannot refresh from PBI portal: Unable to connect to the data soruce undefined ERROR MESSAGE

During the past two weeks, two PBI reports that use MS SQL as a data source do not refresh from our Power BI portal. Each of these reports use an embedded SQL script that points to a single SQL database and table. We have similar PBI reports that do not suffer from the same issue. We have tried deleting/republishing the reports and gateways, changing the privacy settings, etc. but nothing works. The related gateways confirm that the connection works, and from the desktop versions these reports refresh without issue. Therefore, this seems like a PBI bug. The workspace and report details follow:

 

Workspace/Report:

1) PBI AR & Billing / Cognos Customer Billing Performance

2) PBI RightFax / Call Manager Faxes

 

Thanks in advance for any help you can offer.

 

Regards,

John

6 REPLIES 6
Aron_Moore
Solution Specialist
Solution Specialist

We have the same issue.

We have a ticket open with MS and the tech says: "I still think this is the known gateway bug, we will have to wait until the new gateway is released in april."

We have the same issue as well. I've updated to the new gateway and still getting the "unable to connect to the data source undefined" error. Has your ticket been update @Aron_Moore ?

We updated the gateway April 26th.

 

We had two failures since then, but not every day like it was before.

 

We've closed our ticket.

Thanks for the reply Aron. Apart from updating your gateway, was there anything else you had to change?

We did not make any other changes.


The version of the gateway we have insalled now is 3000.3.138 (2019-04-09)

Anonymous
Not applicable

We are still having refresh failures for certain reports; this has been happening before and since April 26. I have tried republishing, reconfiguring the gateway etc. but nothing works. The gateway connections themselves work fine, and refreshes from the desktop reports are also fine. There seems to be a quirk with the gateway and refresh integration.

Helpful resources

Announcements
April AMA free

Microsoft Fabric AMA Livestream

Join us Tuesday, April 09, 9:00 – 10:00 AM PST for a live, expert-led Q&A session on all things Microsoft Fabric!

March Fabric Community Update

Fabric Community Update - March 2024

Find out what's new and trending in the Fabric Community.

Top Solution Authors
Top Kudoed Authors