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

Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!

Reply
Deez
Advocate I
Advocate I

Datamarts starts up but not able to connect or load the datamart

HI,

 

I am able to see the Create Datamarts option, it goes into the connect to data screen. From there, no matter what I try to connect to, Azure SQL DB, Excel from onedrive, Excel Upload - it fails. Even enter data fails. See details below of my setup.

 

Server details:

Located in West Europe.

SKU A2 Power BI embedded (Upgraded from Gen1 to Gen2 a month ago)

Workspace is Premium capacity

 

Errors when connecting:

Cannot connect to Azure SQL

Deez_0-1655902433181.png

 

 

Connect to excel Cannot browse one drive (clicking the button throws the error)

Deez_1-1655902433185.png

 

 

Try uploading an excel file instead. Upload works but clicking next throws the error

Deez_2-1655902433189.png

 

 

 

Tried to enter data just to see what it all looks like. Simple input data

Deez_3-1655902433190.png

 

 

It goes into Power Query (1 step further!) but fails when I press save!

Deez_4-1655902433192.png

 

 

Any idea if its an issue with West Europe?

Or Maybe an additional setting I need to apply?  

Or maybe instances that were upgraded from Gen1 to Gen2 are not the same as spinning up a fresh Gen2 and working with Datamarts?

Any assistance highly appreciated!

 

 

@v-yangliu-msft @marekr 

1 ACCEPTED SOLUTION
ibarrau
Super User
Super User

Hi. Datamarts are not currently suported by embedded. You can read more about it here
https://docs.microsoft.com/en-us/power-bi/transform-model/datamarts/datamarts-administration#conside...

I hope that helps,


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

Happy to help!

LaDataWeb Blog

View solution in original post

2 REPLIES 2
ibarrau
Super User
Super User

Hi. Datamarts are not currently suported by embedded. You can read more about it here
https://docs.microsoft.com/en-us/power-bi/transform-model/datamarts/datamarts-administration#conside...

I hope that helps,


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

Happy to help!

LaDataWeb Blog

Thanks @ibarrau  - Quiet annoying that it is enabled to see the options and get to a certain point before failing. Appreciate the help!

Helpful resources

Announcements
April AMA free

Microsoft Fabric AMA Livestream

Join us Tuesday, April 09, 9:00 – 10:00 AM PST for a live, expert-led Q&A session on all things Microsoft Fabric!

March Fabric Community Update

Fabric Community Update - March 2024

Find out what's new and trending in the Fabric Community.

Top Solution Authors
Top Kudoed Authors