New to Power BI

[macemit]

Hi,

Very new to Power BI (I'm connecting with Salesforce). Couple of questions:

1) Is there a danger of changing the source data that resides in Salesforce's databases? If I add calculated field's or new tables for example, is this reflected in SF? Obviously I do not want this to happen.

2) Do I need to load any table whose data I wish to see? Or would a currently loaded table with a unique ID from a non-loaded table be enough to pull the related data from said non-loaded table?

Thanks.

[Chihiro · Accepted solution]

1) PowerBI does not alter source data in any way. It's read into model, but does not write to source.

2) You could query using unique ID from source, but data will need to be brought in one way or another. Not necessarily the entire table, but the data you need in analysis.