Forum Discussion
Unstructured data taking values from one record and combining those values with other records.
Do you have the option to put steps 1 & 2 into a Dataflow? This would force that stage to be evaluated only once.
I'm not sure I have access to create a connection to a local folder from PowerBI online. The next button is greyed out. If I create a connection using a blank query and cut paste in from my original PowerBI desktop query, it comes up saying credentials are required to connect to the folder source. When I click to modify those, the connect button is greyed out.
Going back to my original query, I was hoping that as I filter the data that the query would run faster as it completes through the query steps. However what I seem to see is multiple reads back to the original input text files. I have 3 10MB files but the read count bottom right is reaching hundreds of MB. I am new to PowerBI (probably mentioned that before). It would be good to read the data and filter it once. Does that form the data in the data model? Not sure of the correct terminology. Then the rest of the steps work on that cached data?