Forum Discussion
Microsoft EmployeePower BI Semantic model Refresh Bizarre Behavior
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.
Microsoft EmployeeOther things I've tried:
Creating a new .pbix file (original file saved with different name) and uploading to same workspace,
Deleted everything from Power BI service and uploaded .pbix file to Power BI service via my OneDrive,
Deleted everything from Power BI service and published via the desktop Power BI,
Deleted table in .pbix and re-created table and data sources from scratch
Same result, after publishing my changes, the table in the semantic model on the Power BI service, OneDrive, and Sharepoint show the correct data. After a refresh on the Power BI service, the changes remain on OneDrive and Sharepoint but they are gone from Power BI semantic model.
This is baffling.