Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
4 years ago
Solved

Slicer not populating

Hi, I have a slicer that is fine in desktop, but errors out once it refreshes over the gateway in the service. I've loaded data to Power Query - 3 columns, all text type. I've added a calc column ...
Need Help
  • Anonymous's avatar
    Anonymous
    4 years ago

    I've resolved this. It had to do w/ the Data Type being left as Any in power Query - adding the Text type resolved the issue. 

v-luwang-msft's avatar
v-luwang-msft
Icon for Community Support rankCommunity Support
4 years ago

Hi Anonymous ,

Try to remove the calculated columns and then refresh and then add the columns back.

 

If you do it this way, update the data model and then load the PBIX or Excel file and overwrite the old data set, you will not break all of your reports, dashboards, etc.

 

similar error refer :

https://community.powerbi.com/t5/Power-Query/Can-we-update-the-dataset-without-deleting-and-adding-again/m-p/3024#M892 

https://community.powerbi.com/t5/Service/Calculated-Columns-not-updating-on-scheduled-refresh/m-p/793615 

 

Did I answer your question? Mark my post as a solution!


Best Regards

Lucien