Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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?
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.