Power BI is turning 10! Tune in for a special live episode on July 24 with behind-the-scenes stories, product evolution highlights, and a sneak peek at what’s in store for the future.
Save the dateEnhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.
Hii,
I have installed On-premises data gateway on my serer where my excel file resides. Its not personal.
I have two servers with two databases and excel files on two servers. So I want to create data refresh from two servers on PBI reports.
Getting following error when trying to connect Dataset to Gateway datasource...?
What User Id and Password does it need?
Please guide how to configure it? Thanks
Solved! Go to Solution.
@ranaanees,
Username and password are required when adding Excel data source within gateway. Please review my reply in this similar thread about how to find username.
Regards,
Lydia
thanks @v-yuezhe-msft,
I was entring user name without Domain Name.
The correct way is
User Name: Domain\User Id
Thanks,
@ranaanees,
Username and password are required when adding Excel data source within gateway. Please review my reply in this similar thread about how to find username.
Regards,
Lydia
thanks @v-yuezhe-msft,
I was entring user name without Domain Name.
The correct way is
User Name: Domain\User Id
Thanks,
Check out the July 2025 Power BI update to learn about new features.
This is your chance to engage directly with the engineering team behind Fabric and Power BI. Share your experiences and shape the future.
User | Count |
---|---|
9 | |
7 | |
5 | |
5 | |
5 |
User | Count |
---|---|
10 | |
8 | |
6 | |
6 | |
6 |