Hi everyone,
Apologies for the naive/newbie question - hopefully I'm doing something daft which is easily rectified!
We have an Excel Spreadsheet called 'all students' stored on sharepoint, which uses a power query to collate 6 separate CSV files into two appended queries (these CSV files are automatically uploaded to sharepoint at midnight every day - three contain lists of students from three separate schools, three contain details about their respective attendance and punctuality) .
We have a data model in the 'all students' spreadsheet which links the two queries by a unique person identifier - so far so good?
I added this Excel document to Power BI (the online 365 version) using Get Data, and created some basic reports from this which look very nice and user friendly.
I then realised I needed to add a measure/calculation to our data model, so I went back and added this. Saved. Refreshed in Excel. Closed Excel. Clicked 'Refresh Now' button in Power BI > Workspaces > Worksheet (because I'm assuming the connection is frequent but not live?).
The new measures don't appear in our reports... any idea what I'm doing wrong? Is it possible that Power BI isn't refreshing properly, or is there something inherently wrong with my structure/approach?
Apologies, this is only day 2 using Power Pivot / Power Query / Power BI.
Thanks
Stephen
