ADLS table shortcut SQL endpoint error

[simtali]

My lakehouse contains several shortcuts to delta tables that are all in the same ADLS Gen 2 container, and they all work fine except one, which gives the error below when I try to access it from the SQL endpoint (though lakehouse preview works). The delta tables are being created by a data flow, and there are no indications of failures. The only notable difference between this table and the others that work is the number of columns, 490, which is within the documented limit of 10,000. Are there any steps I can take to troubleshoot this, or logs that would provide more detailed information about the cause?

[Anonymous]

HI @simtali,

I suppose this may related other table data size and sql endpoint I/O limits. Have you checked on the data source settings to confirm if they meet to the limitations?
Regards,

Xiaoxin Sheng

[simtali]

Hi Xiaoxin,

Thanks for your response. What are the data source settings and limitations you're referring to?

If these are the limitations you have in mind, none of them apply.

[Anonymous · Accepted solution]

HI @simtali,

In fact, I mean the limitation that enabled on the data source side. If you are interesting about these, perhaps you can check the following links:

Best practices for using Azure Data Lake Storage - Azure Storage | Microsoft Learn

Azure datalake storage Gen2 : Maximum Number of Files/second that we can create - Microsoft Q&A

Regards,

Xiaoxin Sheng

[lbendlin]

If you have a Pro license you can open a Pro ticket at https://admin.powerplatform.microsoft.com/newsupportticket/powerbi
Otherwise you can raise an issue at https://community.fabric.microsoft.com/t5/Issues/idb-p/Issues .