Anonymous's avatar
Anonymous
Not applicable
3 years ago
Status:
Accepted

Unable to get updated data from dataflow

Hello support, I am having a question that after the refresh of my dataflow, sometimes the reports are unable to receieve the lastest data. So I do some checking by myself. I have checked that in dat...
Reports
analyticsyc's avatar
analyticsyc
Frequent Visitor
3 years ago

I seem to be having a similar issue. My dataset can load in the most recent data from my dataflow, but when I create a new column in my dataflow it is not showing up in my dataset on PowerBI desktop. I am using an ETL process with dataflows as documented here (https://learn.microsoft.com/en-us/power-bi/guidance/powerbi-implementation-planning-usage-scenario-advanced-data-preparation). Since I perform all data transformations in an intermediary dataflow, the dataset on desktop should just load in the new column without any issues. I've also tried creating a brand new PowerBI desktop dataset, and even with loading in the dataflow from scratch, the new columns do not show up. I have refreshed the dataflow multiple times, and I can see the added column in the online preview function. 

Anonymous or anyone else, is the issue I'm describing known? Is there any workaround? Or any ETA on a fix?

 

EDIT

I have figured out a workaround for my own issue. Despite refreshing the dataflow in PowerBI Online, the only way to get the new columns to push to my PowerBI desktop dataset was to refresh the preview in PowerQuery Online (where dataflows are created). Then I refreshed the dataset itself from the workspace. Then refreshed the dataset on PowerBI desktop, and the new column was pulled into the dataset. Not too difficult of a workaround, but I can't say it makes much sense as to why I have to do it. 

 

Thanks for the guidance. 

Completed Ideas