Import from Power BI - completely fails. (Addition to “Import from Power BI - columns are missing”)

Hi together,
for about a week, no data can be imported from Power BI Service Semantic Models. When clicking “Pick” on the table name, the error “Failed to retrieve a list of tables: Bad Request” appears.

The connector has already been checked and tested.


We would greatly appreciate a prompt resolution of this issue.
We are currently using the Easymorph desktop version 5.8.0.19 and Power BI Service version 13.0.25125.48.
If further information is needed, please feel free to contact us.

Hi @xChristophx

Thank you for reporting the issue, we're investigating it.

Hi @xChristophx

We've confirmed and reproduced the issue. After some investigation, it seems that this is a major outage on Microsoft's end.

We'll inform you when it's resolved, unfortunately currently it seems there are no feasible workarounds for the powerBi import

1 Like

You can manually paste the table name in the action settings, as a workaround.

1 Like

Thank you very much, but unfortunately, that doesn't help us very much.

The reason for this is we need to draw evaluations from multiple semantic models and therefore from a large number of tables.

I suggest contacting Microsoft support for that issue. We can't do much if their API is not available.

1 Like

I have found a working interim solution for us.
Until the API provides a list of tables again, I will solve this using a separate table in M-Code, which will have the same name in every semantic model and will return a list of tables. This will enable an iterative table retrieval.

In the attached screenshot, the approach in M-Code can be seen.

1 Like