Power BI 勉強会 #20 で お話ししようかっていうメモ

難しいとか、わかりにくいとかを勉強しない/していない理由にしている人にはコミュニティメンバーとして興味がありません。難しいとか、わかりにくい から勉強しなければならないのだと思うのです。
# Power BI 勉強会 #20 
https://twitter.com/PowerBIxyz/status/1367322092589383684

# 新しい機能とか
## Ignite 2021 で発表されたこと
### Power BI Premium per user
21年4月に一般公開(GA)
略して "PPU"
なぜか略すのがお好きの方が多いのだけど、周知済みとか一般的ではないし、これだけではなく機能とかサービス名はできるだけ略さないほうがよいのでは？
#### 特徴
##### コスト
- 驚きの **JPY 2,170 /user/month**
    - [価格と製品の比較 | Microsoft Power BI](https://powerbi.microsoft.com/ja-jp/pricing/)
- Power BI Pro が含まれている
    - Power BI Premium per user add-on
    - Power BI Pro / Microsoft 365 E5
    - $10/user/month

##### スペック
- 最大 x16 のパフォーマンス向上が期待できること
- Power BI Premium Gen2 に構築

##### 機能
###### Power BI Premium 機能のいくつかが使える
[Power BI Premium Per User FAQ (preview) - Power BI | Microsoft Docs](https://docs.microsoft.com/en-us/power-bi/admin/service-premium-per-user-faq)

- Large model size
    - 最大 100 GB マジ？
        - [Large datasets in Power BI Premium - Power BI | Microsoft Docs](https://docs.microsoft.com/en-us/power-bi/admin/service-premium-large-models)
        - 増分更新で到達可能
            - [Incremental refresh in Power BI - Power BI | Microsoft Docs](https://docs.microsoft.com/en-us/power-bi/admin/service-premium-incremental-refresh)
- Refresh rate
    - 48/day
    - おそらく、Power BI REST API では回数制限なし
        - [Datasets - Refresh Dataset In Group (Power BI Power BI REST APIs) | Microsoft Docs](https://docs.microsoft.com/ja-jp/rest/api/power-bi/datasets/refreshdatasetingroup)
- AI Insights
    - [Use Machine Learning and Cognitive Services with dataflows - Power BI | Microsoft Docs](https://docs.microsoft.com/en-us/power-bi/transform-model/dataflows/dataflows-machine-learning-integration)
    - [Connect to AI Insights in Power BI Desktop - Power BI | Microsoft Docs](https://docs.microsoft.com/en-us/power-bi/transform-model/desktop-ai-insights)
    - AutomatedML
    - Cognitive Service
        - Text Analytics
            - Detect language
            - Extract key phrase
            - Score sentiment
        - Vision
            - Tag image
- Power BI Dataflows
    - [Premium features of dataflows - Power BI | Microsoft Docs](https://docs.microsoft.com/en-us/power-bi/transform-model/dataflows/dataflows-premium-features)
    - Enhanced compute engine
    - Direct Query
    - Computed entities
    - Linked Entities
    - Incremental refresh
- XMLA Endpoint
    - [Dataset connectivity and management with the XMLA endpoint in Power BI - Power BI | Microsoft Docs](https://docs.microsoft.com/en-us/power-bi/admin/service-premium-connect-tools)
    - Read / Wirte

###### できないこと
- Power BI Free ユーザに共有できません
    - Unlimited distribution は Power BI Premium のみ
- Power BI Pro ユーザとも共有できません
- Power BI Report server は付属しません

## 追加された機能
### Object-Level Security(OLS)
- [Announcing public preview of Object-Level Security in Power BI | Microsoft Power BI Blog | Microsoft Power BI](https://powerbi.microsoft.com/en-us/blog/object-level-security-ols-now-available-for-public-preview-in-power-bi-premium/)
- [Object-level security - Power Platform Release Plan | Microsoft Docs](https://docs.microsoft.com/en-us/power-platform-release-plan/2020wave2/power-bi/object-level-security)
 
> OLS is a feature inherited from Azure Analysis Services and SQL Server Analysis Services (SSAS), providing backward compatibility for models migrated to Power BI.

- [Analysis Services tabular model object-level security | Microsoft Docs](https://docs.microsoft.com/en-us/analysis-services/tabular-models/object-level-security?view=asallproducts-allversions)

#### 準備は周到に/ご利用は計画的に
DirectQuery、Row-level security (RLS) 同様、ご利用は計画的に。

- 本当に必要とされている機能なのか
- 代替手段がないのか
- 運用や管理にどこまで影響するのか
- [Row-level security (RLS) guidance in Power BI Desktop - Power BI | Microsoft Docs](https://docs.microsoft.com/en-us/power-bi/guidance/rls-guidance)

### Anomaly detection (異常検出)
- [Anomaly detection tutorial - Power BI | Microsoft Docs](https://docs.microsoft.com/en-us/power-bi/visuals/power-bi-visualization-anomaly-detection)
- [Anomaly detection (preview) | Microsoft Power BI Blog | Microsoft Power BI](https://powerbi.microsoft.com/en-us/blog/anomaly-detection-preview/)
- [Anomaly detection (preview) is now supported in Power BI Mobile apps | Microsoft Power BI Blog | Microsoft Power BI](https://powerbi.microsoft.com/en-us/blog/anomaly-detection-preview-is-now-supported-in-power-bi-mobile-apps/)

# オンデマンド(YouTube)

- [Drive a data culture with Power BI: Vision Strategy and roadmap | FS183](https://www.youtube.com/watch?v=xQHM7QZQvbU)
- [Drive a data culture with Power BI and Microsoft Teams | OD351](https://www.youtube.com/watch?v=mtF26d81vV8)
- [uild systems of intelligence with Power BI and Azure Data | OD352](https://www.youtube.com/watch?v=Fii2UA0laWg)
- [Embed Power BI analytics in web portals and apps for your organization and customers | OD353](https://www.youtube.com/watch?v=d-fbkqwGxMQ)
- [Turbocharge Dynamics 365 with the Power Platform | OD354](https://www.youtube.com/watch?v=vvTq2dwoj4Y)
- [Ask the Experts: Drive a data culture with Power BI: Vision Strategy and roadmap | ATE-FS183](https://www.youtube.com/watch?v=YqMmQkycvlw)
- [Ask the Experts: Drive a data culture with Power BI: Vision Strategy and roadmap | ATE-FS183-R2](https://www.youtube.com/watch?v=imHzLPUCCrs)

# 思ったこと🙄
詳しくは自身で試して勉強してね。これ一番大事。
# その他
- [Power BI 勉強会 - connpass](https://powerbi.connpass.com/)
- [Power BI Desktop を使い始めるには](http://qiita.com/PowerBIxyz/items/6c4735cb5b5712e70981)
- [Excel で Power Query を使い始めるには](http://qiita.com/PowerBIxyz/items/52e563037b855a099ca9)