We’ve split the on-premises data gateway docs into content that’s specific to Power BI and general content that applies to all services that the gateway supports. You’re currently in the Power BI content. To provide feedback on this article, or the overall gateway docs experience, scroll to the bottom of the article. Power BI supports many on-premises data sources, and Read More
How to Create a Measures Table (Placeholder for Measures) in Power BI
Creating a measures table in your Power BI data model is one of the most common questions we get from folks wondering how they can better organize the measures they create. When navigating through your data model in Power BI Desktop, it’s easy to get lost in a sea of tables and fields, especially if Read More
How to Fix “Microsoft Excel is waiting for another application to complete an OLE action”
1st troubleshooting 1. Open the Excel sheet and go the File menu. In the File menu, click on Options. 2. An Excel Options dialog box will appear. Go to the Advanced tab and scroll down to the General area. Over there check Ignore other applications that use Dynamic Data Exchange (DDE). 3. Restart Excel. 2nd troubleshooting, if you are using Google Drive Google Drive Read More
How to Send or Save Large Attachments in Google Drive
When you’re sending a file, you can add attachments in Gmail up to 25 MB—but what if you have larger files such as videos? Save these large files in Google Drive, then insert a link to the Drive or shared drive file in your email. Note: If your recipients don’t have viewing permissions for the file, you Read More
How to Compare Sales With Last Year on Day in Week in Power BI
A very normal calculation we do is to compare a value, for example, sales, against how we did last year. The easiest way to do this is by using the SAMEPERIODLASTYEAR function to create a measure that looks like this Sales LY = CALCULATE( [Sales] ,SAMEPERIODLASTYEAR(DimDate[Date]) ) As shown in the image above this works Read More
How to Calculate Weekly Average with DAX Formulas
Backgrounds A bit of context – I have a dataset with a date table and a table which is a list of ‘Tickets issued’. They are linked via Issued Date. I am trying to get the average number of tickets Issued a week, for each location (tickets have the location that they were issued to). Read More