# Excel dashboard user/pass not working **URL:** \ **Category:** Users\ **Created:** [May 11, 2020, 6:52pm UTC](https://forum.dimagi.com/t/excel-dashboard-user-pass-not-working/7459 "2020-05-11T18:52:11Z")\ **Posts on this page:** 11\ **Page:** 1
**Author:** ![Ocasio](https://dimagi.b-cdn.net/letter_avatar_proxy/v4/letter/o/d07c76/32.png) [@Ocasio](https://forum.dimagi.com/u/Ocasio)\ **Post date:** [May 11, 2020, 6:52pm UTC](https://forum.dimagi.com/t/excel-dashboard-user-pass-not-working/7459/1 "2020-05-11T18:52:11Z")
Hello, I am trying to access the data from the excel dashboard but I get an error of invalid credentials. From the many options of excel. Which method I should use to access this data? its not Odata feed. I am admin, why I cannot access it. Is there any way to get all hidden values and question ID from an app? ---
**Author:** ![Mazz](https://dimagi.b-cdn.net/user_avatar/forum.dimagi.com/mazz/32/1004_2.png) [@Mazz](https://forum.dimagi.com/u/Mazz)\ **Post date:** [May 12, 2020, 9:08am UTC](https://forum.dimagi.com/t/excel-dashboard-user-pass-not-working/7459/2 "2020-05-12T09:08:00Z")
Hey Raul you need to define an excel dashboard integration feed, set up the type of feed you want to use "Case Vs. Form" and then make sure you refresh the data set on [CommCareHQ.com](http://CommCareHQ.com), and copy the link you'll find like this ![image](https://dimagi.b-cdn.net/uploads/default/original/2X/4/421b29a25dfb8df57f207039d33b24bf61976642.png) then you head into Excel and use this Date -\>from Web ![image](https://dimagi.b-cdn.net/uploads/default/original/2X/a/ace0871572fc4cfac6a13de6e3502390153409f5.png) then you'll be asked to input the link to the feed, and where you want that feed to show up, replace data and other parameters. if your feed gets data from a specific date, you want to replace the data in excel to avoid duplicates form popping up. this should work. if you don't have data, make sure you refresh the data source by clicking on "update data" on CommCare HQ. the way it works is that it takes a snapshot of your data at midnight, and makes it available through the link. it does this automatically but you can also manually update the dataset if you need to. for showing all hidden values and question ID's from an app, you can pick "form" as the type of data in your feed, and pick the form you wish to see everything in. however, you will need a separate feed for each form. you cannot have more than one form appear in a single feed. you also need to note that repeats inside your form come through their own link. when you create a feed, you can select which columns appear, and you can also hide/encrypt the names and other sensitive information if you need to by "Mark as sensitive". Hope this helps and Good luck! Mazz ---
**Author:** ![Ocasio](https://dimagi.b-cdn.net/letter_avatar_proxy/v4/letter/o/d07c76/32.png) [@Ocasio](https://forum.dimagi.com/u/Ocasio)\ **Post date:** [May 12, 2020, 12:41pm UTC](https://forum.dimagi.com/t/excel-dashboard-user-pass-not-working/7459/3 "2020-05-12T12:41:27Z")
This is the error I get if I try to use "from web" Details: "The credentials provided cannot be used for the Web source. Please update the credential type through a refresh or in the Data Source Settings dialog to continue. ---
**Author:** ![Mazz](https://dimagi.b-cdn.net/user_avatar/forum.dimagi.com/mazz/32/1004_2.png) [@Mazz](https://forum.dimagi.com/u/Mazz)\ **Post date:** [May 12, 2020, 1:03pm UTC](https://forum.dimagi.com/t/excel-dashboard-user-pass-not-working/7459/4 "2020-05-12T13:03:06Z")
Hey Raul ![image](https://dimagi.b-cdn.net/uploads/default/original/2X/1/1363fab8f889f31579f01363734396850c7ec2a9.png) if you're getting this screen, and you're entering credentials, make sure it's a web user and not a mobile worker. if you're sure, and the credentials work if you go into "incognito" mode in your browser and try to log into commcareHQ, this is pretty much enough reason for a support ticket. otherwise if you can't log in, you're likely mistyping your password (happened to me before when i used an older password). if everything is working with your credentials, it's maybe a blocked port or something like that but i doubt it. it's standard web authentication so it shouldn't be using anything fancy like that. Hope this helps Mazz ---
**Author:** ![Ocasio](https://dimagi.b-cdn.net/letter_avatar_proxy/v4/letter/o/d07c76/32.png) [@Ocasio](https://forum.dimagi.com/u/Ocasio)\ **Post date:** [May 12, 2020, 1:49pm UTC](https://forum.dimagi.com/t/excel-dashboard-user-pass-not-working/7459/5 "2020-05-12T13:49:51Z")
![Annotation 2020-05-12 094851](https://dimagi.b-cdn.net/uploads/default/original/2X/e/e5dcdc755d0c9420fa4707bccfd6b6037fd0ffd1.png) ---
**Author:** ![Mazz](https://dimagi.b-cdn.net/user_avatar/forum.dimagi.com/mazz/32/1004_2.png) [@Mazz](https://forum.dimagi.com/u/Mazz)\ **Post date:** [May 12, 2020, 2:33pm UTC](https://forum.dimagi.com/t/excel-dashboard-user-pass-not-working/7459/6 "2020-05-12T14:33:01Z")
So, if you're sure that you're using a web user, and that the credentials work, send a support ticket. this is not expected behavior. Web sources use basic authentication. if for some reason this is not the case then i think a support call is certainly the right way forward. They might need to adjust something on their end, or tell you what you need to change on your end. Mazz ---
**Author:** ![Ethan\_Soergel](https://dimagi.b-cdn.net/user_avatar/forum.dimagi.com/ethan_soergel/32/543_2.png) [@Ethan\_Soergel](https://forum.dimagi.com/u/Ethan_Soergel)\ **Post date:** [May 12, 2020, 5:29pm UTC](https://forum.dimagi.com/t/excel-dashboard-user-pass-not-working/7459/7 "2020-05-12T17:29:56Z")
Thanks for troubleshooting Mazz, that's all spot-on. Confirming the credentials in incognito mode is especially useful. Raul, do you have two-factor authentication turned on for your user? That may also complicate this process. ---
**Author:** ![Ocasio](https://dimagi.b-cdn.net/letter_avatar_proxy/v4/letter/o/d07c76/32.png) [@Ocasio](https://forum.dimagi.com/u/Ocasio)\ **Post date:** [May 14, 2020, 3:04pm UTC](https://forum.dimagi.com/t/excel-dashboard-user-pass-not-working/7459/8 "2020-05-14T15:04:01Z")
I am 100% sure the password is fine and there is no 2FA activated. I sent a ticket lets see what happens. ---
**Author:** ![Ocasio](https://dimagi.b-cdn.net/letter_avatar_proxy/v4/letter/o/d07c76/32.png) [@Ocasio](https://forum.dimagi.com/u/Ocasio)\ **Post date:** [May 15, 2020, 12:51pm UTC](https://forum.dimagi.com/t/excel-dashboard-user-pass-not-working/7459/9 "2020-05-15T12:51:00Z")
I managed to make it work, now I have a different question. Is there any advantage at all of using this over an Odata feed? I think the Odata is better except for the password difference. Another thing, is there any way to modifiy data remotely as an excel table. ---
**Author:** ![Mazz](https://dimagi.b-cdn.net/user_avatar/forum.dimagi.com/mazz/32/1004_2.png) [@Mazz](https://forum.dimagi.com/u/Mazz)\ **Post date:** [May 17, 2020, 12:01pm UTC](https://forum.dimagi.com/t/excel-dashboard-user-pass-not-working/7459/10 "2020-05-17T12:01:35Z")
Hey Raul Great that it's working. here's how i see the advantage of Excel feeds over ODATA. if you're planning on a large data set to be transferred, the advantage of Excel feeds is that they are processed at midnight. so, if they take a long time to produce, you can just download the pre-loaded dataset for your query. with ODATA, it'll grab whatever you've defined from the database. As far as editing the cases on CommCare through your excel file, it's theoretically possible, but it means doing A LOT of coding and API uses in whatever tool you're using "Excel or otherwise". CommCare was built for the data to be primarily edited through your CommCare apps, with some exceptions through CommCare HQ. i don't think it's generally a great idea because you have to perform the same validations and checks you have on your CommCare forms, as well as making sure that whatever you do is happening in all of your tools. it's a big headache if you ask me! and Dimagi doesn't usually support it i think. it's probably "at your own risk" type of thing i believe, but here's some interesting documentation to get you started [https://confluence.dimagi.com/display/commcarepublic/CommCare+HQ+APIs](https://confluence.dimagi.com/display/commcarepublic/CommCare+HQ+APIs) HTH Mazz ---
**Author:** ![Nasr](https://dimagi.b-cdn.net/letter_avatar_proxy/v4/letter/n/ee59a6/32.png) [@Nasr](https://forum.dimagi.com/u/Nasr)\ **Post date:** [December 14, 2022, 6:47am UTC](https://forum.dimagi.com/t/excel-dashboard-user-pass-not-working/7459/11 "2022-12-14T06:47:04Z")
Hi Ocasio, Can you please Tell us how you managed to solve this, Kindest Regards.