This information has been around the blogosphere for a while but I keep forgetting how to find it; I decided to write about it on my blog so that I can easily find it next time I need it. The existing functionality of the Power BI Connector for SAP BW only exposes text values of … Continue reading How to Expose Key Values from SAP BW in Power Query
Month: January 2017
Microsoft Flow and Cognitive Services
The Power BI team posted a great article about streaming tweets and sentiment data into Power BI. Unfortunately, the article does not get into the steps necessary to procure and set up Cognitive Services from Microsoft so I figured I would cover these details in this article. If you already have an Azure account, then … Continue reading Microsoft Flow and Cognitive Services
Working with Inline Tables and Using IN Operator in Filter
It's is often handy to be able to define a table in line with your calculation. Apparently, you can do it in DAX using the following syntax: { value1, value1, value3} The statement above creates a table that can be used with a DAX function that expects a table as a parameter. Example: {1, 2, … Continue reading Working with Inline Tables and Using IN Operator in Filter
business intelligist 