Multiple questions on Power BI On-Premises - Please help

[skarthick6]

• Is there a limit on the number of points that can be rendered on the dashboard. What’s the maximum number of marks that are possible using Power BI
• I heard that Power BI requires users to learn a new language DAX to perform regular calculations? Is this correct please confirm
• Is forecasting supported using Power BI?
• Does Power BI provides embedded dashboards in tool tips?
• Can I render Power BI reports offline?
• Does Power BI support Story boarding?
• Does Power BI support What if analysis?
• Does it provide any means to rate content on the server? Does it provide any sort of discussion threads? Does it provide ability to carry out real time collaboration while doing analysis?
• Does it provide the users ability to edit the dashboard and save their own versions online using Web-edit?
• Does it provide direct connection to NoSQL databases?
• Does it support automatic / scheduled refreshes on the data – sets?
• Does it support Multi-level caching?
• Does it allow to set up a separate refresh server to manage load due to data refresh for extracts?
• Does it allow Custom Query creation on all the data sources? If yes please provide the supported data sources for custom query creation?
• Does it provide business user data masking?
• Does it support multi-database joins?
• Does is support incremental loads? Does it support parallel multi-threaded data loads? Does it support field specific incremental data loads?
• Does it support Meta – data repository? Does it support meta data / model reuse? Does it support automatic generation of meta data?
• Does it support MDM? If yes then what MDM vendors does it support?
• Does it support global filters across multiple worksheets?
• Does it support custom hierarchies on data? Data groupings etc?
• Does it support any embedded analytics such as Regression, clustering etc?
• Does it support statistical functions such as Mean, Median, Mode etc?
• Does it support other operating systems such as Linux, Macintosh etc?
• Does it provide for Address Geocoding / map service integration?
• Please comment if Power BI support the following chart types
• Combination Charts
• Heatmap
• Treemap
• Box-plot / hi-lo
• Histogram
• Bubble Chart
• X/Y
• Marimekko
• Network
• Pareto
• Word Cloud

[v-yulgu-msft]

Hi @skarthick6,

• Is there a limit on the number of points that can be rendered on the dashboard. What’s the maximum number of marks that are possible using Power BI

As I know, there is no such a limitation. Also, Power BI dashboard is only available in Power BI server, not in Power BI report server.

• I heard that Power BI requires users to learn a new language DAX to perform regular calculations? Is this correct please confirm

Yes. You can start to learn DAX from this article.

• Is forecasting supported using Power BI?

Yes

• Does Power BI provides embedded dashboards in tool tips?

No

• Can I render Power BI reports offline?

You can open local .pbix file offline. If you want to view service report, offline is not supported.

• Does Power BI support What if analysis?

Yes. Please see Create and use a What if parameter to visualize variables in Power BI Desktop

• Does it provide the users ability to edit the dashboard and save their own versions online using Web-edit?

Users can edit their own dashboard, cannot edit those shared with them.

• Does it provide direct connection to NoSQL databases?

Yes. Data sources supported by DirectQuery in Power BI

• Does it support automatic / scheduled refreshes on the data – sets?

Yes. But for some on-premise data source, you need to configure data gateway to enable scheduled refresh.

• Does it support multi-database joins?

Yes. After importing data from multiple data sources, you can combine them in query editor mode.

• Does is support incremental loads? Does it support parallel multi-threaded data loads? Does it support field specific incremental data loads?

Power BI doesn't support either incremental loads or field specific incremental data loads. To enable parallel multi-threaded data loads, go to File->Options and Settings->Options->CURRENT FILE->Data Load->checkbox 'enable parallel loading of tables'

• Does it support global filters across multiple worksheets? Does it support custom hierarchies on data? Data groupings etc Does it support statistical functions such as Mean, Median, Mode etc?

I would suggest you learn some basic knowledge about how to use Power BI desktop from here. You could go through the necessary articles from the left navigation tab.

• Does it support other operating systems such as Linux, Macintosh etc?

No. Please see Minimum requirements to install Power BI desktop.

By the way, I would suggest you ask one question or related questions in one thread, and provide more description about your question so that you can get your answer more quickly and more detailedly.

Best regards,
Yuliana Gu