Forum Discussion

mm14222's avatar
mm14222
Icon for Helper I rankHelper I
5 years ago

Cannot connect to a new data source anymore - Connecting please wait while we establish a connection

I'm having Microsoft Power BI Desktop August version, it is running a complex multiple reporting by connecting to various files csv and excel files. Everything was working fine for weeks and suddenl...
Need Help
pwc_ananta's avatar
pwc_ananta
Icon for Helper I rankHelper I
4 years ago

This just happened with me too. I am unable to establish the connection. mm14222 How did you resolve the issue? Its a top priority issue, The connection is working for new PBIX files but the report in which i have worked a lot is not connecting to the source again. I am using October 2021 version.

Nik-nklskrmnn's avatar
Nik-nklskrmnn
New Member
4 years ago

I have the same issue with an file I worked on for three months. Could anyone solve the issue? With my file preview refresh oder data refresh do not work either.

 

  • pwc_ananta's avatar
    pwc_ananta
    Icon for Helper I rankHelper I
    4 years ago

    Nik-nklskrmnn

    This took time due to loading whole heirarchy and relationship columns in PBIX file for each table we add in the report.

    The best way I figured out for Oracle Database Source is to load the data from SQL query.


    Enter the Server IP details, Click on Advance, then Uncheck both check boxes for Relationship Columns and Heirarchy and write the SQL query.

    Load the Data, it will take few seconds to load. For more tables to load, duplicate the query and just change the SQL in it. Cheers!

    Accept it as a solution if it work for you.