topic Re: SQL -Server Authentication on Power BI in Report Server

SQL -Server Authentication on Power BI

Seb_89 — Mon, 29 Jul 2024 12:21:10 GMT

Hi im using SQL Server. I put my report on my workspaces and i cant set refersh.

What should i chose in

im using Windows Authentication on SQL SERVER

Thank you for Help 😉

Re: SQL -Server Authentication on Power BI

Greg_Deckler — Mon, 29 Jul 2024 13:31:44 GMT

Seb_89 If you are using Windows authentication and that is how you originally connected to SQL Server when creating your PBIX file then you should select Windows without impersonation.

Re: SQL -Server Authentication on Power BI

Seb_89 — Tue, 30 Jul 2024 07:23:14 GMT

Hi Greg_Deckler thank you for help but i cant save that settings

When i click save it dint save settings ;/

Re: SQL -Server Authentication on Power BI

Seb_89 — Tue, 30 Jul 2024 07:33:15 GMT

When i download my report in to the desktop i have that kind of authorization. But on power Bi online even if i set the same still can't save it and still dont referesh.

Re: SQL -Server Authentication on Power BI

bradsy — Tue, 30 Jul 2024 22:30:09 GMT

If I understand correctly, you have an on-premise SQL Server you want to use. For this, you will need to use a Gateway. The service cannot contact an on-premise SQL Server directly. https://www.microsoft.com/en-us/power-platform/products/power-bi/gateway

Re: SQL -Server Authentication on Power BI

Seb_89 — Wed, 31 Jul 2024 13:09:41 GMT

bradsy
Thank you for solution but still have isusse.

Im not sure what should i put on login s.kubiak@Company.xx ?

Can u tell my what shoul i put as login.

Re: SQL -Server Authentication on Power BI

Seb_89 — Thu, 08 Aug 2024 09:17:06 GMT

Thank you all.

Should i give mine e-mail or it cloud be virtual e-mail, Admin@company.com I wonder it could be better if i install on Always on PC as acc Admin@company ?
What if that email dont have power BI Acc ? I will be working or it should be nessesery mine e-mail ?

Re: SQL -Server Authentication on Power BI

Seb_89 — Tue, 13 Aug 2024 10:04:36 GMT

Can i have put mine acc or i can put virual acc for exampel Admin@company.xx
I wonder if someone will stop working in company when i will put admin acc it will be much more better ?
What do u thnik ?