Problems with DirectQuery and Oracle Sources - "An error was encountered in the transport layer"

Ricardo Mota Freitas 1 Reputation point
2020-09-24T15:54:51.927+00:00

Hello,

Im developing reports in Power BI Desktop (RS - don't think it's too important here) with Live Query connection to SSAS 2017, and SSAS 2017 is connected to Oracle sources using Direct Query.

I would like to know what are the inevitable things to analize, between Oracle and mainly in SSAS and Power BI, that could justify that 40% of the reports sheets fail with message "couldn't load data for this visual, An error was encountered in the transport layer". In DAX studio the message is "error connecting to the server: the connection was either timed out or was lost".

Meanwhile we are trying SQL Server 2019, and in this case the % of errors in sheets grows up to 80%.:face_with_rolling_eyes:

Thanks

SQL Server Analysis Services
SQL Server Analysis Services
A Microsoft online analytical data engine used in decision support and business analytics, providing the analytical data for business reports and client applications such as Power BI, Excel, Reporting Services reports, and other data visualization tools.
1,282 questions
0 comments

1 answer

Sort by: Most helpful
Most helpful Newest Oldest
  1. Lukas Yu -MSFT 5,821 Reputation points
    2020-09-25T07:14:09.09+00:00

    Hi,
    As direct query mode has quite a few limitations see : Limitations
    The error info in your case is hardly to find any clue. I would suggest you to change import data mode and storage data in SSAS server if possible. Or try power bi direct query to see if any difference there.

    If the answer is helpful, please click "Accept Answer" and upvote it.

    Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.

Your answer

Answers can be marked as Accepted Answers by the question author, which helps users to know the answer solved the author's problem.