Forum Discussion

AliceW's avatar
AliceW
Power Participant
6 years ago

Dataflow shows as empty table when connected to dataset

Hi guys,

I'm building my second dataflow and I am stuck. I could really use some help, please.

So, I've created the dataflow (comprising of one table) in Service. I can see the lines loaded.

Then, I set incremental refresh: Store rows for the past 6 years, and refresh rows from the past 3 days, based on a column called LastModifiedDate.

I clicked on 'refresh now'... It worked.

I entered the dataflow again and I see some additional query steps build in, and some new queries (range). I didn't do anything to them.

However, when connecting to the dataset, I get the 'the table is empty' mention.

What is happening, please?

Thanks,

Alice

 

4 Replies

  • v-alq-msft's avatar
    v-alq-msft
    Community Support

    Hi, AliceW 

     

    After creating the new dataflow, you may refresh the dataflow on service to make data loaded into the entity and then click the "Refresh" button in "Navigator" pane. If no data is shown, please clear permissions under "Data Source settings", and create the connection to dataflow again. If it still doesn't work, you may create a support ticket here .

    Best Regards

    Allan

     

    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

  • Hello did you find a soltuon for this? I am facing the same issue
    thank you in advance

    • AliceW's avatar
      AliceW
      Power Participant

      Hi TheDaniel007, I dropped the incremental refresh. 

      Mostly because I kept getting lines that were NOT updated. 

      A full refresh just works. 

      Good luck!