Forum Discussion

SolutionsItCTO's avatar
SolutionsItCTO
New Member
8 years ago

Data refresh for SharePoint online list - command is cancelled

Hi,   I have a PowerBI report that has 3 SharePoint online lists as its data sources. All 3 lists live in the same tenancy / site collection / site The list owner is the tenancy admin The PowerBI...
v-yulgu-msft's avatar
v-yulgu-msft
Microsoft Employee
8 years ago

Hi SolutionsItCTO,

 

Do you have any other type of data source in current .pbix file? Do you have a Pro or Free license?

 

Does this table 'TimeManagement' esist in current dataset? Please open file in desktop to check the applied steps under query editor mode to see whether there existing any error.

 

Regards,

Yuliana Gu

  • SolutionsItCTO's avatar
    SolutionsItCTO
    New Member
    8 years ago

    Hi Yuliana,

     

    Thanks for your reply

    I am using an O365 user with a PowerBI Pro license in that tenancy

    The only data sources in the PBIX file is the 3 SharePoint online lists

    Opening the PBIX from the PowerBi Desktop application and checking the Query Editor applied steps no errors are present. A refresh of the data at this point occurs quickly and without error

    Rechecking on the PowerBI Web UI and refreshing the dataset of the published report there still results in the reported error above

     

    Thanks

    Craig

    • SolutionsItCTO's avatar
      SolutionsItCTO
      New Member
      8 years ago

      Hi Yuliana,

       

      Any further feedback on this issue

       

      Thanks

      Craig