Import data from power bi

[QYtyregtgb]

When importing data from Power BI into Excel and inserting the table, it gives this attached error.

[v-stephen-msft]

Hi @QYtyregtgb ,

Thanks for reaching out to our community. I have to remind you that this is the Power BI Mobile Apps forum.

Do you get connection errors for all your Power BI semantic models? You can tell if there's a problem with the semantic model you want to connect to by trying to connect to other semantic models.

So far, I've tested it and it works fine.

Best Regards,

Stephen Tao

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

[QYtyregtgb]

It happens with all the models. I tested by opening in another Power BI account of mine, and it accesses normally

[v-stephen-msft]

Hi @QYtyregtgb ,

It's likely that your admin has disabled some access features, please contact your admin.

If not, check whether the conditions are met based on the requirements below.

Screenshot source:

Power BI semantic model experience in Excel - Power BI | Microsoft Learn

Best Regards,

Stephen Tao

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

[QYtyregtgb]

Everything is in order regarding approvals and the version.

Is there any permission within Power BI that might restrict access or something like that?

[v-stephen-msft · Accepted solution]

Hi @QYtyregtgb ,

Here's what you need to keep in mind:

• You must have Build permission to the Power BI semantic model or have at least a Contributor role in the Power BI workspace containing your semantic model.

Best Regards,

Stephen Tao

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

[QYtyregtgb]

I can insert using the 'Insert PivotTable' option, but I can't with the other 'Insert Table' option.

[v-stephen-msft]

Hi @QYtyregtgb ,

Please note that the Insert Table option is only available in Excel Desktop. You can check more details from the below reference link.

Reference:

Power BI semantic model experience in Excel - Power BI | Microsoft Learn

Best Regards,

Stephen Tao

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