Datamart and blob broken??

[Anonymous]

Hi 

I have been trying to get datamart to work with our Datalake gen 2 and/or blob storrage. 

Everyting works fine when navigating to a single file in the container, data tranformation and deploiment, so thats super.

I decided to split the file into seperate files in the container, so i have a file for each month (files are in jason).

All files can be individualy imported and transformed in power Query but i can not combine files in the container to one datatable.

My isues are the following:

First:

When combining files/content the automatic process breaks.

I've found this can be fixed by manually transforming the data in the Transform sample file from this:

 

to 

Then the query works and combines all the files/content in the container.

Great its probbaly a bug, but then i get to the seccond issue i'm having.

Second:

I can't save the Query i get the following error:

i've tried everything i could think off, does anyone have a solution?

[Anonymous]

Hi @Anonymous ,

Could you please the error in which step? If the steps are correct, it seems nothing error. 

I have also found a similar post, please refer to it to see if it helps you.

Solved: Error: "The field 'XXXX' of the record wasn't foun... - Microsoft Power BI Community

Best Regards
Community Support Team _ Polly

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[Anonymous]

Hi 

I'm not quite sure it's the same problem. The data works fine and the multiple jason files combine fine when doing a traditional dataset in desktop and uploading to the service. Refresh in the PBI service also works and when adding another file to the container this data is also combined with the rest of the data.

The Error only orcures when combining files(JASON) in the DataMart, and consists of 2 errors,

1. the automatic combining automation dosen't work, but has to be done manually.

2. after manually fixing the first error the data loads into the model and can be transformed, but it fails when saving.

I have tried to remove the filter Hidden from the Query, this has no effect just gives an other error in the same stage.