Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and a 50 percent discount on exams.
Get startedEarn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
Hello All,
I'm pretty new to Power BI and the little I know is from a series of trial and error using information I picked up on the net.
I have managed to create and publish a report and would like to setup automatic refresh.
The report was created using a combination of Excel files stored on my machine as well as data pulled from an SQL server connection.
IT has setup an Enterprise Gateway on my Power BI account that I am now trying to configure. I am able to use the SQL credentials to setup the data source for the SQL database but I am not sure how to setup the data source for the excel file; it asked for a windows username & password.
Solved! Go to Solution.
Since the excel files are stored in your machine, you have to provide windows credentials in the gateway settings. Make sure that excel files are accessible from the gateway server.
But storing the data source in a local machine is not a recommended approach. I would recommend you to keep the files in some other location. Example SharePoint folder, the same sever where gateway or SQL server installed. etc.
Did I answer your question? Mark my post as a solution!
Appreciate with a kudos 🙂
Hi @roxmasters20 ,
For the on premise data source excel files, you need to offer the window credential which is just the account and password to sign in your computer, like domain\username. For example, your organizational email account is username@abc.com, then you may type abc\username and password in Data Source Settings.
Best Regards,
Amy
Community Support Team _ Amy
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Hi @roxmasters20 ,
For the on premise data source excel files, you need to offer the window credential which is just the account and password to sign in your computer, like domain\username. For example, your organizational email account is username@abc.com, then you may type abc\username and password in Data Source Settings.
Best Regards,
Amy
Community Support Team _ Amy
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Since the excel files are stored in your machine, you have to provide windows credentials in the gateway settings. Make sure that excel files are accessible from the gateway server.
But storing the data source in a local machine is not a recommended approach. I would recommend you to keep the files in some other location. Example SharePoint folder, the same sever where gateway or SQL server installed. etc.
Did I answer your question? Mark my post as a solution!
Appreciate with a kudos 🙂