Quickbooks connector is currently not able to authenticate with power bi desktop because PBI desktop uses Internet Explorer, which Quickbooks has deprecated. More info per the message below -
I am able to authenticate credentials through Power BI Service and refresh my report, and whenever I download the report to PBI desktop, I have the correct, refreshed data tables and can manipulate anything on report view/add measures/etc. However, I need a table that is disabled to load to the report so it is not shown in report view when I download the report. Whenever I go to Power Query Editor, I am asked to re-authenticate credentials, which I am unable to do since there is a current issue between Quickbooks and PBI.
Does anyone know any way for me to either -
- copy the table from Query Editor without needing to reauthenticate? (right clicking and pressing copy just copies the query text)
- change the table to 'Enable Load' and refreshing through PBI service? I have tried searching if this was possible through Power BI API but I didn't find anything.
Any help is appreciated!
@RadRad Yes, it should, since data is already in memory as part of pbix file. If you can see the visuals and interact with the visuals in Power BI desktop, you should be able to use it in DAX studio.
Subscribe to the @PowerBIHowTo YT channel for an upcoming video on List and Record functions in Power Query!!
Learn Power BI and Fabric - subscribe to our YT channel - Click here: @PowerBIHowTo
If my solution proved useful, I'd be delighted to receive Kudos. When you put effort into asking a question, it's equally thoughtful to acknowledge and give Kudos to the individual who helped you solve the problem. It's a small gesture that shows appreciation and encouragement! ❤
Did I answer your question? Mark my post as a solution. Proud to be a Super User! Appreciate your Kudos 🙂
Feel free to email me with any of your BI needs.
@RadRad Yes, it should, since data is already in memory as part of pbix file. If you can see the visuals and interact with the visuals in Power BI desktop, you should be able to use it in DAX studio.
Subscribe to the @PowerBIHowTo YT channel for an upcoming video on List and Record functions in Power Query!!
Learn Power BI and Fabric - subscribe to our YT channel - Click here: @PowerBIHowTo
If my solution proved useful, I'd be delighted to receive Kudos. When you put effort into asking a question, it's equally thoughtful to acknowledge and give Kudos to the individual who helped you solve the problem. It's a small gesture that shows appreciation and encouragement! ❤
Did I answer your question? Mark my post as a solution. Proud to be a Super User! Appreciate your Kudos 🙂
Feel free to email me with any of your BI needs.
@RadRad if you want to copy the data, you can use DAX Studion, connect to your Power BI model and export the data. If there is a connector issue, I guess you always need to download the file from the Power BI service and then use DAX studio to export the data.
Check my latest blog post Year-2020, Pandemic, Power BI and Beyond to get a summary of my favourite Power BI feature releases in 2020
I would ❤ Kudos if my solution helped. 👉 If you can spend time posting the question, you can also make efforts to give Kudos to whoever helped to solve your problem. It is a token of appreciation!
⚡Visit us at https://perytus.com, your one-stop-shop for Power BI-related projects/training/consultancy.⚡
Subscribe to the @PowerBIHowTo YT channel for an upcoming video on List and Record functions in Power Query!!
Learn Power BI and Fabric - subscribe to our YT channel - Click here: @PowerBIHowTo
If my solution proved useful, I'd be delighted to receive Kudos. When you put effort into asking a question, it's equally thoughtful to acknowledge and give Kudos to the individual who helped you solve the problem. It's a small gesture that shows appreciation and encouragement! ❤
Did I answer your question? Mark my post as a solution. Proud to be a Super User! Appreciate your Kudos 🙂
Feel free to email me with any of your BI needs.
Helpful resources
Power BI Monthly Update - August 2025
Check out the August 2025 Power BI update to learn about new features.
Fabric Community Update - August 2025
Find out what's new and trending in the Fabric community.
