Power BI Data Mart Hidden Error

[thedatahiker]

I'm trying to bring in a collection of csv files from a sharepoint folder into a power bi data mart. I've used the same query in a data model and it works as expected. When i try to bring it into a Power BI Data Mart i get an error saying "The field 'Hidden' of the record wasn't found." Has anyone encountered this issue? Any workarounds?

Activity ID: 3322e6e1-b560-701f-4d79-b365931dc065
Request ID: e78c3389-2764-4d5a-931e-7cba9a774927
Status code: 500
Error Code: CdsaMashupUserException
Batch ID: 8afbeeef-efc1-45d2-90af-4754c48b9544@f04f2874-bd39-4eae-9835-b09c23b4c380$2023-04-18T17:16:53.0211674Z@c2ad2435-c223-4066-ae63-213d580dd644

[collinq]

Hey @thedatahiker ,

I think this is part of why the datamarts are still in preview.....some of these messages are not very informative and may even lead the wrong way.  I THINK that this means that there is a hidden field (or table/query) in the data that the datamart is trying to access.

I did find this similar message in an older dataflow thread - could be the same issue as in the datamart now.

Dataflows with Excels are failing with "The field ... - Microsoft Power BI Community