Convert decimal to whole number in measure in Power BI

 Hi All,

Some small things but it would be great things for a beginner. Here is how to format the measure I,e convert decimal to whole number in Power BI

Click on measure and at the top menu, you would find the format bar in which you can change it to Whole number 

Data overflow converting to the data type for table 'D_ACC' column 'DT_BIRTH'. The current operation was cancelled because another operation in the transaction failed.

 Hi All,

Okay finally found resolution for this issue which was bugging me from past 2 days

Issue - Data overflow converting to the data type for table 'D_ACC' column 'DT_BIRTH'. The current operation was cancelled because another operation in the transaction failed.

Resolution - Identify the data type of column that is causing the issue and apply convert function. What worked for me is the below code

SELECT CONVERT(VARCHAR(10), DT_BIRTH, 120) FROM D_ACC

Note - While trying to resolve this issue, I encountered another  error

Error 2 - Capacity exceeds maximum capacity. Parameter name: capacity

Resolution - I understood that I was trying to add all column names and the editor did not like so many character at once. So I clicked on "Design View", manually pulled the table, which then showed me all column names and then I entered the code CONVERT(VARCHAR(10), DT_BIRTH, 120) as DT_BIRTH.

Bingo!!!!

Am able to load huge chunk of data in my SSAS tabular model

Unable to save the file model.bim readonly

 Hi All,

Issue - "Unable to save the file model.bim readonly" error while trying to save the tabular cube.

Resolution -

– Click on the Model.bim file, and select ‘Properties’ and point the tabular model at the correct instance

– Click on the Project, and select the updated Properties information under ‘server’.

Enjoy 😃

Database already exists in dettached state - Analysis Tabular services

 Hi All,

Issue - database already exists in dettached state

Resolution - To add folder in "Allow Browsing folders". Check the below link from 8th minute till the end

https://www.youtube.com/watch?v=cvn4z7AKMFg

😃

Tabular model explorer missing

 Hi Folks!

Okay..so here starts my first tabular analysis services project. 

First error

Problem - Tabular model explorer missing

Resolution - Double click on Model and you would find your tabular explorer

CMMi Artifacts

 Hi Folks,

Find attached PPT which would be getting uploaded daily and has information on CMMi Artifacts

https://drive.google.com/file/d/17yMDH1a4lASPgorLGJEj1kHTdvoMlj_9/view

Updated Artifacts with definitions only :)

https://drive.google.com/file/d/1hVPApy8Bt-2UJDn-t4oJD-337xidtv0W/view?usp=sharing

GetData is disabled in PowerBI Desktop

 Hi All,

Today I learnt a new feature in Power BI which is "Live Connections"

Got a request from a customer that they want to import excel sheet to the power BI file and make some changes to it. When I took control of the screen, could see that I GETDATA tab is disabled. Upon further research on this issue, I could find lot of information on Live connection which is listed in below lin 

https://radacad.com/live-connection-when-power-bi-comes-hybrid

Now the only possible solution is to request the team who is responsible for creating the data model to include the excel sheet data and then add new measures in Power BI file. 

Happy Working 👏😃