Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
Hello all,
Fairly new to Power BI so this might be a repeat message, I have connected an online excel file to Power BI, and as I loaded the data, I got this error.
I am unable to determine what the error is and if I include the errored data in the load and try again:
I then get this error:
How do I determine what the errors are, as I click "View Errors", there is nothing specific that shows up?
Did you connect the Excel file as web source? That is the correct way to do it from Sharepoint.
Just open the Excel in desktop application and browse File - Info - Copy path.
Copy that path as a web source and remove all from question mark to end.
@vmo416 , scroll and check there should be an error column.
Refer video from Curbal : https://www.youtube.com/watch?v=OE6DPmKqN7s
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
98 | |
95 | |
83 | |
70 | |
66 |
User | Count |
---|---|
118 | |
106 | |
93 | |
79 | |
72 |