Webinar Recording: Make powerful decisions with Power BI

Top Questions Asked During Our Webinar

  1. Is it possible to connect to multiple data sources in Power BI at the same time?
    Yes, the list of data sources for Power BI is extensive, and you can connect to multiple data sources at the same time. Also, you can create relationships among them as required.
    Power BI FAQ
  1. Is there a Power BI data connector for SAP HANA?
    Yes, there is a connector available for SAP HANA. The details can be found here.
  1. Which is a better option to get data from the SQL server data source – import or DirectQuery ?
    It depends upon your requirement. In import โ€“ the selected tables and columns are imported into Power BI Desktop, while in DirectQuery โ€“ no data is imported or copied into Power BI Desktop. When using DirectQuery, there is a row limit of 1 million for returning data. Also, the relationship filtering is limited to a single direction, rather than both the directions. You can find more details here.
  1. How long does it take the huge ERP Data to load?
    The load time typically depends upon the size of your data.
  1. How to do data warehousing in Power BI?
    Power BI is not a data warehousing tool. It is a tool to analyze and visualize the best from your data, and share insights.
  1. Can we schedule and send reports through email for a group of users internal and external?
    To send the reports through email, you can have the users in your organization subscribe to each page they want to have emailed to them. You can find more details on this here.

For external users, you can use Export Power BI to PowerPoint or Print to PDF and then share those reports with the users through email.

  1. Is it possible to take an input and show impact of the input in existing report? For example, if our power cost is increased by a number, then how much will the production cost be impacted?
    Yes, you can use What-If analysis feature in Power BI to see the impact of an input in the existing report. You can find more details on this here.
  1. As Power BI has introduced a new feature called automatic refresh, can we create a dependency and then publish?
    No, you cannot create a dependency to publish. In Power BI Premium, if your dataset is configured for DirectQuery connection, datasets are refreshed when interaction with the data occurs, or you can manually adjust the refresh frequency in the Scheduled cache refresh option.
  1. How can we increase the response of any report when we user Azure Analysis Service for large data?
    Azure Analysis Service (AAS) is a service offered by Azure where you may host semantic data models. AAS offers the option to put the data in an in-memory columnar cache, which can accelerate queries to improve performance. This not only improves the query experience but hitting the cache also reduces the query load on your underlying database.

As the data model is on the cloud, you may rarely face any performance issues. You can ensure that your model is hosted on the same zone or a nearby zone from where you would mostly access the Power BI reports.

You can explore more on connecting to Azure Analysis Service here.

  1. What is the relation between Microsoft Azure and Microsoft Power BI?
    With Azure services and Power BI, you can turn your data processing efforts into analytics and reports that provide real-time insights into your business. Whether your data processing is cloud-based or on-premises, straightforward or complex, single-sourced, or massively scaled, warehoused or real-time, Azure and Power BI have the built-in connectivity and integration to bring your business intelligence efforts to life.

You can explore more on this topic here.

  1. What is DAX and how is it to be used?
    DAX is a collection of functions, operators, and constants that can be used in a formula, or expression, to calculate and return one or more values. It helps you create new information from the data already present in your model. You can find more on this here.

Business Intelligence Services by Advaiya