Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
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
Connect to excel Cannot browse one drive (clicking the button throws the error)
Try uploading an excel file instead. Upload works but clicking next throws the error
Tried to enter data just to see what it all looks like. Simple input data
It goes into Power Query (1 step further!) but fails when I press save!
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!
Solved! Go to Solution.
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,
Happy to help!
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,
Happy to help!
Thanks @ibarrau - Quiet annoying that it is enabled to see the options and get to a certain point before failing. Appreciate the help!