Forum Discussion

Clay_Moyer's avatar
Clay_Moyer
Copper Contributor
Jan 21, 2022

Linking Mint Transaction Data to Power Query

For those familiar with Mint (the personal budgeting app), there is a clickable link to download a CSV file with all of your transactions. I want to use PowerQuery to create a link to that CSV download. I set up the connection and entered in my credentials under the permissions section, but I keep getting the following error:

 

We encountered an error while trying to connect. Details: "Web.Contents failed to get contents from 'https://mint.intuit.com/accessDenied.html' (404): Not Found"

 

I tried removing all permissions and starting from scratch, but that hasn't worked. I also just copied the URL for the download and pasted it into Chrome, and it worked just fine. Any ideas?

power bi

2 Replies

  • Benny_1857's avatar
    Benny_1857
    Brass Contributor
    Jan 22, 2022
    Not very clear about this link. But as you mentioned 'I also just copied the URL for the download and pasted it into Chrome, and it worked just fine.'
    You could you Power Automation to do that then use PQ read CSV locally.
    • Clay_Moyer's avatar
      Clay_Moyer
      Copper Contributor
      Jan 24, 2022

      Benny_1857 

       

      Below is a screenshot of the link I'm talking about. The hyperlink to "Export all 836 transactions" downloads a CSV file. PQ should be able to pull that data by using the "from web" option and putting in the appropriate sign-in credentials. However, I keep getting the same error. I'd prefer to run the whole thing through PQ for simplicity's sake. 

       

       

Resources