Forum Discussion
Advocate IIHiding Tables in Desktop
Mfelix,
I would be very glad if you did - thanks. And for extra bonus points, could you show how to pick out field names, change the field names, and set data types (e.g. specify text field, a date field etc)?
However I do worry that as I'm working with semicolons as the field delimiter, and the input files in a few cases have semicolons in them, I might run into trouble. At least when I used Power Query I could see by looking at the last column if the fields had shifted due to a semicolon in the text.
But I'd still love to learn and understand the method you're describing.
Thanks again, R.
Super UserHi Anonymous,
The Power BI works with power query to treat the file so if you already have knowledge in that part the transiction will be easy, so the picking fileds, changing names set data types you already now how to do it.
Just one additional question are all your CSV files equal or do they have different columns and the end result is differente from the starting files?
Turns out the solution to my problem was very simple indeed - just right click on the table in Power Query and uncheck "Enable Load" (but leaving the "Include in Refresh").
:-) Ragnar
Happy New Year Mfelix!
The columns have different names (although some are the same) as they originate from different ERP systems. And the end result is different as I only use a fraction of the columns.
Good point about just looking at the code generated from just using Power Query. Of course I could adopt those into a M script that does all sorts of clever things.
Regards,
Ragnar
- ImkeF
Community Champion
Another option is to disable the load of the tables in the query editor like described here:
They will not be loaded into the datamodel, so this is only suitable for tables that are actually not going to be referenced in the data model.
