Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Grow your Fabric skills and prepare for the DP-600 certification exam by completing the latest Microsoft Fabric challenge.

Reply
olivier_esmieu2
Frequent Visitor

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
Anonymous
Not applicable

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
Anonymous
Not applicable

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.

 

Anonymous
Not applicable

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

Hi @Anonymous ,

 

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
RTI Forums Carousel3

New forum boards available in Real-Time Intelligence.

Ask questions in Eventhouse and KQL, Eventstream, and Reflex.

MayPowerBICarousel

Power BI Monthly Update - May 2024

Check out the May 2024 Power BI update to learn about new features.

Top Solution Authors