Forum Discussion
Dataset not refreshing from table storage
In Power BI Desktop I added an Azure table storage datasource, but then realized we were missing data. After modifying the table storage fields (removed one field and added two via Stream Analytics output) and populating some data, I am unable to get the revised dataset to load into Power BI. Even though we've confirmed the revised "schema" and I clicked "refresh" on the dataset, I'm still only seeing the old fields. How do I completely flush the old dataset from Power BI?
Just figured out that the dataset was refreshing, the query just wasn't showing the new columns when I chose to 'Expand' the Content column. Apparently, it won't pick up the revisions automatically, you have to go into the query editor's query line and add the new column to be expanded (e.g. new_field) manually.
= Table.ExpandRecordColumn(data_set_name, "Content", {"new_field", "existing_field1", "existing_field2"}, {"new_field", "existing_field1", "existing_field2"})
2 Replies
Just figured out that the dataset was refreshing, the query just wasn't showing the new columns when I chose to 'Expand' the Content column. Apparently, it won't pick up the revisions automatically, you have to go into the query editor's query line and add the new column to be expanded (e.g. new_field) manually.
= Table.ExpandRecordColumn(data_set_name, "Content", {"new_field", "existing_field1", "existing_field2"}, {"new_field", "existing_field1", "existing_field2"})Thanks so much. Worked a treat for me
