question

MateuszKw avatar image
0 Votes"
MateuszKw asked LukasYu-msft commented

Tabular Model - processing a table takes forever

Hello,

I've deployed successfully my tabular model on AAS Server instance. However, when I try to process single table using SQL Server Management Studio, the processing won't even start and hangs on forever:

96724-image.png



This table comes from PostgreSQL database which is configured as a ODBC connection. I know that this issue is not caused due to size of this table, as I've also repeated this action on table that was only three rows - without succeeding.

Both Gateway and AAS Server resources were correctly set up on Azure Portal as I am able to upload some tables created through power query and successfully load them using Power BI.

I'd strongly appreciate any help on this issue!

Thank you,
Matthew

sql-server-analysis-servicesazure-analysis-services
image.png (54.1 KiB)
· 1
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

Hello @MateuszKw ,

Thanks for the ask and using the Microsoft Q&A platform . Apologizes for the delay in response .
Are you seeing this behaviour when you try o process only 1 table ? Not sure if you have the liberty to try and see if you can process the full DB , if yes can you please try that see what happens ?

Please do let me know how it goes .
Thanks
Himanshu

0 Votes 0 ·
MateuszKw avatar image
0 Votes"
MateuszKw answered LukasYu-msft commented

Hi again,

I was able to fix this issue recently. I'll share solution that worked in my scenario, so it might be helpful for someone else:
When configuring the postgres sql database in portal azure as a resource, it is needed to set "SSL enforce status" as "ENABLED" 97787-image.png


Accordingly, in ODBC Source Administrator application, it is needed to set "prefer" option in "SSL mode" window:
97758-image.png



After these changes, I was able to establish connection between data gateway and psql database successfully, then - process the data on any table.

Best Regards,
Mateusz


image.png (1.8 KiB)
image.png (2.4 KiB)
· 1
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

Thanks for your sharing! I am sure people with similar issue could benifit from this solution!
Cheers!

0 Votes 0 ·
LukasYu-msft avatar image
0 Votes"
LukasYu-msft answered

When you click the "details", does it show you which part this processing is stucked with?

5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

MateuszKw avatar image
0 Votes"
MateuszKw answered

Hi,

@HimanshuSinha-6857 I've tested three different tables the same way and every time it was the same scenario.
When I tried to process full Database it gets stuck as well on the processing screen.

@LukasYu-msft Basically no sign of an error

97445-image.png




I've got one question additionally:
I've configured Tabular Model on another environment the same way I'm trying to do here, but it works there perfectly. One difference that I've noticed during configuration is that database there has "SSL Mode enabled" - here, where I try to make it work, the dabatase got "SSL Mode disabled". Could this be a cause?

Regards,
Mateusz


image.png (45.9 KiB)
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.