error: Object reference not set to an instance of an object

[clarissa]

Hello I work with Power BI Desktop. I fetch data from an Azure SQL Database. WIth a particular file, where a few tables are already integrated, I want to fetch an additional table of the same Azure SQL DB. But now I always get the error: 

Object reference not set to an instance of an object

This only appears for this particular PBI Desktop File and also comes up when fetching other tables within the same database. What is the reason? Thank you

[amitchandak]

@clarissa , open data transformation mode /edit query do you any detailed error

[clarissa]

where would I see it? in the power query editor mode?

[Pragati11]

Hi @clarissa ,

Yes open your Query Editor in POwer BI.

Go to the table which gives you this error, then try to expand the error there and see details for it's cause.

Thanks,

Pragati

[clarissa]

but I can't even connect with the table, so the table is not in Power Query Editor...

[amitchandak]

@clarissa ,refer if this can help

refer how to handle error in power query
https://www.youtube.com/watch?v=OE6DPmKqN7s
https://www.youtube.com/watch?v=9-Lag0VOiTs

debug issue
https://www.youtube.com/watch?v=OE6DPmKqN7s