Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more.
Get startedGrow your Fabric skills and prepare for the DP-600 certification exam by completing the latest Microsoft Fabric challenge.
Hi All
I have some data source that is connected to our organisational one drive (excel). In order to do a scheduled refresh, I'm required to input the credentials but organisation authenication is not available under the authentication type. Tried anonymous and windows authenication, the error shows:
"The report server couldn't connect to the data source using the information you entered. Make sure you've entered the connection string and any credentials correctly."
If organizational authentication is not available as an authentication type, you may need to set up a data gateway to allow for scheduled refresh of your Excel data source from OneDrive in Power BI.
Here are the high-level steps to set up a data gateway:
Once you have set up the data gateway and scheduled refresh, you should not need to enter your credentials every time you refresh the data.
Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.
Check out the June 2024 Power BI update to learn about new features.
User | Count |
---|---|
11 | |
10 | |
4 | |
1 | |
1 |
User | Count |
---|---|
16 | |
16 | |
4 | |
3 | |
2 |