Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
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
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)
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.