Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
Hello!
When can I change the data source of a pbit and apply the same workflow of the template to a different data source?
The template was created using a local csv file but I want now to use a file from an ODBC connection.
Thanks!
Hi @UsePowerBI ,
We can open the Advanced Editor in Power Query Editor to change the kind of data source and then save it as a pbit file, please make sure the columns and columns types are same as they are in previous query.
Please refer to this document about more detail about Advanced editor: https://docs.microsoft.com/en-us/power-bi/desktop-query-overview#the-advanced-editor
Best regards,
Thank you, in case the columns are not the same, can we still adjust the template instead of building it from the begining?
How can we manage:
1) change position of a column but keeping the same column name
2) change name of a column but keeping same position
3) adding columns
4) deleting columns
Thanks!
User | Count |
---|---|
98 | |
90 | |
77 | |
71 | |
64 |
User | Count |
---|---|
114 | |
97 | |
95 | |
68 | |
65 |