Advance your Data & AI career with 50 days of live learning, dataviz contests, hands-on challenges, study groups & certifications and more!
Get registeredJoin us at FabCon Atlanta from March 16 - 20, 2026, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM. Register now.
Greetings All,
I am trying to schedule refresh dataset in power bi cloud server. It's only wokring whenever I am changing the premission to Database + microsoft account and publish it on power bi server. But I have connected database to a sql server with windows authentication so I have changed the permission to windows authentication and published to power bi server where dataset refresh is not happening. It; showing some acess related errors -
- “Your data source can't be refreshed because the credentials are invalid. Please update your credentials and try again.”
Please help me on this.
For both cases I am using on premises data gateway provided by power bi.
Solved! Go to Solution.
Yes I was using personal gateway and that was the problem. Now it's working well.
Thanks for your time anyway !
Hi @Sankhadeep
Could you show screenshots when the error occurs and which is the error?
"power bi cloud server" refer to Power BI Service, "power bi server" refer to Power BI Desktop, right?
Best Regards
Maggie
Hi @v-juanli-msft ,
From app.powerbi.com I am trying to reshedule dataset where I am facing error.
From PBI desktop app I can update the dataset using same windows credentials.
PFA.dataset refresh error
Hi @Sankhadeep
When you change the permission to windows authentication in Power BI Desktop, publish to Service, do you change the credential under personal gateway?
Best Regards
Maggie
Yes I was using personal gateway and that was the problem. Now it's working well.
Thanks for your time anyway !
Join the Fabric FabCon Global Hackathon—running virtually through Nov 3. Open to all skill levels. $10,000 in prizes!
Check out the October 2025 Power BI update to learn about new features.