Forum Discussion
Generate a pbix file with data for a given user
No worries alexk-spicey .
So, one the first couple questions. If you went down the path of Power BI Service and a shared dataset, you could schedule auto-refresh so that the data only updates when you want it to. You could prevent users from updating the data on their own by just giving them Read access. Now, they could download the data as often as they like, but it would not have "new" data until a refresh happened. Let me know if that is not clear. In this scenario you would either need Power BI Premium or everybody would need a Pro license.
Scenario 2. This would work as above in terms of the data load, etc. You would run this in an embedded capacity so your users would not need their own licenses like Premium but way less expensive than Premium generally. I have no idea about rails but I am pretty sure that all the embedding is done in javascript so it should work with any web based application.
Greg_Deckler The current solution is just a quick and easy way to let users report on their own data. I went with this, since it leverages the abilities of Power BI custom reporting, without investing into Azure or any other kind of subscription (keeping the price low) until I knew people liked it. I've had to create a reporting system previously and it was not pleasant lol.
If I made a Power BI dataset like that, would users of my application have to provide their own license? And would this allow a user to pull their full data as often as they want? (both of those being bad haha)
I'm definitely open to the idea of embedding Power BI in the application, do you know the difficulty of embedding it into a rails application? And would I be able to restrict this to the data already exported to the xlsx I mentioned previously? Maintaining the same data restriction logic in as few places as possible is highly desirable 🙂
Sorry, I know it's lots of questions. Thanks so much for your time 🙂
No worries alexk-spicey .
So, one the first couple questions. If you went down the path of Power BI Service and a shared dataset, you could schedule auto-refresh so that the data only updates when you want it to. You could prevent users from updating the data on their own by just giving them Read access. Now, they could download the data as often as they like, but it would not have "new" data until a refresh happened. Let me know if that is not clear. In this scenario you would either need Power BI Premium or everybody would need a Pro license.
Scenario 2. This would work as above in terms of the data load, etc. You would run this in an embedded capacity so your users would not need their own licenses like Premium but way less expensive than Premium generally. I have no idea about rails but I am pretty sure that all the embedding is done in javascript so it should work with any web based application.