Forum Discussion

sreetejreddy's avatar
sreetejreddy
New Member
1 year ago

Power BI does not refresh when sharepoint list is empty

I had built a Power BI report using a sharepoint list as my datasource.

 

I had couple of rows of data in the list when I had created the report.

 

Now when I truncated the list (when the list is empty); Power BI throws error while refreshing.

 

The report does not refresh on desktop or services.

 

Need a solution!

Need Help

3 Replies

  • lbendlin's avatar
    lbendlin
    Super User
    1 year ago
    Power BI throws error while refreshing.

    Ok, what is the error message?  Looks like your Power Query code doesn't handle that scenario gracefully?

  • christinepayton's avatar
    christinepayton
    Most Valuable Professional
    1 year ago

    You have to have at least one data row in the table. I don't really see a scenario where you'd be wanting to use a datasource in Power BI that has 0 rows. 

    • lbendlin's avatar
      lbendlin
      Super User
      1 year ago

      I could imagine a scenario - for example an "Open tickets"  dashboard.  Might not be too common, but it is possible to have no open tickets on a certain date.