This post solves the very simple problem in Power BI.
If you are trying to access the Power BI datasets to create reports then you may encounter this below error message.
Error: “The connect live option for this file is disabled because it already contains data from another data source.”
“Power BI datasets” is one of the options from “Get Data”. Whenever you publish a report from Power BI desktop to Power BI services, it is publishing the dataset and report.
You can create multiple reports using the same published datasets from Power BI services. This is something like a shared dataset. In case, if you are experiencing the above error then you need to ask your administrators to fix the issues.
The administrator has to fix this issue on the admin side of the Power BI services. Follow the below steps.
That’s it. The issue has been fixed.
Date data type is very important for all programming languages. To handle the date in a proper way, we need to apply some formatting logic.
This is the case for R programming language as well. This post explains you, how we can handle the Date data in R. There are different functions available in R to handle date.
To get the today’s date, use Sys.Date()
To get date and time, use date()
> date() “Tue May 22 15:29:18 2018”
Check the below list of symbols to play with date and time format.
|%d||day as a number (0-31)||01-31|
> today <- Sys.Date()> format(today, format=”%B %d %Y”) “May 22 2018”
In a real-time scenario, we will not get date as date data type. Always, we need to convert to proper date data type. To convert to date data type, we need to use as.Date() function.
x – Field or column
format – use the above symbols to frame the proper format.
DateVec<- c(“01/05/2018”, “08/16/2018”)
 “01/05/2018” “08/16/2018”
Length Class Mode
2 character character
dates <- as.Date(DateVec, “%m/%d/%Y”)
 “2018-01-05” “2018-08-16”
Min. 1st Qu. Median Mean 3rd Qu. Max.
“2018-01-05” “2018-03-01” “2018-04-26” “2018-04-26” “2018-06-21” “2018-08-16”
SQL Server 2016 introduces a new feature called “Live Query Statistics”. This is the feature available in SQL Server Management studio and visible to everyone.
This live query plan displays below information when executing the query
Data is available on run time so not required to wait for the query complete. This helps us to debug the query performance issues.
Steps to use this feature