I've never seen that error message before - just loaded a bunch of tables as usual 😕
For sure I will retry. Just wanted to report it here.
Experienced the same problem.
Two sources - one an Azure SQL DB, the other Azure Data Lake Gen 2
Have stack trace if it assists.
Uninstall most new version and reload the past version of PBI, and work very well
I tried the latest version of Power BI Desktop but cannot reproduce the issue. You may also try earlier versions from Power BI updates archive.
We experienced the same issue. Two colleagues working with same code: one is using version 2.94.921.0 hasn't experienced it, while other using 2.95.804.0 has experienced it. We are importing a folder of XMLs.
Same problem here.
We delivered a working model and in the last few days I have made some minor changes to optimise some queries by deleting some steps in the process and by adding names and descriptions to the different Powerquery steps. And now almost every query in the model seems to give this error message.
If I go back to a version that I saved on 22 July I can refresh without problems.
I would like to know what is causing this error message so that I don't have to redo all the changes that I have made and I also don't end up with the same error messages again.
If anyone can provide sample data this happens on it would really help the team figure this out. Clearly there is an issue here. I recommend everyone having this issue open a support ticket via this page where you can confidentially share data or do screen-shares so they can see the exact issue.
I can't upload the data I'm using but have the same issue. Connecting an API source on another organisations Power BI tennant using SQL Analysis Services connector. I have a DAX summarise and nester filter statement on imports which are then appended. Works in Power Query editor then fails with the message as above on the Power BI dashboard.
The temporary workaround for me has been to copt the Power Queries into Excel and then link to the loaded Excel tables. Might work in some cases for others although there are limitations.
Same error here: using an API to import json-data. It worked well the first time reloading, after that I got this error:
Same error for me today and I managed to "resolve" it by downloading and installing the June version
Answering to this "If anyone can provide sample data this happens on it would really help the team figure this out. Clearly there is an issue here. I recommend everyone having this issue open a support ticket via this page where you can confidentially share data or do screen-shares so they can see the exact issue": it is possible to send sample data opening a support ticket only for Power BI Pro users.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.