Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
Good day, the Community
I created a Power Query that normalizes data in a CSV file. I'm looking for a solution, that my colleagues could use these steps.
the challenge is to make it as simple as possible for them.
Once a week, each of us downloads the raw data in CSV, normalizes it and uploads it to Salesforce. The raw data CSV file, as well as normalized CSV file, are archived after.
Pasting the M code to the Advanced Editor of the new file is too difficult
Ideal is to create a dedicated folder, each week add a new raw data CSV file, refresh the excel table, save the result, archive the raw data CSV file
many thanks
Solved! Go to Solution.
@maisryshyn Use a dataflow?
@maisryshyn Use a dataflow?
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
102 | |
53 | |
21 | |
13 | |
11 |