Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Be one of the first to start using Fabric Databases. View on-demand sessions with database experts and the Microsoft product team to learn just how easy it is to get started. Watch now

Reply
Seb_89
Frequent Visitor

SQL -Server Authentication on Power BI

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

What should i chose in 

 

Bez tytułu.png

Seb_89_1-1722254846757.png

 

 

im using Windows Authentication on SQL SERVER

Seb_89_2-1722255195857.png

 

 

Thank you for Help 😉

7 REPLIES 7
Seb_89
Frequent Visitor

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 ?

Seb_89
Frequent Visitor

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 ?

Seb_89
Frequent Visitor

@bradsy 
Thank you for solution but still have isusse.

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

Seb_89_0-1722431308092.png

 

Can u tell my what shoul i put as login.

Seb_89
Frequent Visitor

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

Seb_89_0-1722324085593.png

When i click save it dint save settings ;/

Greg_Deckler
Super User
Super User

@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.



Follow on LinkedIn
@ me in replies or I'll lose your thread!!!
Instead of a Kudo, please vote for this idea
Become an expert!: Enterprise DNA
External Tools: MSHGQM
YouTube Channel!: Microsoft Hates Greg
Latest book!:
Power BI Cookbook Third Edition (Color)

DAX is easy, CALCULATE makes DAX hard...

Seb_89_0-1722324665561.png

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.

 
 

 

 

bradsy
Microsoft Employee
Microsoft Employee

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

 

Helpful resources

Announcements
Las Vegas 2025

Join us at the Microsoft Fabric Community Conference

March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount!

November Carousel

Fabric Community Update - November 2024

Find out what's new and trending in the Fabric Community.

Dec Fabric Community Survey

We want your feedback!

Your insights matter. That’s why we created a quick survey to learn about your experience finding answers to technical questions.