Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
Hi All,
In my desktop report i have used a source Access database and the report works fine, but when i publish to the services when i tried to map to the gateway, it prompts me to create a new data source and i do not see the option for MS Access database, so i slected the file instead. The data source connection is success but when i refresh it fails with the error message. Please need help.
{"error":{"code":"DM_GWPipeline_Gateway_MashupDataAccessError","pbi.error":{"code":"DM_GWPipeline_Gateway_MashupDataAccessError","parameters":{},"details":[{"code":"DM_ErrorDetailNameCode_UnderlyingErrorCode","detail":{"type":1,"value":"-2147467259"}},{"code":"DM_ErrorDetailNameCode_UnderlyingErrorMessage","detail":{"type":1,"value":"The specified field '[_].[t0_1]' could refer to more than one table listed in the FROM clause of your SQL statement."}},{"code":"DM_ErrorDetailNameCode_UnderlyingHResult","detail":{"type":1,"value":"-2147467259"}},{"code":"Microsoft.Data.Mashup.ValueError.Detail","detail":{"type":1,"value":"sickdat.mdb"}},{"code":"Microsoft.Data.Mashup.ValueError.Reason","detail":{"type":1,"value":"DataFormat.Error"}}],"exceptionCulprit":1}}} Table: MarkOffTable
Thanks
Solved! Go to Solution.
Issue fixed i renamed the column UID to UID1 and all good thanks.
Hi @Anonymous
It is making a successful connection to the access file.
The error is saying "he specified field '[_].[t0_1]' could refer to more than one table listed in the FROM clause of your SQL statement"
It relates to your table called "MarkOffTable" if you could have a look at this table?
Thanks @GilbertQ . On my desktop i accessed the source and refrshed it and got the following errors
OLE DB or ODBC error: [DataFormat.Error] The specified field '[_].[t0_1]' could refer to more than one table listed in the FROM clause of your SQL statement..
When i click on edit query and double clicked the source it is a MERGE of 2 tables, please see the attached screen shot
Issue fixed i renamed the column UID to UID1 and all good thanks.