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.
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.
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.
It looks like Microsoft unknowingly made a breaking change and is now trying to fix it without much success. The INFO functions in DAX introduced in 2023 don't work and they don't know when it will be fixed.
We will wait until more information is provided by Microsoft. Unfortunately, we can't do much here
To add to the topic, it's not just the DAX INFO() methods that are failing, which we heavily rely on; the EVALUATE TOPNSKIP expression is also not working.
We use this expression for pagination purposes with large datasets, and it fails when the skip value is non-zero. So, the full extent of the outage is still unknown, and currently, Microsoft hasn't provided an ETA for fixing the problem.
Based on the latest update from our internal team, the fix is currently scheduled for March 24, 2025 . In the meantime, I will keep you updated on any further developments or changes