Create a report with DW File Storage files and upload in VAP
You can use files from Data Workbench File Storage in a Power BI report and upload the report in VAP. Start by generating a SAS access token to the file or to a...
You can use files from Data Workbench File Storage in a Power BI report and upload the report in VAP. Start by generating a SAS access token to the file or to a folder.
For more information about Data Workbench File Storage, go here.
To generate an access token for a File Storage file
- Go to Data Workbench and select the Data Catalogue tab.
- Select File storage.
- In the row with the file, select the three dots menu.
- Select Generate keys.
Then:
- Under Set access level, select Read.
- Under Set access end, set a date and time when the access should expire.
- Select Generate key.
Finally, select Copy key.

To generate a SAS token at folder level in File Storage
You can generate a SAS token for an entire folder and use it for all files in that folder.
- In Data Workbench, open Data catalogue.
- Go to File storage.
- Select the action menu (three dots) on the right.
- Select Generate workspace keys.
Then:
- Under Set access level, select Read.
- Under Set access end, set when the access to the folder should expire.
- Select the Generate key button and a new Access key section will show.

Finally, select the Copy key button to copy the access key. You will use it when connecting to files from that folder in Power BI.
To use a File Storage file as a data source in a Power BI report
Open Power BI Desktop.
From the Home tab, select Get Data and then Web.

Choose the appropriate option below.
Using a SAS token for a single file
In From Web, select Advanced.
Under URL parts:
- In the upper box, paste the part of the SAS URL that is before the
?character. - In the lower box, paste the part of the SAS URL that starts with
?, including?.
- In the upper box, paste the part of the SAS URL that is before the
Select Ok.

In the dialog that appears, select Ok.

Build visuals and save the
.pbixfile.
If you have several files, repeat the steps for each file.
Troubleshooting: "Access to the resource is forbidden"
Power BI may reuse a cached connection string.
To fix:
- Go to File > Options and settings > Data source settings.
- Find the data source, right click, and select Clear Permissions.
- Reconnect by entering the correct URL and query parameters.

Using a folder-level SAS token for multiple files
- In From Web, select Advanced.
- In URL parts, paste the folder SAS URL up to and including the folder path, then append the specific filename, for example
.../FolderName/SubFile.csv. - Use the query parameters from the folder SAS token (the part beginning with
?) for authentication. - Repeat for each file you want to load.
Upload the Power BI file in VAP
- Open your VAP service.
- Open Admin Module with a Data, Report, or System Admin role user.
- From the side menu, select the + icon and select Add Resource File.
- Upload your
.pbixfile. - If the file uses a File Storage data source and this is the first time the source is added in this service:
- Select Edit on the uploaded resource.
- Change Data Source Sub Type from
WebtoDWB File Storage. - Select Save.
- The Credential section appears. Paste the SAS token into Credential.
- Select Update to apply.
- Select the refresh icon to validate the connection.
- When you see "Connect to data source successfully", select Save again.
If you skip setting the correct Data Source Sub Type, the token field will not appear and the connection will fail.
If the same File Storage source was previously connected in this service:
- The saved credential is reused.
- Still change Data Source Sub Type to
DWB File Storageand select Save.
To update the SAS token later:
- Select the link or key icon next to the data source.
- Paste the new token.
When the resource file connects successfully, select the + icon again and choose Add Report to register the report in VAP.
Enable scheduled refresh in VAP
See the refresh plan details here.
A scheduled or on-demand refresh will fail if:
- The file structure changed.
- The SAS token expired.
- The file was deleted or the replacement filename does not match.
Update files in File Storage and refresh in VAP
To update the data used in the report, upload a new version of the file to the same folder using the same filename to overwrite the old one. After that, refresh the resource in VAP (scheduled or manual) to load the new data.