Power BI is turning 10, and we’re marking the occasion with a special community challenge. Use your creativity to tell a story, uncover trends, or highlight something unexpected.
Get startedJoin us for an expert-led overview of the tools and concepts you'll need to become a Certified Power BI Data Analyst and pass exam PL-300. Register now.
Hi
I have connected excel file saved in sharepoin to power bi then built the report & publish.
But refresh is failed in workspace even I can refresh at power bi desk top.
Here is the step that I have taken.
1. Open excel file --> click info --> copy path
2. In power bi desk top --> web --> paste path of the file
3. Cridential --> Organizational account
4. excel sheet format --> Table
I could build all the report and also could refresh the data in powerbi desktop without any issue.
But after I publish to my power bi. it said refresh fail and the reason was
"
I am not so sure what is the reason since I have another report connected with another excel file saved in another sharepoint and with same step, it works fine.. but not this one.
Any one can help?
Perhaps, is it something to do with my access level to this sharepoint? Like just normal member of sharepoint can not perform this??
Thanks
Solved! Go to Solution.
I found the season that it was due to excel type that I am using binary one which is not supported... The thing is power bi folder or list is not also working. so I will change file type to make it work. thanks for the support!!
Instead of using the "Web" connector, try using the "SharePoint Folder" or "SharePoint Online List" connectors in Power BI Desktop. Go to Get Data-> SharePoint Folder. Enter your SharePoint site URL, e.g. https://yourcompany.sharepoint.com/sites/yoursite
Navigate to the Excel file and select it.
Best Regards
hackcrr
If I have answered your question, please mark my reply as solution and kudos to this post, thank you!
I found the season that it was due to excel type that I am using binary one which is not supported... The thing is power bi folder or list is not also working. so I will change file type to make it work. thanks for the support!!
This is your chance to engage directly with the engineering team behind Fabric and Power BI. Share your experiences and shape the future.
Check out the June 2025 Power BI update to learn about new features.
User | Count |
---|---|
76 | |
74 | |
57 | |
38 | |
33 |
User | Count |
---|---|
71 | |
65 | |
58 | |
50 | |
47 |