Forum Discussion
Sharepoint cant see one file?
Hi garz88,
Based on my test, it's able to get data from SharePoint Excel file which generated by Flow in Power BI.
In your scenario, please go to the target SharePoint site, verify the Excel file is generated and displayed here firstly.
As Power BI supports importing or connecting to workbooks created in Excel 2007 and later. Workbooks must be saved as .xlsx or .xlsm file type and be under 1 GB. See: Get data from Excel workbook files. Please verify the Excel file doens't hit the limits.
To make sure the issue doesn't related to the Flow, please upload the Excel file manually to the same SharePoint folder then get data in Power BI to see if you can do it successfully.
Best Regards,
Qiuyun Yu
Community SupportHi garz88,
Based on my test, it's able to get data from SharePoint Excel file which generated by Flow in Power BI.
In your scenario, please go to the target SharePoint site, verify the Excel file is generated and displayed here firstly.
As Power BI supports importing or connecting to workbooks created in Excel 2007 and later. Workbooks must be saved as .xlsx or .xlsm file type and be under 1 GB. See: Get data from Excel workbook files. Please verify the Excel file doens't hit the limits.
To make sure the issue doesn't related to the Flow, please upload the Excel file manually to the same SharePoint folder then get data in Power BI to see if you can do it successfully.
Best Regards,
Qiuyun Yu
Here's what worked for me -
1. Go to the Sharepoint online site where the excel file is located 2.
2. Use the (...) option next the excel file in Teams site and choose Open > Open in App
3. File opens in Excel. Go to File menu > Info. Use the Copy Path option
4. Paste the path into a note pad and remove the string '?web=1' towards the end.
5. In PowerBI, copy the remaining link and open it using the Web option under GetData