Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
9 years ago

The connection string used for the mashup data source is invalid

Hi, 

 

I'm having an issue refreshing my report in powerbi web. The report is working well and can be refreshed in powerbi desktop. As I have 2 oAuth connections in the report I'm using the latest version of the personal gateway. There is also a ODBC connection and an excel workbook connection. I have followed the troubleshoot guide without any luck. Pls help!  

 

 

The connection string used for the mashup data source is invalid
Cluster URI:WABI-NORTH-EUROPE-redirect.analysis.windows.net
Activity ID:cc4a70b6-2081-448b-bd3f-bf333b590f2f
Request ID:b5f62466-ca41-4550-9c34-67bfe94c5a92
Time:2017-06-07 16:55:25Z
 

 

11 Replies

  • dimazaid's avatar
    dimazaid
    Icon for Microsoft Employee rankMicrosoft Employee
    9 years ago

    hi Jonto,

    What oAuth data sources are you using it with? 

     

    Thanks!
    Dimah 

    • Anonymous's avatar
      Anonymous
      Not applicable
      9 years ago

      Hi,

       

      Zendesk and google analytics. 

       

      Thanks! 

      • Anonymous's avatar
        Anonymous
        Not applicable
        9 years ago

        dimazaid any input on this issue? 

         

         

        Thanks

  • Anonymous's avatar
    Anonymous
    Not applicable
    4 years ago

    I am receiving a similar error message for Databricks data refresh. 

    The connection string used for the mashup data source is invalid or the gateway needs to be upgraded to the latest version.

    dimazaid 

    • jayaxe's avatar
      jayaxe
      Icon for Advocate I rankAdvocate I
      3 years ago

      I had the same error and resolved it. 

      What happened was that my Power BI has data from many sources, mainly SQL and a few Excel files.

      The data from SQL needed a gateway in order for the auto refresh to work, but not the Excel file.

      Somehow if I merge a table from SQL with an external source (Excel in this case), this error ("connection string used for the mashup data source is invalid...") will pop up.

       

      After removing the merge, there is no more error and the auto refresh works.