Power BI error " Cube Table must have exactly one island"

[marduk20]

Hi PBI community,

Has anyone of you already encountered this error " Cube Table must have exactly one island"?

Can you help further understand

[MarkyMark1 · Accepted solution]

I had the same issue. It resolved when I added new features in the preview features and restarted Power BI. I think it was Store semantic model using TMDL format and Enhanced publish dialogs features

[farnoud]

In order to diagnose the issue it would be helpful if anyone hitting this problem could collect and share their traces. The traces would include private information about your report, so you could DM me the zip file.

These are the steps in order to collect the traces:

1. Set the following environment variable PBI_forceTracing=1

2. Open and refresh the report and wait for the issue to reproduce

3. Collect the diagnostics package: File -> Options and settings -> Options -> Diagnostics -> Collect diagnostics information -> Save (collect the entire PBIDesktopDiagnosticInfo.####.zip file)

Thanks,

Farnoud

[farnoud · Accepted solution]

This issue has been fixed with the latest release of Desktop on March 4th (version 2.126.1261.0).

Thanks,

Farnoud

[nrichards_au]

Getting the error still in 2.127.1080.0 (64-bit)

[J1298]

I checked my issue version again, on the Version: 2.127.1327.0 64-bit (March 2024), this did not give the Island error.

[J1298]

Because the status of this post is Solved,  I created a new post.

https://community.fabric.microsoft.com/t5/Power-Query/Power-BI-issue-quot-Cube-Table-must-have-exact...

[J1298]

Waiting on Farnoud (prob. different timezones).  Does anyone know how to access the requested, where should I look for setting "edit user variable" below:

[yzc]

In windows search bar or control panel search bar, type and search "variables". Then go to "Edit environment variables for your account". There would be a window coming out, at the top you will see "User variables for xxx". Look down the user variables list, find the mentioned variable and edit. Hope it is clear enough.

[J1298]

Thank you,  was not looking at windows settings, was looking within PBI.

[Samotana]

This has to do with februari 2024 release, I had november installed and when i tried it in November version I dont get the same issue. So for now if you revert back to a previous version this error do not occur!
November can be downloaded here :
https://learn.microsoft.com/en-us/power-bi/fundamentals/desktop-latest-update-archive?tabs=powerbi-d...

[MarkyMark1 · Accepted solution]

I had the same issue. It resolved when I added new features in the preview features and restarted Power BI. I think it was Store semantic model using TMDL format and Enhanced publish dialogs features

[John_Wick]

Thank you. I had enabled Enhanced publish dialogs. I disabled this, restarted Power BI then it worked.

[Samotana]

I tried that but still have the same issue!

[John_Wick]

Here are the preview features I have enabled at the moment 

[wkqdbig]

same issue remains for me on these settings too - incredibly frustrating, as we can't even rollback to old version without the headache of getting admin permissions to do so

[John_Wick]

In my scenario I was connecting to a published dataset (DirectQuery)

and that I am on the February 2024 build 

[wkqdbig]

Ah - in my case I am connecting to 2 different PowerBI Datasets (or semantic models are they're now called), one of them is composite, the other is not. I guess it could pertain to the workspace of the non-composite. 

[wkqdbig]

having said that - changing the connection location / workspaced for theses datasets have absolutely no bearing on this error. 

[John_Wick]

This post may be of help Power BI error " Cube Table must have exactly one ... - Power Platform Community (microsoft.com)

[John_Wick]

If you haven't tried it already, open a blank power bi or template and connect one of the semantic models and try publishing to your workspace. You can then try adding the second model to narrow down if that is causing the cube table.

[wkqdbig]

thanks for your help - it fixed itself the following morning - no changes my end, very strange