Forum Discussion

dhampshire's avatar
dhampshire
Microsoft Employee
2 years ago
Solved

Power BI Semantic model Refresh Bizarre Behavior

I have a Service model and report saved on OneDrive and Sharepoint.  I also have a Power BI workspace they're published to.  When I make a change to the Service model locally, I save and publish.  Th...
Need Help
  • dhampshire's avatar
    dhampshire
    2 years ago

    RESOLVED.

     

    This issue was happening on refresh (manual or scheduled).  For a reason I haven't yet determined, when the data in a table was updated via refresh (in service not locally), it was including "(Blank)" values.  I had a DAX expression that was filtering for empty strings "".  So the DAX expression was producing incorrect values when the semantic model was refreshed in the service.  Locally, this wasn't happening for some reason during refresh. 

     

    Adding a DAX expression that filtered for both "(Blank)" and "" mitigated the issue.  It's not clear to me why refresh locally and via the service were producing different results.    

GilbertQ's avatar
GilbertQ
Super User
2 years ago

Hi dhampshire 

 

Have you made sure that you've clicked on the reset to default button?

  • dhampshire's avatar
    dhampshire
    Microsoft Employee
    2 years ago

    GilbertQ I'm not sure which button you're referring.  On the report itself? If so, I've ensured all filters and slicers are cleared.  

     

    I can clearly see the semantic model on the Power BI service is different from what I have locally.  Row by row I can see the data is different.  So it's not a matter of the report reflecting some filter.