Forum Discussion

Ciano's avatar
Ciano
Regular Visitor
4 years ago

Object reference not set to an instance of an object

Hi, Can you help me regarding my error on power bi , when refreshing data and publishing. thank you

 

feedback type: frown (error) error message: object reference not set to an instance of an object. stack trace: system.nullreferenceexception at microsoft.powerbi.client.windows.analysisservices.queryevaluator.loadtomodelqueryevaluator.<>c.<evaluaterelationships>b__26_0(extendedloadtomodelqueryevaluationoutput o) at system.linq.enumerable.all[tsource](ienumerable`1 source, func`2 predicate) at microsoft.powerbi.client.windows.analysisservices.queryevaluator.loadtomodelqueryevaluator.evaluaterelationships(report report, dictionary`2 querynametorelationshipinfocontainer, dictionary`2 querynametoevaluationoutput) at microsoft.powerbi.client.windows.analysisservices.queryevaluator.loadtomodelqueryevaluator.getevaluationresults() at microsoft.powerbi.client.windows.analysisservices.loadtomodelqueryevaluationservice.<evaluateforloadasync>d__4.movenext() --- end of stack trace from previous location where exception was thrown --- at system.runtime.exceptionservices.exceptiondispatchinfo.throw() at system.runtime.compilerservices.taskawaiter.handlenonsuccessanddebuggernotification(task task) at microsoft.powerbi.client.windows.modeling.hosting.modelingtelemetryservice.<>c__displayclass8_0`1.<<runinasyncactivity>b__0>d.movenext() --- end of stack trace from previous location where exception was thrown --- at system.runtime.exceptionservices.exceptiondispatchinfo.throw() at system.runtime.compilerservices.taskawaiter.handlenonsuccessanddebuggernotification(task task) at microsoft.powerbi.client.windows.modeling.hosting.modelingtelemetryservice.<runinasyncactivity>d__7.movenext() --- end of stack trace from previous location where exception was thrown --- at system.runtime.exceptionservices.exceptiondispatchinfo.throw() at system.runtime.compilerservices.taskawaiter.handlenonsuccessanddebuggernotification(task task) at microsoft.powerbi.client.windows.modeling.hosting.modelingtelemetryservice.<runinasyncactivity>d__8`1.movenext() --- end of stack trace from previous location where

2 Replies

  • Anonymous's avatar
    Anonymous
    Not applicable

    Hi Ciano ,

     

    We need more details to clarify your scenario, for example:

    1. What's your data source?

    2. Is there any error in Power Query?

    3. Does such error occur in Power BI Desktop or in Power BI service?

    4. What's the version of your PBI? You may use another version to have a try again.

     

    In addition, you may go to File | Options and settings | Options | Diagnostics to collect some information.

     

    Best Regards,
    Eyelyn Qin
    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

    • Ciano's avatar
      Ciano
      Regular Visitor

      Hi Anonymous , please refer on the answers below.

       

      1. What's your data source?

      Ans: Excel file on shared folder

       

      2. Is there any error in Power Query?

      Ans: None

       

      3. Does such error occur in Power BI Desktop or in Power BI service?

      Ans: Power Bi Desktop

       

      4. What's the version of your PBI? You may use another version to have a try again.

      Ans: April 2022 version

       

      Thanks