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.
Hello Power BI enthusiasts,
I am very new to PowerBI, I have just been assigned a task:
Every month we get a new dataset as a .txt file, which is put in a folder.
The file name changes each month:
(Example)
TCategory_01_2022_PROD.txt
to
TCategory_02_2022_PROD.txt
(Example finished)
This .txt file then has to be made into a report in PowerBI. Currently this is done manually where we create a new PowerBI report, make all the graphs and input the Power Queries manually.
I can't by the thread seem to figure out how i can make a template that includes both all my graphs and the Power Query.
If possible, can someone make a step-by-step solution to this problem.
As mentioned Power BI is very new to me so i only know the very basics.
I could see that there is a post called "How to create a template with a different data source every time?", but sadly I couldn't figure out how to do it through that thread.
Best regards,
Mads
Solved! Go to Solution.
Hi, @Anonymous
Pleae try follow steps to create data source parameters.
1. Connect to your .txt file
2. Go to 'Tansform Data' and new a parameter in 'Manage parameters'
3. Then you can use new parameter to replace your original datasource URL in the first step of 'Applied Steps'.
4.Close&Apply and you can export PowerBI template
For more details, please refer to this tutorial.
Easily add query parameters to your source paths in Power Query
Best Regards,
Community Support Team _ Eason
Hi, @Anonymous
Pleae try follow steps to create data source parameters.
1. Connect to your .txt file
2. Go to 'Tansform Data' and new a parameter in 'Manage parameters'
3. Then you can use new parameter to replace your original datasource URL in the first step of 'Applied Steps'.
4.Close&Apply and you can export PowerBI template
For more details, please refer to this tutorial.
Easily add query parameters to your source paths in Power Query
Best Regards,
Community Support Team _ Eason
Thank you so much 🙂 Works perfectly
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 |
---|---|
109 | |
98 | |
77 | |
66 | |
54 |
User | Count |
---|---|
144 | |
104 | |
100 | |
86 | |
64 |