Forum Discussion

Frank1's avatar
Frank1
Frequent Visitor
9 years ago
Solved

Cannot auto refresh imported dataset

After 1) creating an Azure SQL Direct Query report in PBI Desktop, 2)  then publishing, 3)  then converting the dataset to Import Mode, using PBI desktop 4) re-publishing   automatic refresh on...
Need Help
  • v-qiuyu-msft's avatar
    v-qiuyu-msft
    9 years ago

    Hi Frank1,

     

    Based on my test, after change mode from DirectQuery to Import and republish the report to service, the dataset still keeps in DirectQuery mode and schedule refresh is not available. But once we remove the original dataset then publish the report, schedule refresh is available in dataset.

     

    For this issue, I will report it internally and back here once get any feedback. In your scenario,m you can remove dataset and publish report again to work around the issue temporarily.

     

    Best Regards,

    Qiuyun Yu

v-qiuyu-msft's avatar
v-qiuyu-msft
Community Support
9 years ago

Hi Frank1,

 

Based on my test, after change mode from DirectQuery to Import and republish the report to service, the dataset still keeps in DirectQuery mode and schedule refresh is not available. But once we remove the original dataset then publish the report, schedule refresh is available in dataset.

 

For this issue, I will report it internally and back here once get any feedback. In your scenario,m you can remove dataset and publish report again to work around the issue temporarily.

 

Best Regards,

Qiuyun Yu

  • Frank1's avatar
    Frank1
    Frequent Visitor
    9 years ago

    Hi v-qiuyu-msft

     

    Thanks, I confirm this and also that another workaround is to rename the report in PBI Desktop (thus dataset), reimport and republish.

     

    Best Regards

    Frank