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

Get Fabric Certified for FREE during Fabric Data Days. Don't miss your chance! Request now

Reply
KookHo
Frequent Visitor

Can't configure gateway settings nor data source credentials

I'm using Power BI Pro and created a Power BI report which consumes a web API and a spreadsheet in my workplace's OneDrive. But when I published it on my workplace's Power BI Service workspace, it doesn't allow me to refresh the data, saying the dataset needs credentials. When I go to the dataset's settings, the section "Data Source Credentials" is disabled and I can't configure it. I tried serching for similar issues, but solution solved my problem. 

KookHo_0-1708465186015.png

 

One article said to change my gateways settings, but whenever I try to edit them I just get a console error.

KookHo_1-1708465243014.png

 

 

I also tried publishing in my own workspace but the same issues are present. I need to be able to configure an scheduled refresh of the dataset, but I am unable to do so and I'm out of ideas and solutions. Any help is welcomed.

2 REPLIES 2
GilbertQ
Super User
Super User

Hi @KookHo 

 

Could you try and instal the gateway in standard mode and see if you can then create a data source connection?

 





Did I answer your question? Mark my post as a solution!

Proud to be a Super User!







Power BI Blog

I looked a little into it, but I was told by a coworker that the personal mode would be disabled if my computer was turned off. I suppose the other mode would allow me to run it on a server (?), though I need to check for permissions to use the server. Is that how it is or is there a misconception somewhere?

Helpful resources

Announcements
Fabric Data Days Carousel

Fabric Data Days

Advance your Data & AI career with 50 days of live learning, contests, hands-on challenges, study groups & certifications and more!

October Power BI Update Carousel

Power BI Monthly Update - October 2025

Check out the October 2025 Power BI update to learn about new features.

FabCon Atlanta 2026 carousel

FabCon Atlanta 2026

Join us at FabCon Atlanta, March 16-20, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM.