Configuring a virtual private server (VPS) on Google Cloud Platform that is “always free” Introduction While there are a lot of providers that offer smaller VPS you can test for free for a certain time range, there are not many that are permanently free. This article will focus on setting up an f1-micro VPS on Read More
How to Connect to a Google BigQuery Database in Power BI Desktop
In Power BI Desktop, you can connect to a Google BigQuery database and use the underlying data just like any other data source in Power BI Desktop. Connect to Google BigQuery To connect to a Google BigQuery database select Get Data from the Home ribbon in Power BI Desktop. Select Database from the categories on the left, and you see Google BigQuery. In the Google BigQuery window that Read More
The Guide To Finding and Removing External Links From Your Excel File
By: Chris Newman How To Break External Links So you’re on a mission to remove external links from your Excel workbook, huh? Seems like it should be easy, but as you are probably finding out, it sometimes isn’t as easy as clicking the “break links” button (unfortunately). In this post, I am going to walk Read More
How to Prevent a User Receiving Emails From a Google Group (Split the Access From Google Drive)
Do this from user computer If you no longer want to participate in a group or receive the group’s emails, you have 2 options: Unsubscribe from getting email from the group—You’re still a member of the group, but you no longer receive emails when there’s activity. Leave the group—After you take this action, you can no Read More
How to Fix The “Microsoft.ACE.OLEDB.16.0 Provider is not registered on the local machine.”
A popular issue in importing the data which is in Microsoft Excel 2016 to MSSQL via SSMS (Management Studio). It throw an error : “=================================== The ‘Microsoft.ACE.OLEDB.16.0’ provider is not registered on the local machine. (System.Data) To fix this, First thing first, install “Microsoft Access Database Engine 2016 Redistributable.” https://www.microsoft.com/en-us/download/details.aspx?id=54920 And then also check the Read More
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 Read More