Issue gateway: using windows credentials

[marc_agi]

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

[arvindsingh802 · Accepted solution]

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

[GilbertQ]

Hi @marc_agi 

Another alternative is to make sure that the domain account has access to the files you want to read from.

You can also do this by creating a share where the folders/files are stored and then grant the same domain account access to that share to read the files?

[marc_agi]

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').

[arvindsingh802 · Accepted solution]

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

[marc_agi]

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

[arvindsingh802 · Accepted solution]

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