Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
3 years ago

Datamart and blob broken??

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?

 

 

 

 

 

Need Help

2 Replies

    • Anonymous's avatar
      Anonymous
      Not applicable
      3 years ago

      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.