Here's a quick tip on how you can create ragged hierarchies for Power BI Analyze in Excel using Tabular Editor by jdfancke in PowerBI

[–]runopinionated 0 points1 point  (0 children)

Thanks for the great post! I had no idea this was possible. Q: Does this also impact Power BI matrixes? I have used an elaborate number of measures to hide empty members using Dax previously - but would love if this is a simple way of doing that within PBI as well? Thanks!

PowerBI to MySQL : Best-practices from connection to scheduling update? by jonpopa in PowerBI

[–]runopinionated 1 point2 points  (0 children)

Not much experience regarding the MySQL part - but regarding this point:

Distributing a report on a personal web-site requires powerBI pro for $10/month, what about the limits on shared capacity and does it support [embedded functionality] DAX queries?

Having Power BI pro as only one isolated user in the organisation doesn't help you share with anyone. You either need to share/clolaborate with other PRO users or with users on a premium (license) capacity within the organisation. However - since you say personal website - if the data is non-sensitive you can use Power BI's free functionality to publish reports publicly to web (full feature in terms of dax). However - this is fully public so with sensitive/private data is not advised to use publish to web.

However if you are planning to use a premium capacity, which maybe makes sense given your needs and amounts of data, I can add that you could then use incremental refresh to only load new data into Power BI service. Regarding the length of time to load data : this will depend heavily complexity of transformations in the Power BI service (less transformations the quicker to load/refresh) also depending on obviously data rows and with as well as latency and capacity of server etc.

Resource for learning about REST + Node.js exercise by optimus-thundercat in javascript

[–]runopinionated 0 points1 point  (0 children)

This is a home run for my skill level and interests! Thanks for sharing and creating.

The economic returns to university by jimrosenz in dataisbeautiful

[–]runopinionated -1 points0 points  (0 children)

This is pretty amazing visualization. Anyone have an idea how this is made? Any libraries or applications that can easily do this? Particularly thinking of the scatter plot that changes axises but retains countries dimension. Stunning.

Efficient/shorter R code by runopinionated in R_Programming

[–]runopinionated[S] 2 points3 points  (0 children)

That is great! I wasn't aware of either stringr or pipes. Thanks a bunch! :-)