Working on an SMB Power BI architecture for around 12 months, I wanna share my thoughts, workarounds and proposals for a discussion. As the architecture is pretty new and I used to work with qlik architecture, the last 10 years, I would love to have some feedback from power bi seniors. I have the following […]
The last 6 months have been quiet full of many new things to learn – after working more than 10 years with qlik and SQL a new player named “Power BI” has been added to my skills. So getting more and more used to it, I feel, like I should give other qlik developers to […]
Download the latest Visual Studio Community Edition (about 4gb). Then start a new Project “Console VB.NET” and use the following code for executing a stored procedure on your MS SQL Server:
For my new job I have to move my skills from qlik to microsoft power bi which – at the beginning – is quite challenging. So to keep a bridge in my mind and to speed up my knowledge curve, I document here the samples on how thinks work in qlik sense/view and how in […]
Kategorien
Excel macro loop by sheet
Collect data from multiple excel tabs and put them together at a new collector sheet: Sub WorksheetLoop() Dim WS_Count As Integer Dim I As Integer ‘ Set WS_Count equal to the number of worksheets in the active ‘ workbook. WS_Count = ActiveWorkbook.Worksheets.Count ‘ Begin the loop. For I = 1 To WS_Count ‘ Insert your […]
Kategorien
MS SQL PIVOT with text as Fieldtype
The trick is, that you cast the text/string into varchar and then you can use MAX as aggregation type to return the readable value.
Kategorien
Power BI and MS CRM Entity Tables
Temporary Entity Tables build with DAX Query and using the CRM Tables: StringMapBase MetadataSchema.Entity
Kategorien
Power BI Calender DAX
Generating a calender was a very important task within qlik sense/view – so even as the date functions within power query or dax are awesome, I still prefer to have an “inbuild” calender. To achieve this goal, you can switch to the “Modeling” view -> add a “Table” and then just copy and paste the […]
From time to time it’s needed to loop over the rows of a master table – e.g. different companies within your organisation are stored within different databases. So to avoid creating “long” SQL-scripts where you just change the db information, you can ease it up by: