Forum Discussion

Markzolotoy's avatar
Markzolotoy
Impactful Individual
5 years ago
Solved

DirectQuery or Import for reports

I am creating a dataset for paginated reports. If I use Import for my queries will I be getting the latest data in my paginated reports when I run them on the service?   Thanks
Need Help
  • v-yingjl's avatar
    v-yingjl
    5 years ago

    Hi Markzolotoy ,

    Reports need to refresh the dataset to get the latest data in power bi service; paginated reports just refresh the service page to get the latest data when your data source has been updated.

     

    Please refer automatic refresh for paginated reports in the previous post.

     

    You can also refer this viedo and document:

    1. How to Refresh Power BI Paginated Report (13-6) TAIK18 
    2. Data refresh in Power BI 

     

    Best Regards,
    Community Support Team _ Yingjie Li
    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Markzolotoy's avatar
Markzolotoy
Impactful Individual
5 years ago

All I want is when  a user is running a report or an automated export is creating a PDF file users get it with the latest data. Is that how its working out of box?

v-yingjl's avatar
v-yingjl
Community Support
5 years ago

Hi Markzolotoy ,

To get the latest data from data source when you run a report or export it as a PDF file, you need to confirm that the refresh progress has been completed.

Dataset without refresh would not be updated in power bi service under import mode.

 

Best Regards,
Community Support Team _ Yingjie Li
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

  • Markzolotoy's avatar
    Markzolotoy
    Impactful Individual
    5 years ago

    v-yingjl And by confirm you mean the user needs to refresh DS first? IS the same for PBI reports and paginated reports?

    • v-yingjl's avatar
      v-yingjl
      Community Support
      5 years ago

      Hi Markzolotoy ,

      Reports need to refresh the dataset to get the latest data in power bi service; paginated reports just refresh the service page to get the latest data when your data source has been updated.

       

      Please refer automatic refresh for paginated reports in the previous post.

       

      You can also refer this viedo and document:

      1. How to Refresh Power BI Paginated Report (13-6) TAIK18 
      2. Data refresh in Power BI 

       

      Best Regards,
      Community Support Team _ Yingjie Li
      If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.