User Profile
Cazpian
New Member
Joined 9 years ago
User Widgets
Contributions
Re: licensing
This seems somewhat missleading as the Premium license fee is payable in addition to pro-licensing. This "Premium" service seems to be at a "Premium" price and I can't see any real benifit for my organisation at this stage. Looking at my case specifically .. I'm a member of an organisation which has 300+ employees. We're not the largest organisation, however we consider ourselves one of the largest employers in the area. I have put some figures into the calculator for what I think is reasonable for our business case. 3 x Pro Liceses for the development of power BI reports. 10 x Frequent Consumers of power bi information. 87 x In-Frequent consumers of power bi information. This equates to £3,119 per month, thats an annual costing of £37,428 for an enterprise reporting tool? Based on £7.70 ($9.99) / month for a pro license, I could purchase 405 pro licenses for the same price pre annum and have everyone in the company on a Pro-License ? Is this correct ? I don't need dedicated capacity for our organisation as our current reporting is reasonably simple and we have local servers to do the heavy lifting. There is nothing here, cost wise, that makes me want to make a jump to dedicated capacity and pay these prices. It appears to me that there is a chasm between bringing on businesses like ours with the power bi tool and the leap to dedicated capacity and the premium features that come as a cost.licensing
Hi there, Can someone please advise as to the following statement which was released on the 3rd May 2017 ... "Free users will benefit from access to all data sources, higher workspace storage limits, and higher refresh and streaming rates. These changes will be effective June 1." Does this mean that standard Office 365 users who have the Free Power BI license structure will be able to access reports that utilise an on-premises data-gateway to return the source datasets ? Up until now, I have had to purchase Pro Licenses for any consumers of my reports. Kind Regards, TimRe: DirectQuery: Sort Data by Week Day
Hi, Thanks for your solution, it actually sent me in the right direction. My problem was simply that I assumed that the sort-order was at a table level and not a column level. I didn't realise that Microsoft Power BI allows you to set the sort orderat a column level. My issue was actually caused because the "Sort By Colmn" option appeared grey-out, I was selecting the table name, rather than selecting the column that I wanted to apply the sort order on. Kind Regards, TimDirectQuery: Sort Data by Week Day
Hello, My data is generated via a DirectQuery SQL statement, executed against a known database. I'm trying to order the data so that it appears as chronological weekdays and not ordered alphanumerically. The tool doesn't appear to allow me to add an order-by-clause within the query when editing the source, nor does it allow me to modify the sort order of the dataset via the Modelling ribbon tab within the main desktop UI. I'm summing the quantity information over the set and grouping by the day of the week. I have the day-of-year data in integer format so I could use this to organise the data, however it will only allow the first field of data for sorting within the Axis. What I need is to organise by Day-of-Year and display the Day-of-Week information. Day-of-Year => datename(dy, [Date]) Day-of-Week => datename(dw, [Date]) Any ideas greatly appreciated.
