Forum Discussion

mm14222's avatar
mm14222
Helper 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
v-jingzhang's avatar
v-jingzhang
Community Support
5 years ago

Hi mm14222 

Does this issue still occur on the latest October 2020 Version?

 

Regards,

Community Support Team _ Jing Zhang

mm14222's avatar
mm14222
Helper I
5 years ago

Hi thanks for getting back to me.

 

I upgraded to October 2020 version, however, this didn't solve the problem, I'm still having the same issue. 

I do not get any error message, I can work normally on the file, the only thing I cannot do is to add additional data source as per the updated screenshot below.

 

It is critical to highlight that in any other PBIX file, I'm able to add additional data sources, so the issue is only limited to this cube.

 

We also do not know when this problem started as it never gave an error before, so it is hard for us to restore this Cube to a previous version. If I can only know when it got broken, or what is breaking it, this will help me to either restore it from the previous back up and do manual updates to what we have lost or simply fix the issue.

 

Your kind guidance is highly appreciated. 

 

  • v-jingzhang's avatar
    v-jingzhang
    Community Support
    5 years ago

    Hi mm14222 

     

    If you can add the new data source in any other pbix file, you may try adding the data source in a new pbix file, and copy the scripts in its Advanced Editor. Then create a new blank query in the old file, and paste the scripts in its Advanced Editor and apply the changes.

    Hope this works.

     

    Regards,

    Jing

    • TimAllison's avatar
      TimAllison
      New Member
      4 years ago

      Perfect. Thanks so much.