Forum Discussion
Helper IPower BI Publisher Authentication
Hello!
I have some problems with Power BI Publisher.
I installed Power BI Publisher on few PCs and on the 2 of them I have problem with storing Logins and Passwords automatically when I update the data.
I have some reports in Exel and when I try to Update ALL I have to fill my Password for Azure for every table in my report.
I have reports wich contain more than 20 tables. It's terrible!
I have this problem only on 2 computers. The same Windows.
The same Excel. What am I doing wrong?
Yes, I solved the problem. Problem was in domain preferences for users. They couldn't store any passwords in their computers. I created trusted local area for storing that.
I added
[HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Cryptography\Protect\Providers\df9d8cd0-1501-11d1-8c7a-00c04fc297eb] "ProtectionPolicy"=dword:00000001
to registry and it worked
8 Replies
- Greg_Deckler
Community Champion
I guess, start with what version of Windows, 32-bit or 64-bit, version of Power BI Desktop (File | Options and settings | Options | Diagnostics). How many machines does it work on and what are the differences between those installs?
UstinovdlI didn't install Power BI Desktop. Only Power BI Publisher for Excel 32-bit.
I have the same Windows x64 on all computers.
On some computers I filled the Login and Password once and I can Refresh the data without doing that again for every refreshing datasets in the report.
For 2 other computers I have to do it a lot of times.
I don't know what information I can give you for solving this...
- Ustinovdl
I pinned the same account in Azure in Power BI Publisher. On 8 PCs it stored automatically. On others no.
- Greg_Deckler
Ah, sorry. Power BI Publisher. Hmm. Maybe something to do with Trusted File locations or something? Or some Excel setting perhaps. I'll have to research that one.
