Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
4 years ago

Dataflow connection to Power BI Desktop

Hi,   I am new to dataflow and running into some odd issues that really needs some solutions! I created a dataflow to connect the Postgre SQL database, then connecting that dataflow in Power BI De...
Dataflow
Need Help
Tips and Tricks
Anonymous's avatar
Anonymous
Not applicable
4 years ago

Hi bcdobbs ,

Thank you for your response. Yes, the data flow shows as "Refreshed". Also, it is scheduled refreshed daily, and it's working well all the time.
However, please see the below example for my further explanation.
Tables in data flow refreshed my transaction details daily, the incomplete dataset in the Power BI Desktop only affects those transactions that happened most recently.
In this example, on 1/1/2021, transaction lines #5 and #6 is not showing in power bi desktop but dataflow. Later on, on 1/2/2021, the missing data on 1/1/2021 WILL BE populated. Similarly, some data in 1/2/2021 will not show till the next day, and so on.

 

 

 

Thank you!

bcdobbs's avatar
bcdobbs
Icon for Community Champion rankCommunity Champion
4 years ago

Anonymous on the power bi side where are you seeing the data. Is it a visual or the data view? 

  • Anonymous's avatar
    Anonymous
    Not applicable
    4 years ago

    Hi bcdobbs , 

     

    I checked both visual as well as the data view. Unfortunately, they both do not have the completed dataset.