Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
Hello all,
I have a dashboard that was working fine on Desktop and on the Server until I connected an Access database to it. Now, it still refreshes just fine on desktop, but I get this error now during the scheduled refresh on the server:
Unspecified error. The exception was raised by the IDbCommand interface.
Here is what the connection looks like in Advanced Editor on Desktop (I just pasted the Source lines and ommitted the rest):
let
Source = Access.Database(File.Contents("\\X\Y\Z\YoY.accdb"), [CreateNavigationProperties=true]),
_tblYoY = Source{[Schema="",Item="tblYoY"]}[Data],
And I here is the Connection message on the server showing the credentials are working:
Does anyone understand what's going on here?
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
14 | |
6 | |
4 | |
3 | |
3 |
User | Count |
---|---|
15 | |
9 | |
6 | |
3 | |
3 |