0

I'm facing major issue in power bi when no data found on earlier data available web resource. Due to this issue I'm not able to apply change in dashboard and advanced editor derived steps throwing an error.

Load was cancelled by an error in loading a previous table

How to resolve the same by creating static tables headers when no data found on resource

KARTHIKEYAN.A
  • 18,210
  • 6
  • 124
  • 133

1 Answers1

1

You need to add a dummy table with your headers and some dummy info your power query statement. If the data sources doesn't exist then it returns the dummy table and the power query completes, but is an elegant fail. This approach by Chris Webb explains it

https://blog.crossjoin.co.uk/2014/09/18/handling-data-source-errors-in-power-query/

Jon
  • 4,593
  • 3
  • 13
  • 33
  • the above like they are attaching CSV but what I'm expecting is without attaching any file we just need to mention statically header of the table if no result. – KARTHIKEYAN.A May 09 '20 at 16:22