Refresh sharepoint data from sharepoint excel file on Power BI.com

Hi Anonymous ,

If you get data from sharepoint excel file, you can just import data from the arrow icon on the left-bottom of power bi service, then enter your sharepoint site url. And import mode.

This dataset will be refreshed from sharepoint without gateway. The screenshot of dataset settings as the following picture. No Gateway Connection.

If you have multiple data sources, then you need to install gateway.

For more details you can refer these articles.

Get data from Excel workbook files - Power BI | Microsoft Docs

Refresh a dataset created from an Excel workbook - cloud - Power BI | Microsoft Docs

Best Regards

Community Support Team _ chenwu zhu

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.