cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
akj2784 Member
Member

Cannot connect to the mashup data source

Hi All,

 

We are using Enterprise Gateway to connect to on premise database X. We have used database X to create the dataset in Power BI Desktop.

When we refresh the data in Power Bi Desktop, it works fine.

But when we publish it to the Service and refresh the data it gives error.

"Cannot connect to mashup data source...."

 

Any input on this ?

 

Regards,

Akash

 

1 ACCEPTED SOLUTION

Accepted Solutions
akj2784 Member
Member

Re: Cannot connect to the mashup data source

Thank you all. Data source was already configured in the gateway. There was no other data source in the dataset.

I found the root cause. Actually the user configured in the enterprise gateway did not have access to some of the tables. 

The error code "Mashup" was misleading.

So we created synonyms for the tables and the issue was resolved.

 

3 REPLIES 3
Kbrennan856 Frequent Visitor
Frequent Visitor

Re: Cannot connect to the mashup data source

Hi ,

 

go to manage gateways on the service, from there select add data source and follow the steps provided 

v-jiascu-msft Super Contributor
Super Contributor

Re: Cannot connect to the mashup data source

Hi Akash,

 

1. What is database X? SQL Server or something else?

2. Did you configure the data source in the Service?

3. What's the error message? Where did you get it?

4. Are there any other data source in your model?

 

Best Regards,

Dale

Community Support Team _ Dale
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
akj2784 Member
Member

Re: Cannot connect to the mashup data source

Thank you all. Data source was already configured in the gateway. There was no other data source in the dataset.

I found the root cause. Actually the user configured in the enterprise gateway did not have access to some of the tables. 

The error code "Mashup" was misleading.

So we created synonyms for the tables and the issue was resolved.

 

Helpful resources

Announcements
Virtual Launch Event

Microsoft Business Applications October Virtual Launch Event

Join us for an in-depth look at the new innovations across Dynamics 365 and the Microsoft Power Platform.

Power BI Helps Homeless and Trouble Youth

Power BI Helps Homeless and Trouble Youth

We spoke with Power BI Super User, Greg Deckler, about his charity work

MBAS Gallery

Watch Sessions On Demand!

Continue your learning in our online communities.

Users Online
Currently online: 43 members 1,102 guests
Please welcome our newest community members: