This will not work Install the x86 drivers, and give it another try. Excel connections (at least 2014 prior), only worked with 32 bit drivers, not 64 bit. I don't...

I believe that it is either 32 bit or 64 bit excel driver per machine. I have 64 bit office installed only. The 64 bit export works for...

I really enjoyed the article.

There were some minor typos such semicolons instead of commas in the DAX formulas. Largest Population = MAX([Population]) in PowerBi and in PowerPivot...

Thanks for a great article. I am looking into using the output statement to determine primary keys after insertion plus the latest row version with concurrency. It works...

Nice article. When I used synonyms for tables,scalar functions and table functions. It was important to me to include the schema name as part of the definition. ...

The practical example is when the product price changes the EffectiveEndDt of the last current price is updated with the current date and a new transaction is created with same...

Compliments on your article.

If you defined the EffectiveEndDT as DiscontinuedDT your queries would not have to use Isnull. It would be sargable and make the query optimizer a...

It was an interesting article but it is an inordinate amount of work to transfer data to excel (32bit?). What would you do to export your data if the...