cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
olivier_esmieu2
New Member

consuming Dataflow stored in Azure Datalake Storage from a Datamart .. unauthorized error message

Hi all

As described in powerbi - Consuming dataflows from a datamart - Stack Overflow

By consuming a Dataflow from a datamart, I 'll get the error "The remoter server returned an error (401) unauthorized" if this dataflow has been stored in my azure datalake

Same test but with the same Dataflow stored in powerBi cloud service: it works

is is a bug or did I miss sthing ?

 

1 ACCEPTED SOLUTION
olivier_esmieu
Frequent Visitor

ok v-yinliw-msft

catched now.. So.. that means I can't use Datamart feature with a Dataflow stored in my ADLS.. That's really a pity.. Guess you don't know if it will be changed ??

Thks anyway for your enlighting!

 

View solution in original post

4 REPLIES 4
olivier_esmieu
Frequent Visitor

ok v-yinliw-msft

catched now.. So.. that means I can't use Datamart feature with a Dataflow stored in my ADLS.. That's really a pity.. Guess you don't know if it will be changed ??

Thks anyway for your enlighting!

 

v-yinliw-msft
Community Support
Community Support

Hi @olivier_esmieu2 ,

 

There are some limitaions and considerations of datamart:

When using datamarts with named connections, the following limitations apply:

1.You can only create one cloud connection of a particular path and type, for example, you could only create one SQL plus server/database cloud connection. You can create multiple gateway connections.

2.You cannot name or rename cloud data sources; you can name or rename gateway connections.

 

And Attaching a dataflow with ADLS Gen 2 behind multifactor authentication (MFA) is not supported in the datalake.

 

For more information, you can refer these documentations:

Configuring dataflow storage to use Azure Data Lake Gen 2 - Power BI | Microsoft Learn

Get started with datamarts (preview) - Power BI | Microsoft Learn

 

Hope this helps you.

 

Best Regards,

Community Support Team _Yinliw

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

 

Thks @v-yinliw-msft , . However, I don't see your point 🙂

Hi @olivier_esmieu ,

 

If you use the datamart with named connections, you can only connect the cloud datasource,here.

vyinliwmsft_0-1669888125979.png

So when the dataflow stored in the cloud service, it works, but another not.

 

Hope this helps you.

 

Best Regards,

Community Support Team _Yinliw

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

Helpful resources

Announcements
Carousel_PBI_Wave1

2023 Release Wave 1 Plans

Power BI release plans for 2023 release wave 1 describes all new features releasing from April 2023 through September 2023.

Power BI Summit Carousel 2

Global Power BI Training

Make sure you register today for the Power BI Summit 2023. Don't miss all of the great sessions and speakers!

Thank you 2022 Review

2022 Monthly Feature Releases

We had a great 2022 with a ton of feature releases to help you drive a data culture.

Top Solution Authors
Top Kudoed Authors