Forum Discussion
PriscaR
Dec 07, 2021Copper Contributor
Sample files for PowerPivot
Hi community, I'm new and i want to know where i can download samples files to use on my personal try in PowerPivot. I mean, Microsoft sometimes have some ressources that we can use in our test or something like this. Something like "adventure_works" files that we can use on PivotTable.
Thanks.
That could be like
Source = if Text.Start(filepath,5) = "https" then Web.Contents(...) else Csv.Document(...),
but you shall to clean filepath before (remove sheet name and brackets). You may do in sheet by formula or in Power Query by another if then else. Hope it's possible to find ready to use pattern for both.
3 Replies
Sort By
You may download Excel only samples from here Get samples for Power BI - Power BI | Microsoft Docs