Forum Discussion

New Member

2 years ago

Solved

Import data from power bi

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

Anonymous
2 years ago
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.

New Member

2 years ago

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

Anonymous

Not applicable

2 years ago

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.