Stack Overflow
Stack Overflow

Questions tagged [powerbi]

Power BI is a free, self-service analytics tool available individually or integrated with Microsoft Excel, Office 365 and many major databases and analytics tools.

Power BI is a cloud-focused data integration, and visualization service that gives you a single view of your data. Dashboards, reports, and datasets are the core functional objects in Power BI.

The main components of Power BI are Power BI Desktop and the Power BI Web Service. Power BI Desktop is a design tool for integrating datasets and visualizing them in reports, while Power BI Web Service focuses on sharing the reports and dashboards with users so that they can be viewed and interacted with.

Power BI also has a range of APIs for programmatic access to the Power BI Web Service.

Power BI Desktop is available as a free download from Microsoft.

For documentation, please see white papers.

18477 questions
8
votes
2 answers

Dimensional Modelling - ambiguous relations

I've been trying to solve an issue, and to date I haven't been able to reach what I'd say is an optimal solution. I have a dimension (Features) which needs to be referenced in 2 other dimensions (Actions and Sessions), which in turn are referenced…
Zepee
  • 1,640
  • 3
  • 20
  • 40
8
votes
2 answers

Custom sorting in PowerBI chart

Recently I came across one issue in which I need to show the column order as per my defined way in PowerBi report. Thing is, PowerBI sorts the columns in either Ascending(A->Z) or descending(Z->A) order, then if one has to apply his custom order how…
Abhi
  • 341
  • 1
  • 6
  • 23
8
votes
1 answer

How to pass parameter to PowerBI Embedded via embedded URL

I have an IFrame which shows a PowerBI embedded Report that having world map. Can I pass a parameter to PowerBI Embedded via embedded URl to filter my report based on a specific country. Thanks
NKDev
  • 456
  • 3
  • 8
  • 23
8
votes
4 answers

SQL reporting invalid syntax when run in Power BI

I have written an SQL script which runs fine when executed directly in SQL Management Studio. However, when entering it into Power BI as a source, it reports that it has an incorrect syntax. This is the query: EXEC…
Rowan Richards
  • 401
  • 8
  • 20
8
votes
3 answers

Can't import Excel (xls) into Power BI

I tried to import an Excel file (Microsoft Excel 97-2003 Worksheet (*.xls)) into Power BI and I got this weird error. Details: "Excel Workbook: The 'Microsoft.ACE.OLEDB.12.0' provider is not registered on the local machine. The 64-bit version of the…
PBeezy
  • 1,222
  • 2
  • 17
  • 26
8
votes
2 answers

Microsoft Power BI and ElasticSearch

Does anyone know a implementation case that involves PowerBI and ElasticSearch? I was unable to find any proper documentation.
Amiga500
  • 5,874
  • 10
  • 64
  • 117
7
votes
1 answer

PowerBi Error. We're unable to connect. Please delete your credentials and try again later

The following error appears whenever I try to connect to the data sources and authenticate using oAuth login screen on iExplorer web browser.
Emmanuel Millan
  • 411
  • 1
  • 4
  • 12
7
votes
1 answer

Highcharts custom visuals with Data binding PowerBI

Bharath R created a nice example of how to create a highcharts custom visual for PowerBI. However, no data binding has been applied yet. For the highcharts line diagram below I would like to use variables instead of hard coded values. So that it is…
Kees de Jager
  • 582
  • 1
  • 7
  • 25
7
votes
5 answers

Anaconda in Windows with Power BI

I am trying to work with Python in my Windows 10 Machine. My Anaconda environment can be set by executing the following command: c:\Users\bharat.c.rupare.> call c:\Users\bharat.c.ruparel\AppData\Local\Continuum\anaconda3\Scripts\activate.bat this…
Bharat
  • 2,409
  • 6
  • 32
  • 57
7
votes
3 answers

Power BI / add refresh button on report view

I don't have much expertise in Power BI. I started work on it and found it very easy and I've created a report. That report is working fine. Now, I've requirements to add Refresh button on the report that will refresh the data source and get the…
Saadi
  • 2,211
  • 4
  • 21
  • 50
7
votes
1 answer

Average of Grouped Sum

I am looking to create a measure that takes the average of several sums, grouped by an ID. An example would be if you had a database of customers that each purchased a variety of things, and you wanted to find the average amount that customers spent…
Drew Major
  • 501
  • 1
  • 3
  • 18
7
votes
1 answer

SUM IF in Power BI

Is it possible to SUM on conditions in Power BI? I have a column that contains the values UK and Italy alongside other columns: employee and hours spent. I want to make a measure to show total hours spent by an employee in Italy and another to show…
Shoaib Maroof
  • 369
  • 1
  • 3
  • 13
7
votes
1 answer

How to create a switch that toggles which relationship to use?

I want to create switch button that will be changing date (By Accounting date or by Effective date) by which report is viewed. Currently, I have active relationship by Effective date and inactive relationship by Accounting date. Using…
Serdia
  • 4,242
  • 22
  • 86
  • 159
7
votes
3 answers

Power BI Desktop - How to change data source?

When I'm trying to change my existing data source (Microsoft Azure CosmosDB) to Blob Storage, the Change source is disabled. How do I workaround this? I have gone through various questions but none of them were similar to mine. Any help is much…
Dee
  • 483
  • 2
  • 11
  • 24
7
votes
1 answer

Creating a Measure that returns DISTINCT COUNT by Country and Brand in Power BI

I have a table like below: Country, Advertiser, Brand, Spend C1, A1, B1, 10 C1, A1, B2, 5 C1, A2, B3, 0 C1, A2, B4, 20 C2, A1, B1, 8 C2, A1, B5, 7 C2, …
user1330974
  • 2,500
  • 5
  • 32
  • 60
1 2 3
…
99 100