The ultimate Microsoft Fabric, Power BI, Azure AI, and SQL learning event! Join us in Stockholm, Sweden from September 24-27, 2024.
2-for-1 sale on June 20 only!
Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started
Hi Dears,
I have a sharepoint list as my power Bi query. How can I duplicate a certain column and isolate it from the refresh? So whenever the sharepoint list is updated, this duplicated row stays as it is without being updated with the new values.
I intend to do this so I can compare what has been modified on the list.
Thanks,
Solved! Go to Solution.
Go into Query Editor, right click the query and uncheck "Include in report refresh".
Hi @abukapsoun,
If you want to create a new table with a duplicate column you can select new table in the data view with formula:
Newtablename = DISTINCT(YourTable[DesiredColumn])
Although you create a duplicate in a new table this way I am not entirely sure it will be isolated when the original table is updated. You would nee to test if that works.
Regards,
L. Meijdam
You could create a second query and then tag it to not refresh.
Go into Query Editor, right click the query and uncheck "Include in report refresh".
Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.
Check out the June 2024 Power BI update to learn about new features.
User | Count |
---|---|
105 | |
97 | |
80 | |
62 | |
57 |
User | Count |
---|---|
246 | |
119 | |
114 | |
86 | |
70 |