Modifying existing report data source from ADLS Gen 1 to ADLS Gen 2

[Ramyak]

Hi,

I am trying to alter reports data source connection from ADLS Gen 1 to ADLS Gen 2. It throws me an error that the request URI is invalid. I am able to create a new report with Gen 2 data source. But not able to modify the report getting data from Gen1. Is there a way to do this with out creating new report?

Thanks!

[v-chenwuz-msft]

Hi @Ramyak ,

You are able  to create a new report with gen 2, can you get data from gen 2 in report which was existing gen1 data?

Here's the trick,If is you can add gen2 data source. just get the data from gen2 and change the table name as gen1 table name, and delete the table from gen1 before you apply&save.

Best Regards

Community Support Team _ chenwu zhu

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

[Ramyak · Accepted solution]

Hi Chenwuz, I was able to modify the report with out much changes. After changing DataLake.Contents to AzureStorage.DataLake in the source it worked.

Thanks!

[v-chenwuz-msft]

Hi @Ramyak, 

That's great, can you mark your method or  information helpful to you as a solution? So that more people can find the solution quickly.

Best Regards

Community Support Team _ chenwu zhu

[parry2k]

seems like an authentication issue, can you clear data source credentials in option and settings -> Data source settings

[sreeramya]

Tried that too. It did not work. Thanks!

[parry2k]

and the error is?

[parry2k]

@Ramyak when you are creating a new report using gen2, take the M code under Transform data and update your existing ADLS Gen1 M script with this new script.

[sreeramya]

I already tried it. It still gives me same error

[sreeramya]

[DataSource.Error] Web.Contents failed to get contents from 'https:/<>/webhdfs/v1/'(400): The request URI is invalid