Forum Discussion
Issue gateway: using windows credentials
Hi,
I've set-up the gateway (standard mode) with my work e-mail address.
I connected to a mysql db and it worked perfectly, so that's all good.
however, if i try to connect to local files using (my personal, not my work account) windows credentials i get the following error message;
Invalid credentials. (Session ID: 10981628-6519-476b-80c3-6388c125ffd6)
apparently i am not using the correct credentials but I already tried every combination i could think of.
for username I believe it should be either
1. the e-mail address of the microsoft account i'm logging into my machine with.
OR
2. the username retrieved from the cmd line using the 'whoami' command.
I tried both, also in combination with each other but so far no success.
for password I use the password for my MS account, I tried the pin code for my machine access but that doesnt work either.
any suggestions?
I hope you can help me.
regards,
marc
This is beacuse you loacal account would not work with Work domain.
Solution 1 - I would suggest to put your files to One Drive or SharePoint Folder and use it from there
Solution 2- you can put it inside organozation system and use organizaion windows account
If this post helps, then please consider Accept it as the solution and give it a thumbs up
For 1.2 - Refer Use OneDrive for Business links in Power BI Desktop - Power BI | Microsoft Docs for geting that done
If this post helps, then please consider Accept it as the solution and give it a thumbs up
5 Replies
This is beacuse you loacal account would not work with Work domain.
Solution 1 - I would suggest to put your files to One Drive or SharePoint Folder and use it from there
Solution 2- you can put it inside organozation system and use organizaion windows account
If this post helps, then please consider Accept it as the solution and give it a thumbs up
Thanks for ur reply.
Solution 1.
1.1: so to get things clear
i'm using my work account for power bi.
I need to use the same account (thus my work account) for setting up the gateway. (At least, this is how i've been explained.)
If I then try to connect to local files on my machine, where i use my personal account, the registered work account in the gateway conflicts with my personal account on my machine?.
1.2: Regarding Onedrive
I have the files located on Onedrive for Business (work account).
When I try to connect to them I use the file/folder path (from my local machine) and this takes me to my initial issue; can't connect due to credentials.
Is there a different way to connect to files/folders from OneDrive for Business?
1.3: Sharepoint works, so thnx for the suggestion 🙂
solution 2.
indeed would be the most straightforward solution i guess. But no option for me so far as i'm using my personal machine.
regards,
marc
For 1.2 - Refer Use OneDrive for Business links in Power BI Desktop - Power BI | Microsoft Docs for geting that done
If this post helps, then please consider Accept it as the solution and give it a thumbs up
Thnx for ur reply.
with domain account you mean my personal account for my machine or my work account which I used to set up the gateway?
just to elaborate a bit more on the situation.
I'm trying to connect to files/folders from Onedrive for Business (work account) via my local machine using the file/folder paths.
my personal account is already granted access to this Ondedrive (Acces granted 'Owner').
