'%3e%3cpath%20d='M8%200C12.4183%200%2016%203.58172%2016%208C16%2012.4183%2012.4183%2016%208%2016C3.58172%2016%200%2012.4183%200%208C0%203.58172%203.58172%200%208%200ZM11.6162%204.38379C11.2257%203.99337%2010.5927%203.99338%2010.2021%204.38379L8%206.58594L5.79785%204.38379C5.40732%203.99334%204.77429%203.99329%204.38379%204.38379C3.99331%204.77429%203.99335%205.40733%204.38379%205.79785L6.58594%208L4.38379%2010.2021C3.99348%2010.5927%203.99341%2011.2257%204.38379%2011.6162C4.77426%2012.0066%205.40734%2012.0065%205.79785%2011.6162L8%209.41406L10.2021%2011.6162C10.5927%2012.0066%2011.2257%2012.0067%2011.6162%2011.6162C12.0067%2011.2257%2012.0066%2010.5927%2011.6162%2010.2021L9.41406%208L11.6162%205.79785C12.0066%205.40735%2012.0066%204.77429%2011.6162%204.38379Z'%20fill='%23080E17'%20fill-opacity='0.46'/%3e%3c/g%3e%3cdefs%3e%3cclipPath%20id='clip0_3761_713'%3e%3crect%20width='16'%20height='16'%20fill='white'/%3e%3c/clipPath%3e%3c/defs%3e%3c/svg%3e)
How to Fix Power BI Service Appended Query Refresh Failure
Question details
The user needs to resolve an issue where an appended query refreshes successfully in Power BI Desktop but fails to refresh after being published to Power BI Service.
- Product
- Power BI Service
- Device & OS
- not provided
- Scenario
- Refreshing datasets containing appended queries in Power BI Service.
- Observed behavior
- The query refresh functions correctly in the desktop application but fails online due to mismatched privacy levels, incorrect gateway mappings, or data-source permission issues.
Ensure you have administrator access to your Power BI workspace and the on-premises data gateway before attempting to modify data-source configurations.
Configure Consistent Privacy Levels and Gateway Settings
Aligning privacy levels across Power BI Desktop, the data gateway, and Power BI Service resolves data access mashup errors preventing the refresh.
Power BI Service strictly enforces privacy levels when combining data from multiple sources (like an appended query). If the privacy settings in the Desktop file do not match the online Gateway settings, the refresh will fail.
Open Power BI Desktop, navigate to File > Options and settings > Data source settings. Ensure that the privacy levels (e.g., Organizational or Private) for all appended sources match.
Log in to Power BI Service, go to your workspace, click the ellipses (...) next to your dataset, and select Settings. Expand the 'Gateway connection' section.
Confirm that all data sources used in the appended query are correctly mapped to an online and authorized gateway.
Under 'Data source credentials' in the dataset settings, edit the credentials for each source to ensure they have the necessary permissions and that their privacy levels match what was set in Power BI Desktop.
Analyze Data Seamlessly with WPS Office
While Power BI handles complex enterprise business intelligence, WPS Spreadsheet provides a lightweight, highly compatible alternative for everyday data analysis, charting, and reporting without the need for complex gateway configurations.
- 1. Download and Install: Visit the official WPS website to download and install the free office suite.
- 2. Open Your Data File: Launch WPS Spreadsheet and easily open your existing Excel workbooks or CSV data extracts.
- 3. Analyze and Report: Use built-in functions, PivotTables, and dynamic charts for straightforward, local data analysis without gateway connectivity issues.
Frequently Asked Questions
Why does my appended query refresh in Power BI Desktop but fail in Service?
Power BI Desktop often uses your local Windows credentials and can sometimes ignore strict privacy level clashes. Power BI Service requires a properly configured data gateway and strictly enforces consistent privacy levels across all appended data sources to ensure secure data combinations.
What does a MashupDataAccessError mean in Power BI?
This error typically occurs in Power BI Service when the data gateway cannot securely combine data from different sources. This is usually caused by mismatched privacy settings between the sources or insufficient database permissions for the gateway service account.
How do I check my gateway status in Power BI Service?
Navigate to your Power BI workspace, find the dataset experiencing the issue, click the ellipses (...) and choose Settings. Expand the 'Gateway connection' section to view the status of your assigned gateways and verify they are online.
