[Avi SinghParticipant Started: 5Replies: 7Total: 12]

Chris,

As Rob says, “Keep your friends close, and your DBAs closer!”. Okay, that’s a bit snarky. But truly, make DBA your partner. So you are on the right track here.

Yes, the “load” only happens on the refresh. You can discuss with the DBA when the lowest load times are (typically during the night) and then perhaps use Power Update to schedule the refresh at that hour.

Power On!
-Avi Singh
Please review our Book on Amazon | Buy our new Power BI Book

[Avi SinghParticipant Started: 5Replies: 7Total: 12]

Pam,

Okay, here’s more on sharing. Sounds like you want to work on the Data Model in collaboration with someone else.
First of all, the “Authoring” of the Data Model is done outside PowerBI.com in Excel+PowerPivot, PBI Desktop.
Once authored, you “publish” to PowerBI.com. After”publish” you want to “Share” with others.

In order to collaborate with others on Model Author and Publish, you should look into “Groups”.
See:Groups in Power BI

That way

• Multiple Authors can edit/update the Data Model using whichever tool is in use (Excel+PowerPivot, PBI Desktop)
  Here, I try to make sure that multiple authors do not step on each other.
• If they are part of the same “Group” they can both “Publish” the new Data Model to the same area
• Once “Published”, it can be shared via any of Power BI sharing options with a wider user set

Hope that helps.
Power On!
-Avi Singh
Please review our Book on Amazon | Buy our new Power BI Book

[Avi SinghParticipant Started: 5Replies: 7Total: 12]

Pam, good question. I do get quite a few questions around Sharing and how it works across free vs paid.
You may already know, but sharing some links with basic info for anyone else who stumbles on this.
How should I share Power BI dashboards and reports? Share a Dashboard, Groups, Content Pack
Organizational content packs: Introduction

Chew on this…while I type up the rest of my response 🙂

Power On!
-Avi Singh
Please review our Book on Amazon | Buy our new Power BI Book

[Avi SinghParticipant Started: 5Replies: 7Total: 12]

Pam,

If you have two separate work email accounts, you can setup two different Power BI accounts. And yes, one can be free, while the other is Paid.

For the same account (single email), can it have a Free as well as Paid license? Hmmm…technically perhaps yes (I’d need to check), but I would suspect that would mean that effectively you have a paid account.

I am curious as to what is the scenario where you are planning to use Free/Paid account. Just perhaps to test that some reports/dashboards can be seen by free accounts?

Power On!
-Avi Singh
Please review our Book on Amazon | Buy our new Power BI Book

[Avi SinghParticipant Started: 5Replies: 7Total: 12]

Pam, I think PBI Desktop at this point does not support KPIs. The way to accomplish that is to “author” the model in Excel and then import that into PBI Desktop. Another alternative is to use SSAS Tabular, but that’s a whole another ball game.

[Avi SinghParticipant Started: 5Replies: 7Total: 12]

Thanks Charles. Yes, indeed, that setting helps. But each time the development team places a new copy of the file, the operations team needs to open the file and change this setting. Argh!

The setting seems to be per file, per user basis. So this really makes it impossible for Operations team to schedule an automated PU refresh. Since Operations team does not control when Development may promote a new version to Production (quite frequently, agile BI 🙂 ). If Operation were to schedule an automated PU refresh, it starts failing when Dev places a new file.

Any way we could step around this issue?

Screenshot: http://screencast.com/t/GBZCPnX8

 

[Avi SinghParticipant Started: 5Replies: 7Total: 12]

Thanks austinsense. I was confused as I didn’t understand that aggregators had row context (which 20/20 hindsight now sounds logical). I knew that calculate turned row into filter context. Not likely to forget this one.

[Author]

Posts