I'm very new in Power BI. I made a report, but as time went on I had to transform data before insert them in PowerBI. So now I need to change the source of my data in graphics (like we can do in Excel for example). If I change this field by field, I had to update colors,... Is it possible to change data without starting over again ?
2 Answers
1
votes
I think I had a similar problem a while ago, when the database my Power BI report referred to was moved.
What I did (in Power BI Desktop app, using Direct Query) was under "Home" clicking on the drop-down menu "Edit Queries" at the top left corner, then selecting "Data source settings". In the new window I clicked the button "Change source settings". Then I changed the settings to the new location of the server and database. See the attached link (including a picture) for information. detailed
0
votes
yes you can do it, but you need to be aware that the old source and the new source had the same information. I mean if you have a field A in your old source database, that you transform in the new database it should be named A like before, and with the same datatype, over wise you will need to review your data importation rules.
However to do this go on the tab "Home" then click on "Edit Queries" drop down menu and select the "Data Source Settings"
Another way to do this is to edit the query with the "Edit Queries" button and then on the right hand side click on source in the Applied Steps area. Applied Steps area
I hope that I answered to your question.
