Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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?
Solved! Go to Solution.
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"})
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
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
101 | |
52 | |
21 | |
12 | |
11 |