Forum Discussion

AntWickenden's avatar
AntWickenden
Frequent Visitor
7 years ago

Change Data Within Column

I am in the process of building a fairly basic departmental revenue report in Power BI.   My aim is to update this by allowing the query editor to always refer to the same source csv files. Said so...
Need Help
v-juanli-msft's avatar
v-juanli-msft
Community Support
7 years ago

Hi AntWickenden 

As you said, "source csv files will be updated with new data without changing the file name",

But next you said, the first data source named "Branch Rev Data", the second data source named: "Import Data",

Are they conflicting?

 

For the same file which you connect to with Power BI, If its data changes, then click on "refresh" from Power BI, then new data can be imported and the old data is be replaced.

The refresh process is full refresh, so we can't make some data refresh but some not.

 

There is another feature Incremental refresh in Power BI which you can define the refresh policy.

But it needs a premium subscription.

 

Best Regards
Maggie

 

Community Support Team _ Maggie Li
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

  • AntWickenden's avatar
    AntWickenden
    Frequent Visitor
    7 years ago

    Hi Maggie

     

    Maybe I wasn't too clear on that...

     

    There are 2 CSV source data files, one file named "Branch Rev Data" and the other "Import Data"

     

    My plan is for the raw data files to be extracted from my companies internal systems as an when needed, then saved in the source location for the PowerBI Dashboard using the same naming protocol.

     

    Then I will be refreshing in full using PowerBI...

     

    The change I want to happen without manual input in the "Branch Rev Data" file is changing the word BROKERAGE to IMPORT

     

    I don't ideally want to amend this in the CSV prior to refreshing the data, or amend in query editor either, is there any way of having a rule or measure or something which will automatically convert instances of BROKERAGE in a column to IMPORT instead?

     

    Apologies if that isn't clear, i'm not sure how to better explain it.

     

    Thanks in advance.

    Anthony