In countries like Austria Dynamics 365 Financials is not official published. Therefore people in these countries cannot try it out using there local business email account, they cannot learn, how to use it, cannot write postings about Dynamics 365 topics. Also to be an Dynamics NAV MVP does not help here. It would be nice, if […]
Excel Data to MSSQL
Das ist wirkliche eine tolle Sache. Ein Tool, welches den SQL Code erzeugt, um aus Exceldaten Tabellen im SQL-Server zu erstellen. Und dann ist das Ganze auch noch gratis…
http://datapigtechnologies.com/blog/index.php/create-sql-server-tables-from-excel-data-free-tool/
Power BI – Processing data from pdf
Sehr guter Beitrag, der zeigt, dass selbst pdf files unter gewissen Umständen als Datenquellen genutzt werden können:
Web and Data Application Development with Visual Studio 2017 and Azure
Leider bin ich momentan sehr stark in Projekten involviert und habe daher wenig Zeit für meinen Blog. Nichtsdestotrotz habe ich mittlerweile ich Online Kursangebote schätzen gelernt. Man kann auch nach einem harten Arbeitstag, egal ob zuhause oder im Hotel, noch etwas für die Fortbildung tun. Und da ich auch jetzt noch gerne mal etwas im Code grabe, aber gerne auch Tools nutze, die einem Arbeit abnehmen, ist mir dieser Kurs ins Auge gesprungen. Von allem was dabei und trotzdem nicht allzu zeitintensiv:
Power BI and Regular Expressions
I read a quote somewhere along the lines of…
If you are trying to solve a problem with regular expressions...
you now have two problems
This seems a little harsh for a useful tool that has been with us for what seems a very long time. Plenty of languages offer support for RegEx string searching and pattern matching but not so far in Power BI Desktop.
I thought I would share a simple and quick way to enable the use of RegEx in Power BI.
This could be useful in a number of ways. RegEx patterns could help validate strings from source systems:
- Valid email addresses
- URLs
- IP addresses
- Product Codes
- Stripping numbers or texts from strings
I’m going to look at the first scenario and demonstrate with a simple exercise how you might use RegEx to test if email addresses are valid.
DAX and M don’t have any dedicated…
Ursprünglichen Post anzeigen 394 weitere Wörter
On-Premise Power BI VOL. 2
Here we go again, round 2 (or should I say Vol. 2). I am back to discuss how I feel (and I am sure quite a few others do as well) about the new information we received this week on Microsoft Power BI on-premise. You can check out my first blog post regarding this here – On-Premise Power BI–A Microsoft Story.
All of the opinions and information that I state in this post here is simply my personal experiences as well as a few thoughts that I just wanted to post. Oh and by the way, I am not a graphic artist by any means, so please don’t slam me for my mocked up image below. I love movies, so just wanted to put this quick little graphic together, I hope you like it.
What we have learned this week is that Microsoft will provide customers two options…
Ursprünglichen Post anzeigen 905 weitere Wörter
Microsoft Flow – New Approval feature
I really like to try things out. And the new Approval features looks really promising. A very good video can be found here:
What caught my attention was this picture- the perfect scenario for a new challenge:
I will try to solve the highlighted items as follows:
View Sent requests and view my history: This can be done by saving all requests and approvals to a SQL Database
PowerBI reporting: Send all requests and approvals to the PowerBI streaming dataset
Hopefully my next post will show the final solution.
