Changing file location after creating a dashboard | Forum

Resolved · Medium Priority · Version 2016

Tue 17 Sep 2019, 16:49 Delegate David said...

David has attended:
Power BI Modelling, Visualisation and Publishing course

Changing file location after creating a dashboard

Morning,

I'm still having access issues with IT so to speed things up I'm considering moving my data source from Sharepoint to a company shared drive, until IT can give me access to the Sharepoint file via Power BI.
If I construct a dashboard based on information on the company shared drive, how difficult would it be to migrate the data source from the shared drive to SharePoint at a later date and move the pathway in Power BI.
I don't really want to construct the dashboard twice due to different data locations.
Thanks

Dave

Tue 17 Sep 2019, 21:04 Trainer Jens said...

RE: Changing file location after creating a dashboard

Hi David,
Thank you for the forum question.

What is your data source? Have you stored the data in an Excel file?

Normally it is not a problem to move the data source for a Power Bi report. After the source is moved you will need to change the path to the new destination. It can be done in the query editor in the advanced editor. You will find the path to the old destination at the top.

Kind regards

Jens Bonde
Microsoft Office Specialist Trainer

Tel: 0207 987 3777
STL - https://www.stl-training.co.uk
98%+ recommend us

London's leader with UK wide delivery in Microsoft Office training and management training to global brands, FTSE 100, SME's and the public sector

Training courses

	98.8 % recommend us
	More live stats...

Active questions
Advanced/consultancy questions
Today's questions
Unanswered questions
Popular forum topics

Power BI tip:

Data Model Shortcuts

Ctrl + Shift + L: Create a relationship between tables.
Ctrl + K: Create a new calculated column.
Ctrl + Shift + N: Create a new table.
Ctrl + Shift + K: Create a new measure.
Ctrl + D: Duplicate selected table or measure.

View all Power BI hints and tips