Forum Discussion
Question on How and where source data is changed
From what I've learned so far you can add the same source data file, an xlsx file, only once to PowerBI no matter if you are using workspaces. Assume that I load (using Power BI Desktop) the fil...
You should be able to connect multiple PBI items, what are the steps you're using to connect?
In any event PBI doesn't write to excel so transforms should be on the copy within PBI's native data storage.