Power BI

1)What is PowerBI?

PowerBI help us to represent data into the Graphs and Charts , Based on this data you can take decision.

Power BI has the intelligence to monitor the data and send the alerts based on threshold you set.

2)How PowerBI can secure datasource?

Using  PowerBI you can connect to the datasource. 

Original datasource never modified , does it mean you have an option to revert to its original always or you can save.So that changes only effect to the your view of content.

3)What is advantages of PowerBI?

You can compare the same data in different visuals side by side.

Using comment feature , you need not send an email, you discuss ay dashboard

4)What is visual mechanism in PowerBI?

Content  visualization happen three ways

1) Organized as tiles in home page  so that you can click on tile you will get complete information

2) Navigation Bar - top left corner on dash board (organized as Recent , Favorites and app and shared with me options )

  Recent: you will get most recent recent

  Favorites: will get reports or dashboards marked as favorites

  Apps: Recent apps

  Shared with me: will get the reports shared with you.

3) Using search : get the report by report name or person name who shared with you.

Along with above all it is showing recommended content and learning resources

5)What is an aggregation in Power BI?

It is used to display summary of data.

6) To compare two values or numbers against each other for various categories , so that there are lots of circles in the graph, Which visualization should I use?

Scatter graph

7)What is drill down?

Drill down is nothing but going depeer into the  hierarchy

Example start from the year then after quarter and after month

8)What is drill through?

Drill through is nothing but goes to another report.

Example you go from one page report to another page.

9)how to get some stastics for every column?

Using column profile will get column statistics.

10)What is the difference between append query and merge query in PowerBI?

Merge query :

I have two data sources and want to add one or more columns  to another query is known as merge query

Append query :

I have two data sources and want to add one or more rows  to another existing query is known as  append query.

1Q)Source = Sql.Database("fsdbfsql,1234", "RXDDBF", [Query="SELECT * FROM abc WHERE CONVERT(DATETIME, FLOOR(CONVERT(FLOAT, LastModifiedDate))) between "&Character.FromNumber(32)&Character.FromNumber(39)&Date.ToText(ProductID1)&Character.FromNumber(39) and Character.FromNumber(39)&Date.ToText(ProductID3)&Character.FromNumber(39)])

if I am using above query to retrieve data in between multiple dates it shows following error

Please help me some one to resolve this issue

Expression.Error:

Cannot convert the value "SELECT * FROM Builds..." to type Logical.

Details:

    Value=SELECT * FROM Builds WHERE CONVERT(DATETIME, FLOOR(CONVERT(FLOAT, LastModifiedDate))) between  '2/6/2012'

    Type=Type

Ans:

We cannot use AND , OR Directly .

you can use it like this- initialize AND,OR to one variable you can concatenate that variable to the query.. we can use like that

str="and'

Source = Sql.Database("fsdbfsql,1234", "RXDDBF", [Query="SELECT * FROM abc WHERE CONVERT(DATETIME, FLOOR(CONVERT(FLOAT, LastModifiedDate))) between "&Character.FromNumber(32)&Character.FromNumber(39)&Date.ToText(ProductID1)&Character.FromNumber(39)&str&Character.FromNumber(39)&Date.ToText(ProductID3)&Character.FromNumber(39)])

Thank you

2)Please help me to construct a PowerQuery With help of LIKE operator SQL Query

Below is my sample Query

select * from abc where LastModifiedDate like '2012-02-06%'

In place of Like I am using this Query I am achieving

"let
ProductID=Excel.CurrentWorkbook(){[Name="Table5"]}[Content]{0}[#"NodeId"],
ProductID1=Date.From(ProductID),
Source = Sql.Database("fsdbfsql,1234", "RXDDBF", [Query="SELECT *
FROM abc WHERE CONVERT(DATETIME, FLOOR(CONVERT(FLOAT, LastModifiedDate))) = "&Character.FromNumber(32)&Character.FromNumber(39)&Date.ToText(ProductID1)&Character.FromNumber(39)])
in
Source

3)ProductID=Excel.CurrentWorkbook(){[Name="Table5"]}[Content]{0}[#"NodeId"],
Source = Sql.Database("Dabaservername", "Databasename", [Query="select top 10 * from yyy where NodeId>="&Number.ToText(ProductID)])

Using above query i can pass NodeID=1 and i am able to get data data Success fully from sqlserver

If NodeID Passing like a Char val like NodeId='Daily' i am unable to pass this to Query..I am unable to append SingleQuetes to daily while passing it

Please some one help me to Solve this issue..

Sql.Database("Dabaservername", "Databasename", [Query="select top 10 * from yyy where NodeID="&Character.FromNumber(39)&ProductID&Character.FromNumber(39)])

Thanks for visiting this blog. How is the content?. Your comment is great gift to my work. Cheers.

Privacy policy , contact us