Forum Discussion
Dataset of Azure Databricks data does not load all tables automatically
Hi ManonNL ,
Based on your error message provided, it seems you are trying to refresh all tables at the same time for both PBI desktop and PBI service, all tables get refreshed BESIDES one. If you can make a further deeper investigation on this issue that trying to connect to the Power Bi dataset to the SSMS tool using the XMLA endpoint, and there's possibility for you to capture and trace all the query sent to the Power Bi dataset during the dataset refresh process, and double-check to find the queries sent to the Power Bi dataset about this issue table, trying to find the further root cause of this issue?
Run SQL Server Profiler - SQL Server Profiler | Microsoft Learn
Best Regards,
Liu Yang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Hi Liu Yang,
Thank you for your reply.
Unfortunately we don't have a premium capacity or premium per user yet, and it seems that this would be a premium feature.
Do you know if there are other ways to check what's wrong?
Kind regards,
Manon