Forum Discussion

JIN23's avatar
JIN23
Icon for Helper I rankHelper I
2 years ago
Solved

Refresh error in workspace when I connected excel file in sharepoint to Power BI

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 th...
Need Help
  • JIN23's avatar
    JIN23
    2 years ago

    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!!

hackcrr's avatar
hackcrr
Icon for Memorable Member rankMemorable Member
2 years ago

JIN23 

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!

 

JIN23's avatar
JIN23
Icon for Helper I rankHelper I
2 years ago

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!!