Forum Discussion
Power Query actualization of data
Hello everyone,
I'm new in using Power Bi. Befort starting to work with this useful software I read a lot of books about it. I "learned" to write DAX formulas, to set up dashboards and so on. But it was always with the different access databases like "Northwind"....
Now I'm trying to set up a power query for some data of work. I just have two differents sheets in an excel workbook.
The first sheet contains just content in coloum A. It's a copy of an e-mail content. The content is in a .csv format. After loading the sheet in power query editor I'm using the button for seperating the contant in to different coloums by special signs. In total I get four coloums. Colum one: project number: Coloum two: working step; Coloum three: duration of working step: coloum four: delivery date for the project. The number of used rows in the the excel sheet is dynamic (sometimes just four or five rows; sometimes up to 200 rows)
The second Excel sheets contains data from coloum one to 15. The number of used rows is also dynmic like in sheet one. The sheet contains data about the possible start date of a specifed work step for all projects in the company as well as wished delivery date of the customer, the possible date of delivery for the customer, how is progress of the working step ( is working step in progess, is it just still planned, because raw material is missing), which articles i have to produce for the project and so on.
After combing the content of the first sheet with the second sheet by using the project number I'm adding some coloums of the second sheet to the first query.
(Verspätung is sheet 1; Tabelle 5 is sheet two)
Everything is working fine so far. Saving data and loading it to excel works also fine. Problem is just the updating of all connections, data, etc.
When I delete some rows in both sheets for trying the function of the query for using dynamic numbers of rows the content in the table, which is loaded in to excel still contains the same.
For exmampe in the first try sheet one contains 43 rows, the second sheet 1299 rows.
After deleting some rows in the first and in the second sheets the connetion still contains the same number of rows.
I'm not sure, what I'm doing wrong so far, the the updating is running wrong. I'm happy for every hint to get a right and usefull solution.
Thanks in advance for your help.
Regards Carl, a newbie in Power Query and
4 Replies
Changing source data is not reflected live in Import mode, you need to refresh the query so that Power BI reprocesses and reimports the whole thing. Right click on the query or click on the little refresh icon on the right of the query's name (you can see it in your screenshot).
Once you've published your dataset to the Power BI service you can set up an automatic refresh schedule.
Good Morning Otravers,
I'm using Excel for refreshing the source datas. I just want to create a new table with the datas, but I don't want to use a lookeup function in excel. But also I'm refreshing the data I get still the same fault.
I'm wondering and I'm a little bit confused of the contet of the fist screenshot. I load two sheets in Power Query, transform the fist table (Verspätung) from a form like this, to four separated coloums. (third screenshot)
But in the first screenshot it is note more a sheet, what is loaded in power query. It seems to be a table. Looking up for the right source of the sheet table it is the right path which is used.
I don't know what I'm doing wrong.
P.S. I also tried it to change the content of the sheets first in tables. But that also don't work.
Maybe here I'm doing something wrong. Do I have to save the data and just load it, or do I have to save the date and load it in to the data modell, or do I have to load just a connection??
Thanks for your answer, I will try it later and give you a feedback
