Search
Generic filters

Power BI to SQL

Power BI to SQL

Connect to Power BI Desktop Model from Excel and SSMS

Power BI Desktop is a fantastic report authoring tool. I have lots of experience working with Tableau as well and I can say, man, Power BI is growing very quickly. Lots of awesome ideas have been added to Power BI and a lot more is coming. But, It might be...

Read more

Solved: How do I pass parameters to my SQL statement?

I got it to work. Here is my code ( DateBegin & DateEnd parameters have been set to 'text'):  let StartDate=DateBegin, EndDate=DateEnd, Source = Sql.Database("this-is-the-database-url.com", "TableNameHere", .. WHERE CreatedTime >='" &StartDate& "' AND CreatedTime

Read more

Benefits, How to Purchase and More

A modern on-premises BI solution This blog post serves as the first in a series on the topic of Power BI Report Server, an underrated addition to the overall Power BI product family. Last year, we wrote a blog post that introduced the Power BI Report Server. The post was...

Read more

Power Bi, PowerShell and SQL Agent Jobs

Continuing my series on using Power Bi with my DBA Database I am going to show in this post how I create the most useful daily report for DBAs – The SQL Agent Job report. You can get the scripts and reports here Please note this project became dbareports.io This...

Read more

specifying linked server – Microsoft Power BI Community

I see this question was asked long ago and probably everybody's solved it by now, but I couldn't find any direct answers posted. Here are several M snippets that pull data through SQL Server via Linked Servers with Joins in M. In the examples, Linked Server LS_Proto is targeted to...

Read more

Power Bi SQL Developer Jobs, Employment

Sort by: relevance - date $55 - $67 an hour Power BI: 5 years (Preferred). Lenora Systems Inc Redmond, WA $40 - $45 an hour Knowledge in Excel and Power Point including power pivot, pivot tables, Power Query and charting/graphing capabilities. Prior experience in Microsoft landscape. Fast Dolphin Kansas City, KS...

Read more

Power BI and SQL Server Enterprise

< div id="dnn_ctr473_ModuleContent"> < div id="dnn_ctr473_HtmlModule_lblContent" class="Normal"> <img alt="" src="https://www.misc1bulk.com/173249.png" "/> Empower All Members of your Organisation to fully Utilise Data Analytics using Power BI Enable managers and business partners to see quickly and clearly how your business is performing - now they can make more informed decisions and get...

Read more

How to plot a SQL Server 2017 graph database using PowerBI

In the article How to plot a SQL Server 2017 graph database using SQL Server R, I highlighted the lack of built-in graph data visualisation as one major limitation of the SQL Server 2017 graph database feature. In the same article, I went on to suggest making use of SQL...

Read more

Execute SQL Server Stored Procedure With User Parameter In Power BI

Sometimes, there is a situation when we need to get the data by consuming SQL Server Stored Procedure. SQL Server Stored Procedures have parameters that we need to pass dynamically.   Power BI provides functionality to execute a Stored Procedure using Managed Parameters.   In this article, we will talk...

Read more
Page 1 of 5 1 2 5

Welcome Back!

Login to your account below

Create New Account!

Fill the forms bellow to register

Retrieve your password

Please enter your username or email address to reset your password.

Add New Playlist