Forum Discussion
AadityaH
4 years agoNew Member
Using Excel as dataset in Report Server
Hi All, In one of my PowerBI report , only datasource I have is an excel file . However whenever I publish this data to server , users cannot see the report as my organization does not suppor...
- 4 years ago
Hi AadityaH
If you can place the Excel file on OneDrive for Business, or SharePoint Online, or Google Drive, or AWS drive or Dropbox, or some similar online repository, you should be able to connect to it with Power BI and then have it refresh without needing a Power BI Gateway.
Hope this helps
Stuart
Burningsuit
4 years agoResident Rockstar
Hi AadityaH
If you can place the Excel file on OneDrive for Business, or SharePoint Online, or Google Drive, or AWS drive or Dropbox, or some similar online repository, you should be able to connect to it with Power BI and then have it refresh without needing a Power BI Gateway.
Hope this helps
Stuart