Autor: selfservicebi
-
A few DAX functions
Ursprünglich veröffentlicht auf Data and AI: This query shows summarise, addcolumns, filter, union, row and format DAX functions: UNION ( ADDCOLUMNS ( SUMMARIZE ( FILTER ( financials, financials[Product] = „Montana“ ), financials[Country] ), „Sales“, FORMAT(CALCULATE(SUM(financials[ Sales])), „#,###“) ), ROW(„Total“, „Total“, „Sales“, FORMAT(SUM(financials[ Sales]), „#,###“)) ) The financials table is filtered on Product = Montana Display…
-
Solving Real World Scenarios with Microsoft PowerApps
This is an alternative approach to solve the problem described in my blog post here: https://selfservice-bi.com/2016/11/19/solving-real-world-scenarios-with-microsoft-flow/ This time I’m using PowerApps to „win“ the challenge. All of this is done in three easy steps: Step 1: For testing purposes, it is enough to sign up for a free plan here: https://vatlayer.com/ Step 2: Then you…
-
Manage CDS Entity Data – Microsoft PowerApps Office Add-In — Bansal Blogs – Dynamics 365, PowerApps, Microsoft Flows, Power BI
Microsoft PowerApps Office Add-In enables user to read, modify and insert data in CDS environment. Add-In is available for download here for free, or you will be prompted to install Add-In for first time when you open entity data in excel from PowerApps portal. Add-In establishes connection to PowerApps OData service. Note: Add-In is compatible […]…
-
Calling The Power BI REST API From Microsoft Flow, Part 3: Finding All Data Sources Used In A Power BI Tenant
Chris Webb's BI Blog [Part 1 of this series can be found here and part 2 here] The problem with self-service BI is that you never quite know what your users are up to. For example, what data sources are they using? Are there hundreds of Excel files being used as data sources for reports…
-
Keeping Big Data Big with Aggregations
Ursprünglich veröffentlicht auf PhantomDB: I have built several solutions over the years to enable business users to get at the data they need to do the analysis that is important to them. I would build cubes so that they could slice, dice and mold the data into the shape they need. They would use tools…
-
Power BI Dataflows
Die vielen Neuerungen in Power BI sind ja für mich kaum noch alle nachzuverfolgen. Darum versuche ich, die Informationen zu filtern. Dataflows sind mir schon seit einiger Zeit im Hinterkopf hängen geblieben, da es hier mehr um Design als um Visualisierung geht. Eine wirklich erschöpfende und trotzdem flüssig zu lesende Abhandlung dieses Themas gibt es…
-
Taking the Most Out of Linked Servers
Da ich gerade in einem Projekt mit dem Thema „Linked Server“ konfrontiert wurde, ist dieser Artikel ein guter Einstieg in die Thematik. Auch das erwähnte Video ist sehr empfehlenswert. Natürlich ist das Thema komplex, aber mit etwa Recherche im Internet kann beliebig in die Tiefe gegangen werden: https://prologika.com/taking-the-most-out-of-linked-servers/
-
Microsoft Flow – Business process flows from a traditional Flow perspective
SharePains Recently Microsoft added Business process flows to their Microsoft Flow platform. If you thought that this was just like Flow then you will very quickly find out that it is not. A bit of background first As part of Dynamics 365 there is the Process Center. Within the Process Center you can maintain processes…
-
Dynamics 365 Business central on-premise: why I can’t find my C/AL page on Search?
Ursprünglich veröffentlicht auf Stefano Demiliani: This seems to be a problem for many partners and developers that have start working with Dynamics 365 Business Central on-premise in these days and this is not actually well documented in my opinion. I think that you already know that when developing a page with the AL language extension…
-
Ignite 2018 – Book of News with all announcements — workingondata
Last week was Ignite 2018 time. A week full of announcements from all Microsoft product groups. Twitter and other social media channels were full of messages mentioning the news. For me – as a non-attendee – it was fun to read through the news flood – but hard to find a summary of all the […]…
ERP and BI 