Forum Discussion
Helper IIObject reference not set to an instance of an object.
Hi guys,
Finally, after review each code running and each relation into the Power BI Model, I found the error. One of my complex scripts were making a relationship with my main table and the moment to refresh my report "PUM" error. I took the decision, for now, to eliminate table and relationship and my report back up to "life" again, I going to check-up well the code and consequences into my model.
I want to express my gratitude to the people who tried to help me with this issue. I promise to do the same if someone else needs it.
Regards;
Jairo Suarez
Community ChampionElpatoDBA SQL jockey I am not. So that is the SQL code that makes up the iostat... table/view? And then, when you created your query using the SQL connection, you clicked "Advanced" and entered "SELECT * from iostat...", is that all correct or BS?
Helper IIHi Greg
Yes, all green. No errors when you create the connection and create queries. I will analyze script by script and as well as the model into Power BI. I will back to you ASAP.
Regards;
Jairo Suarez
- ElpatoDBA
Hi guys,
Finally, after review each code running and each relation into the Power BI Model, I found the error. One of my complex scripts were making a relationship with my main table and the moment to refresh my report "PUM" error. I took the decision, for now, to eliminate table and relationship and my report back up to "life" again, I going to check-up well the code and consequences into my model.
I want to express my gratitude to the people who tried to help me with this issue. I promise to do the same if someone else needs it.
Regards;
Jairo Suarez