Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
Hey All,
full-time user of powerbi and powerbi service here.
we ran across an issue with the new datamarts that are available at powerbi service.
we have a large dataset (roughly 50 million rows) that we want to put inside a datamart. most of the data is already there, but the last table we need is giving us issues. the inserting in the transform view is going normal, bud when we try to apply and save, we ran across this issue:
it sounds like this error comes from some kind of limitations fo the datamart? but this is not the largest table at all.
it's running on a powerfull laptop, so ram/storage should not be an issue.
googling this error gave no results, as the datamarts is a rather new thing.
another reasing i think is that this query tops the premium capacity we have allocated to our workspace?
all reasonable expleneations are welcome.
Datamarts run in the dataflow workload in prem gen 2. That workload hhas been buggy since MS switched everyone to Prem Gen2. I would not be surprised if datamarts are not the recipient of the same issues. Datamarts, while interesting and has a future are clearly not ready for prime time. I would hesitate putting them into production.
Also, datamarts currently support data volumes of up to 100 GB. Not sure if that applies in any of these cases.
I'm getting this issue too. The 3 datasets that I'm pulling in are not that large (not even a thousand rows in total). I think the datamarts is still buggy from this error and others that I've gotten (and it is still in preview).
I started getting the same error today in one of my workspace where I successfully created first datamart and had added two tables.. I am wondering if the PowerBI tenant Admin has disabled this feature?
This is the same thing I noticied. I loaded one query and it processed fine. When I went to load another it got buggy (but eventually worked). When I went to load a third I got the same error.
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.