OLEDB1

How to Change Data Source From Excel to MS SQL Server Database in Power BI

We will change the data source by using some basic M language script. The reason we need to do this by using M language is that Power BI data source settings does not provide us an option to change the source directly as shown below. Now to change the via M script we will do […]

OLEDB1

How To Join as an Office Insider to Test The New features on Office 365

How to get collections for Office evaluators in Windows Follow these steps to verify that you have the right to install collections for Office evaluators on your device. If so, select the desired level of evaluation program and install the current build. Find out which programs are included in the Office evaluation program . Verification of compliance Open […]

OLEDB1

External Data (Connections) in Excel 2016 for Mac

These days we all live and work in a multi-device, multi-platform world, and so when building Office 2016 for Mac, one of our key objectives was to make it as easy as possible to transition from using Office for Windows to using Office for Mac and back again. That’s why you’ll notice an interface that’s consistent […]

OLEDB1

What is Cross-Report Drillthrough in Power BI and How to Use It?

With the Power BI cross-report drillthrough feature, you can contextually jump from one report to another report in the same Power BI service workspace or app. You can use cross-report drillthrough to connect two or more reports that have related content, and to pass filter context along with the cross-report connection. To initiate cross-report drillthrough, you select […]