Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
7 years ago
Solved

Dynamically change data source

I have a quite specific use-case that is testing my capabilities. And probably going against intended use of Power BI.   I have a report that calculates TCO of Microsoft Azure Products based on dat...
Need Help
v-juanli-msft's avatar
v-juanli-msft
Community Support
7 years ago

Hi Anonymous

As tested, if file "csv1.csv" and "csv2.csv" have the same table structure

(they have the same columns and columns' names, only the values of the cells are different from two files)

for example

csv1.csv

a b c d e
1 3 1 1 1
2 4 2 2

2

csv2.csv

a b c d e
10 10 10 10 10
11 10 10 10 10

 

 

Then when you import csv1.csv into Power BI Desktop, and create a visual using columns from it,

You could also change the data source to csv2.csv in the same pbix.

go to Edit Queries->Data source setting->change data sources->click on "Browse"

 

Select csv2.csv, then click "ok"->click on "apply changes"

 

Best Regards

Maggie

 

Anonymous's avatar
Anonymous
Not applicable
7 years ago

Hi Maggie

 

Thank you for your reply, that indeed works. But what I am looking for is a little less work (things that can go wrong) if my colleagues applies new sources.

 

I've heard a little about you can create query parameters, and save the report as a template. So when it opens it will prompt for the location of the .csv files. This is closer to what I am looking for, but would still prefer something similarly to what you can do with Powershell and using the ".\" path that points to the location of the script. Here it would instead be the location of the power-bi report.