Forum Discussion
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
- Greg_DecklerCommunity Champion
Difficult to troubleshoot. You could check the Issues forum here:
https://community.powerbi.com/t5/Issues/idb-p/Issues
And if it is not there, then you could post it.
If you have Pro account you could try to open a support ticket. If you have a Pro account it is free. Go to https://support.powerbi.com. Scroll down and click "CREATE SUPPORT TICKET". - v-alq-msftCommunity 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 RegardsAllan
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
- TheDaniel007Regular Visitor
Hello did you find a soltuon for this? I am facing the same issue
thank you in advance- AliceWPower 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!