Microsoft is giving away 50,000 FREE Microsoft Certification exam vouchers. Get Fabric certified for FREE! Learn more
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!
Solved! Go to 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!
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.
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!
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
seems like an authentication issue, can you clear data source credentials in option and settings -> Data source settings
Subscribe to the @PowerBIHowTo YT channel for an upcoming video on List and Record functions in Power Query!!
Learn Power BI and Fabric - subscribe to our YT channel - Click here: @PowerBIHowTo
If my solution proved useful, I'd be delighted to receive Kudos. When you put effort into asking a question, it's equally thoughtful to acknowledge and give Kudos to the individual who helped you solve the problem. It's a small gesture that shows appreciation and encouragement! ❤
Did I answer your question? Mark my post as a solution. Proud to be a Super User! Appreciate your Kudos 🙂
Feel free to email me with any of your BI needs.
Tried that too. It did not work. Thanks!
and the error is?
Subscribe to the @PowerBIHowTo YT channel for an upcoming video on List and Record functions in Power Query!!
Learn Power BI and Fabric - subscribe to our YT channel - Click here: @PowerBIHowTo
If my solution proved useful, I'd be delighted to receive Kudos. When you put effort into asking a question, it's equally thoughtful to acknowledge and give Kudos to the individual who helped you solve the problem. It's a small gesture that shows appreciation and encouragement! ❤
Did I answer your question? Mark my post as a solution. Proud to be a Super User! Appreciate your Kudos 🙂
Feel free to email me with any of your BI needs.
@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.
Subscribe to the @PowerBIHowTo YT channel for an upcoming video on List and Record functions in Power Query!!
Learn Power BI and Fabric - subscribe to our YT channel - Click here: @PowerBIHowTo
If my solution proved useful, I'd be delighted to receive Kudos. When you put effort into asking a question, it's equally thoughtful to acknowledge and give Kudos to the individual who helped you solve the problem. It's a small gesture that shows appreciation and encouragement! ❤
Did I answer your question? Mark my post as a solution. Proud to be a Super User! Appreciate your Kudos 🙂
Feel free to email me with any of your BI needs.
I already tried it. It still gives me same error
[DataSource.Error] Web.Contents failed to get contents from 'https:/<>/webhdfs/v1/'(400): The request URI is invalid
User | Count |
---|---|
101 | |
68 | |
58 | |
47 | |
46 |