Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
3 years ago

Add New Column to existing data in MS Lists

Hello I want to add a new column to the existing data set in my MS Lists and refresh my dashboard.   I have already built a dashboard based on the data set and at the moment the only way aroun...
Need Help
arjaano's avatar
arjaano
Icon for Advocate II rankAdvocate II
1 year ago

I struggled with the same problem. The only way I could get the new column is:

 

  1.  Download the report (under File > Download this file > A copy of report and data (.pbix))
  2. Open the report in Power BI Desktop
  3. Open the linked table in Power Query (under "Transform Data")
  4. Make sure your new column(s) are present
  5. Click Apply
  6. Refresh data
  7. Save
  8. Publish the report back to your workspace
  9. Ready!