Forum Discussion

Kave's avatar
Kave
Regular Visitor
4 years ago

Data flow in Power BI Service

Hi, How can I edit a data flow in Power BI Service, and automatically have the new edition in Power BI service? I mean, have some changes in DataFlow in a workspace, then after refreshing, see thos...
Dataflow
Kave's avatar
Kave
Regular Visitor
4 years ago

Thanks, blopez11 

It's strange! I checked again all the refresh steps and connections among DataFlow, Dataset, Report, etc.

But nothing, no success! I can't get the updated report on the PBI service, unless I download it, open it in PBI Desktop, refresh, and upload it again into the BPI service again.
Do you have any idea, please? 

Here is the lineage view:

 

blopez11's avatar
blopez11
Super User
4 years ago

The refresh completion times of the dataflows and the dataset seem to be really close to each other (within a minute of each other)

Can you stagger the start time of the refresh for the dataset in the service to be at least 10-15 minutes after the dataflow refreshes are expected to complete?....This way you can rule out any timing issues...Or just try a manual refresh of the dataset in the service much later than when the dataflow refreshes completed

  • Kave's avatar
    Kave
    Regular Visitor
    4 years ago

    Oh, no...
    I found something strange!
    The report in the cloud just shows the changes in the column (transforming); NOT added column! And for having all the changes, I've to refresh it in the Desktop version. 
    Does it make sense?

    Note that the source of the DataFlow is an Excel file in the cloud (Azure). And I'd like to add a column in the DataFlow, not in Excel. Anyway, if it doesn't work, I should change the Excel.