Moving Power BI data from OneDrive to SharePoint

• Step 1:
  • Sub step of step 1
• Step 2:
• Step 3: Change data source
• Step 4: Change sample file source

Step 1:

1. jdsfasdlflsdjf

Sub step of step 1

Step 2:

1. In the “Queries” left side bar, under “Other Queries” select the folder connection query you want to change source from OneDrive to SharePoint.
2. If prompted provide credentials

Step 3: Change data source

1. On the right side of the Power Query interface, under “Query Settings” in “Applied Steps” select the “Source” step, it would be probably the first step.
2. Then go to the formula bar
3. Change folder source – from something starting with “Folder.Files”`= Folder.Files(“C:\Users\[username]\OneDrive – [OrgName]\[folder path]”)` to a SharePoint folder `= SharePoint.Files(“https://[OrgName].sharepoint.com/sites/[YourSiteName]/“, [ApiVersion = 15])`
4. Again you may be prompted to provide credentials
5. Filter “Folder Path” column to the desired folder. It will create a new step after the “Source” step.

Step 4: Change sample file source

1. Locate the file: Under “Queries”  find the folder “Transform File from [YourFolderName]”. In this folder there is a folder named “Helper Queries”. Select “Sample File”.
2. Under “Query Settings” in “Applied Steps” select the “Source” step, it would be probably the first step.
3. Then go to the formula bar and change folder source – from something starting with “Folder.Files”`= Folder.Files(“C:\Users\[username]\OneDrive – [OrgName]\[folder path]”)` to a SharePoint folder `= SharePoint.Files(“https://[OrgName].sharepoint.com/sites/[YourSiteName]/”, [ApiVersion = 15])`
4. Again you may be prompted to provide credentials
5. Filter “Folder Path” column to the same folder as the main folder. It will create a new step after the “Source” step.