Excel Magic Trick 1385: Import Tables from SQL Server Database into Power Pivot or PBI Data Model

Download Files:

See how to : Import Tables from SQL Server Database into Power Pivot or Power BI Data Model using Power Query.

[LeilaGharani]

That's great that you're using SQL here. I am very much looking forward to the next videos, specially the one with DAX formulas.

[franzzzis]

thanks for your excellent work! Nice DB it takes me 4 min to fetch the data from Berlin. A very welcome opportunity to play again with Power Query and Power Pivot. Analyzing the data goes quickly and smoothly. ... thanks again

[larryogunbanjo]

Gosh.. I stumbled upon this training by chance and its BRILLIANT!!!!1.

[anandshukla]

Thank you so much for sharing pracious information about sql marvelous job

[caribeiro]

Thank you Mike, this is an awesome database for me to train PBI Desktop

[zaighamuddinfarooqui]

Waiting for next "FUNtastic" episodes.

[phil]

Hi, can you use the same approach with stored procedures? I am currently using CISCO stored procedure embedded into VBA scripts but I would like to use this approach instead, what do you recommend? THX

[afedianine]

HI! A request - you wouldn't happen to have .bak SQL Server file for the database which I can restore on my end to play with? THank you in any case, awesome video!

[mohamedchakroun]

Looking forward so Mike
It takes about 10 minutes to load the data is it normal????

[antman]

Sir I am very pleased to all your excel solution very easily.
Please solve this calculation in excel Formula.
First 250, 000 tax rate is 0%
Next 250, 000 to 400, 000 is 10%
Next 400, 000 to 500, 000 is 15%
Next 500, 000 to 600, 000 is 20%
Next 600, 000 to 3000, 000 is 25%
Next 3000, 000 or above is 30%

If income is 1250, 000 then tax will be per annum=135, 000
1250, 000
- 250, 000 =0% =0

1000, 000
- 400, 000 =10% =40, 000

600, 000
- 500, 000 =15% =75, 000

100, 000 =20% =20, 000

Total =135, 000

[Pkaminski]

Hey, if you will be able to write a SQL query that will refer to the parameter defined in the Excel table?
e.g. I have a table in the specified date range from 2016-01-01 to 2016-12-31, and wants to SQL queries received such a result:

select *
from dbo
where data in (data from the defined parameter)

[shikhiful]

Sir Mike, I was not able to logon to the server, Error: "error: 0 - The certificate chain was issued by an authority that is not trusted". How to resolve this?

[jonathanriver]

When I am trying to connect I get this error message: We couldn't authenticate the credential provided. Please try again.

I have checked the credentials several times but I still have the error.

Thanks

[zxbcrhj]

Is the Database still up for Login to practice. I'm getting not authorized

[michaeldiamond]

I can't seem to connect to the server. When I first downloaded the file I didn't go to the data base option to type in ExcelIsFun. I didn't connect. When I went to do it again I keep on getting error messages that it can't connect to the SQL server. I looked at the server name and I counted an additional 10 spaces or so in the Excel file - is this correct? then I counted an additional 2 spaces at the end of Boomerang. would this cause the problem?

[Sal_A]

Add this to the Data Model is not in Excel 2010...only 2013 and 2016

[deedubdolphinsdialogue]

The username and password don't work.