Forum Discussion

Ramyak's avatar
Ramyak
Microsoft Employee
4 years ago
Solved

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

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!

Need Help
  • Ramyak's avatar
    Ramyak
    4 years ago

    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!

9 Replies

  • parry2k's avatar
    parry2k
    Super User
    4 years ago

    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's avatar
      sreeramya
      Regular Visitor
      4 years ago

      I already tried it. It still gives me same error

      • sreeramya's avatar
        sreeramya
        Regular Visitor
        4 years ago

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

  • parry2k's avatar
    parry2k
    Super User
    4 years ago

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

  • v-chenwuz-msft's avatar
    v-chenwuz-msft
    Community Support
    4 years ago

    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's avatar
      Ramyak
      Microsoft Employee
      4 years ago

      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's avatar
        v-chenwuz-msft
        Community Support
        4 years ago

        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