Wednesday, 14 September 2022

Power BI - Month is not getting sorted even when Sort by Month Number is applied

 Hi Guys,

My team encountered the below error 

Power BI - Month is not getting sorted even when Sort by Month Number is applied


Resolution - Check the data type for Month Number. In our case it was of "Text" type. When we changed to "Whole Number" it worked 


Bingo!

Power BI - the column " " of the table wasn't found..while importing data from Azure Data Lake

 Hi Folks,

I got the below error while trying to import data fro Azure BLOB


the column " " of the table wasn't found


Resolution - Check if there are any "Removed columns" steps in your Power Query steps. If yes, try to remove it and reload the data. It will work

2nd step - Try to refresh the table which you are trying to load