Forum Discussion

melpbi's avatar
melpbi
Frequent Visitor
7 years ago

Redshift dataset refresh not working properly

Dear Power BI Community,   It's nice to greet you all :)!   Lately i'm having an issue with my data from Redshift: I have a dataset connected to Amazon Redshift both in Power BI Desktop and  sche...
Need Help
Anonymous's avatar
Anonymous
Not applicable
7 years ago

melpbi ,

What is your Power BI Desktop version? Do you also get old data after refreshing report in Power BI Desktop? If so, could you please re-connect to the Amazon Redshift data source in a new PBIX file and then check if the issue still occurs?

Regards,

Lydia

  • melpbi's avatar
    melpbi
    Frequent Visitor
    7 years ago

    Hi Anonymous! Thank you for your reply.

     

    This is the version i'm running: 2.66.5376.2521 64-bit (february, 2019).

     

    Yes, I get the old data. This has happened twice now: I'm looking for weekly sales in my dataset and I should have the first 9 weeks of this year but I only have until week 8. Last time it happened to me I was in week 8 but I only could get data until week 6; this was fixed when I ran the dataset in a new file after some times trying it, but is not always working... I tried to re-connect to the source in a new file some times and I'm still having this issue (I only get data until week 8) :(

     

    Thanks and kind regards.

     

     

    • Anonymous's avatar
      Anonymous
      Not applicable
      7 years ago

      melpbi ,

      Do you apply any filters to your current Power BI report?

      Regards,
      Lydia

      • melpbi's avatar
        melpbi
        Frequent Visitor
        7 years ago

        Dear Anonymous,

         

        I don't apply any filters when I get the data :(. This issue is kind of weird because it doesn't always happen. For example this week I got all the data... So... right now it's fine I guess?

         

        Thank you and kind regards!