Forum Discussion

jeffhadley's avatar
jeffhadley
Frequent Visitor
7 years ago
Solved

Enterprise Gateway - Cannot connect to the mashup data source

I have a data set that utilizes the Snowflake connector, as well as a connector to a file list in SharePoint.  In the past few weeks, I've begun receiving the following error when attempting to refre...
Need Help
  • jeffhadley's avatar
    jeffhadley
    7 years ago

    I figured out the issue. While PBI Desktop can navigate Snowflake's different schemas correctly, apparently the PBI Gateway cannot. Once I changed the data sources to all be from the same schema, the gateway was able to refresh without issue. I'm not sure why we utilized different schemas in the first place, but I'll keep this in mind down the road.

v-frfei-msft's avatar
v-frfei-msft
Icon for Community Support rankCommunity Support
7 years ago

Hi jeffhadley,

 

Please delete the dataset in Power BI service and publish the report, after that, try to refresh the dataset in power BI service again.

 

Reagrds,

Frank

  • jeffhadley's avatar
    jeffhadley
    Frequent Visitor
    7 years ago

    Hi v-frfei-msft

     

    I deleted the dataset and then republished it.  I still get the same mashup error when I attempt to refresh the dataset.