Forum Discussion
Power 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
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?
I 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...
I pinned the same account in Azure in Power BI Publisher. On 8 PCs it stored automatically. On others no.
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.
