Suppose you want your report readers to be able to look at overall sales metrics, but also highlight performance for individual district managers and different time frames. You could create separate reports or comparative charts. You could add filters in the Filters pane. Or you could use slicers. Slicers are another way of filtering. They narrow Read More
How to Fix “on-premises gateway could not be reached” or Similar Errors
Troubleshooting dataflow issues: Connection to the data source When you create a dataflow, sometimes you get an error connecting to the data source. This error can be caused by the gateway, credentials, or other reasons. This article explains the most common connection errors and problems, and their resolution. Error: An on-premises data gateway is required Read More
How to Add or Remove a Gateway Data Source from Powerbi.com
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