Home › Forums › Power Pivot › Welcome to AMA with Avi Singh 4/1 9-10AM PST
This topic contains 9 replies, has 3 voices, and was last updated by Avi Singh 8 years, 1 month ago.
-
AuthorPosts
-
April 1, 2016 at 4:09 pm #4041
UPDATE: Hey thanks to everyone who joined. Clearly I cannot type the responses fast enough 🙂 So I am glad we started this with a small-ish crowd. But you asked some good questions and I hope I provided some serviceable answers. Power On my friends! Till next time…
Hello Friends!
- If your questions is around the book, please set the Topic Title as
“BOOK: Chapter 6…” or “BOOK: Page 36…” - We hope you are enjoying the book. We would really appreciate if you took a minute to leave an Amazon Review
- All questions may not be answered, if you have a real world challenge you are dealing with consider tapping into our Helpdesk
New format for me, so cut me a little bit of slack.
Power On!
-Avi Singh
Please review our Book on Amazon | Buy our new Power BI BookApril 1, 2016 at 4:16 pm #4047Hi Avi,
I have created my data model and dashboard in PowerBI Desktop. Is it possible to create KPI’s or conditional formatting for multiple line items? This works well in Power Pivot but I can’t recreate it in PowerBI Desktop. Can suggestions?
Thank you!
Pam
April 1, 2016 at 4:18 pm #4048Pam, 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.
April 1, 2016 at 4:29 pm #4053Hi Avi,
Is it possible to have both a free and Pro PowerBI license ? Can I set up two different accounts?
Thanks,
Pam
April 1, 2016 at 4:35 pm #4056Pam,
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 BookApril 1, 2016 at 4:35 pm #4057Hi Avi,
One more question. With the PowerBI PRO license when someone shares a content pack with me, what am I getting? Do I get the entire data model and the measures already created? Can I write my own measures against the shared content pack? Can I combine it with other data models?
Thank you,
Pam
April 1, 2016 at 4:49 pm #4060Pam, 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: IntroductionChew 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 BookApril 1, 2016 at 4:54 pm #4061Pam,
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 BIThat 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 BookApril 1, 2016 at 4:59 pm #4063Hi Avi –
My DBA is very concerned with system performance, and is leery of PowerPivot connecting directly to our DB2, holding SAP’s data.
My current workaround is to perform the query directly in SAP, and export to a text file. Then Power Query looks for all the text files in a particular folder…etc.
My question is how can I help to calm his fears? When does the strain on system performance happen? My guess is it only happens on the data model refresh, and not in response to slicer clicks?
Best,
~ Chris
April 1, 2016 at 5:09 pm #4066Chris,
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 - If your questions is around the book, please set the Topic Title as
-
AuthorPosts
The topic ‘Welcome to AMA with Avi Singh 4/1 9-10AM PST’ is closed to new replies.