'%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)
Fix Power BI Power Query Authentication Fails After Close and Apply
Question details
User experiences an authentication failure in Power BI Desktop after configuring an Arena QPLM data source in Power Query and clicking 'Close & Apply'.
- Product
- Power BI Desktop
- Device & OS
- not provided
- Scenario
- Attempting to load data from Power Query into the main Power BI Desktop data model using an Arena QPLM connection.
- Observed behavior
- The data connection works successfully within the Power Query editor preview, but fails with an authentication error upon applying changes to Power BI Desktop.
Ensure you have the latest version of Power BI Desktop installed and verify that your Arena QPLM data source credentials and network connections are active.
Clear and Reconfigure Data Source Permissions
Resetting your stored credentials often resolves mismatched authentication tokens between the Power Query editor and Power BI Desktop.
Power Query sometimes caches older credentials or preview tokens that do not securely transfer over to the main Power BI data model upon applying changes. Clearing the global permissions forces a fresh authentication prompt.
Open Power BI Desktop, navigate to the 'File' menu, select 'Options and settings', and then click on 'Data source settings'.
Switch to the 'Global permissions' tab at the top of the dialog box and locate your Arena QPLM data source in the list.
Select the data source, click the 'Clear Permissions' button at the bottom, and confirm the action.
Click 'Close & Apply' again in the main window. You will be prompted to enter your credentials fresh, which should establish a clean connection.
Adjust Data Privacy Level Settings
Mismatched privacy levels between different data sources can inadvertently block data loading during the Close & Apply phase.
Consult the Microsoft Fabric Community
If local configuration fails, specialized help is required to investigate potential connector, driver, or gateway bugs.
Easily Analyze Exported Data Sets with WPS Office
While complex database connections in Power BI require specific Microsoft environment configurations, you can easily review, analyze, and present your exported data subsets using WPS Office. It provides a highly compatible, free, and lightweight alternative to Microsoft Office for all your everyday spreadsheet operations.
- 1. Download the Software: Visit the official WPS website and download the free version of WPS Office.
- 2. Open Exported Data: Launch WPS Spreadsheet and open the CSV or Excel file exported from your data source.
- 3. Analyze and Present: Use built-in pivot tables, formulas, and charts to quickly visualize your data without complex gateway configurations.
Frequently Asked Questions
Why does my connection work in Power Query but fail in Power BI?
Power Query often caches preview data or temporarily bypasses strict privacy firewall rules during the editing phase. When you click 'Close & Apply', Power BI Desktop enforces full security protocols, which can cause authentication to fail if credentials or privacy levels are mismatched.
How do I completely reset data credentials in Power BI?
Go to File > Options and settings > Data source settings. Switch to Global permissions, select the problematic data source, and click 'Clear Permissions'. Restart Power BI and try connecting again to force a new login prompt.
Do I need an on-premises data gateway for Arena QPLM?
If your Arena QPLM environment is hosted securely on a private network, you will likely need an on-premises data gateway configured with the correct credentials. If it is fully cloud-based, standard web connector credentials usually suffice.
