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

The reason I am asking is that I am going to use SQL Express and have read somewhere that Impport is not allowed. Can you please confirm that Import can be used?