In this exercise, you’ll create logins, users, and admins, and you’ll grant Azure Active Directory (Azure AD) users access to the database, as you would for normal users in SQL Server. Open SQL Server Management Studio (SSMS), and connect to your Azure SQL Database server, if you aren’t already connected. After you’ve configured and connected Read More
Month: March 2022
Calculate Days Of Zero Stock in Power BI
Calculate Days Of Zero Stock Background: I am building a supply chain dashboard at our company and a big problem we are having is STOCK OUTS. I have a table of over 5 million rows that contains all our SAP movement data inside inbound goods in and outbound issues to production. From here i have Read More
How to Sync Slicers on Different Pages
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