Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
Hi,
My report has one Data source - a connection to an on-premise NAV server. We're using an enterprise gateway to connect to the data, and I have 5 separate .pbix reports published to the service all querying it for data (on a timed schedule - none at the same time).
All 5 .pbix files use the same data source (they are copies of one another), and they query the same tables in the NAV database. 3 of the scheduled refreshes succeed, 2 fail every night. Looking into the errors, the credentials aren't authenticating.
It's the same data source, the same credentials and the same tables being looked up for all 5, so we know the credentials have access to the relevant tables.
Anyone have any ideas? I can provide error messages if needed.
Thanks,
Mike
Hi @Anonymous,
Could you please tell me if your problem has been solved? If it is, could you please mark the helpful replies as Answered?
Regards,
Daniel He
Hi @Anonymous,
Could you please check below information?
Regards,
Daniel He