Showing results for 
Search instead for 
Did you mean: 
jcs93 Frequent Visitor
Frequent Visitor

Mashup error in app space with SQL query and SharePoint Excel connection

Please help!


I'm getting the below error when I upload a PBIX that uses a SQL query (using windows credentials) and a SharePoint Excel file (using OATH credentials).  The Excel file provides a parameter to build the SQL query from (idea from


I have exhausted by troubleshooting abilities and have no idea what else I could do to resolve this issue.  For the record, I'm trying to use my Personal Gateway as our Enterprise Gateway won't connect to the SharePoint file location. Enterprise Gateway gives the same error


Annotation 2019-03-01 110922.jpg

Community Support Team
Community Support Team

Re: Mashup error in app space with SQL query and SharePoint Excel connection

Hi @jcs93 

Could you connect to two data source in Power BI Desktop correctly?

Check whether you could drag columns from them into visuals on the report page.


Do you connect to SQL with direct query or import?


When does the error occurs?

when you publish to Power BI Service or when you add data sources under the On-premises gateway?


What did you do for two data source?

Did you use to second(SharePoint Excel file ) to filter the first one(SQL)? 


How do you create parameters?

Based on my knowledge, when you create a parameter to connect data from SQL to Power BI, you don't need to create this parameter in another table.

That means in your scenario, you should not create parameter in a SharePoint Excel file.

You should create parameter as this article shows.


Best Regards








jcs93 Frequent Visitor
Frequent Visitor

Re: Mashup error in app space with SQL query and SharePoint Excel connection

@v-juanli-msft ,


I need the ability to change parameters on the fly for my client.  The idea that I shared has been the only idea I've seen to give this ability.


SQL was connected through both Import and Direct Query to assist in troubleshooting.  The error occurs when published through the On-Premises Gateway.


The Sharepoint file was used to filter the SQL Query, just as shown in the video.


The article you shared will not allow my customers to change parameters as they require to properly view the data.


The linked idea works well when saving the Excel document to a network resource, without the 'Mashup' errors.  How do I resolve the 'Mashup' error when connecting to the SharePoint document?

Helpful resources

Can You Solve These Challenge

Challenge: Can You Solve These?

Find out how to participate in the first Power BI 'Can You Solve These?' challenge.

Community News & Announcements

Community News & Announcements

Get your latest community news and 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.

Community Kudopalooza

Win Power BI Swag with Community Kudopalooza!

Each week, complete activities and be qualified in the drawing for cool Power BI Swag.

Users Online
Currently online: 82 members 1,187 guests
Please welcome our newest community members: