Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
All
I have an Excel file in OneDrive for Business that I created a PowerBI dashboard on through on-prem gateway. Now I wanted to move my Excel file to my Team's SharePoint online and connect it through Data Gateway. I tried adding new data source with file types - File, Folder, SharePoint, Web with no success in connecting. Has anyone connected this way? Need a quick 101 on how to do it. Appreciate your help
- v
Hi @Anonymous,
If you want to get a excel file stored in sharepoint online, you can connect it directly. The data refresh doesn't need gateway. As what said in the article: If you save your files on OneDrive for Business or SharePoint – Team Sites, and then connect to or import them into Power BI, your dataset, reports, and dashboard will always be up-to-date. Because both OneDrive and Power BI are in the cloud, Power BI can connect directly to your saved file, about once every hour, and check for updates. If any are found, the dataset and any visualizations are refreshed automatically.
Please click Get Data->files->SharePoint-Team sites->Type the URL, you can import the data into service.
Best Regards,
Angelia
@Anonymous Have you seen this tuturial at powerbi.tips?