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
15
votes
1 answer

Power BI Dynamic Legend

I'm working with a geographical hierarchy. I'd like for the Legend on my line or ribbon chart to show the next lowest relevant level of detail based upon a slicer selection. GOAL: No Slicer Selection yields a Regional Chart (lines for Southeast,…
user9824134
  • 400
  • 1
  • 3
  • 13
15
votes
4 answers

Node js App integration with power bi rest Api

Is there a way using power bi rest API in node js, I watched video ,Ran Breuer and Arina Hantsis were showing the demo here,Setting up and Getting Started with Power BI Embedded I want to achieve same but using node js, in our development…
Jo Joy
  • 333
  • 2
  • 14
15
votes
3 answers

What do "Enable Load" and "Include In Report Refresh" mean/do?

In Power Query, when I right-click on the name of a query (in the left-most pane of Power Query's window) I see selections for "Enable Load" and "Include In Report Refresh." I cannot find an explanation of what these two selections actually mean…
Marc Pincince
  • 4,987
  • 6
  • 19
  • 40
15
votes
2 answers

How to format new measure (not column) in power BI as percentage?

When I create a new measure with formula, i.e. sum(col1)/max(col2), it automatically converts the result into #.#% format. Strangely, it doesn't happen all the time; sometimes it just gives result #.## format. Any idea of how to format a new…
Dave D.
  • 737
  • 3
  • 10
  • 23
15
votes
6 answers

Converting an Integer to a Text Value in Power BI

I’m creating a calculated column in a Power BI report. The calculated column concatenates integer and text columns. I tried using the below query to accomplish this, but it resulted in a syntax error. CalculatedColumn =…
bmsqldev
  • 2,627
  • 10
  • 31
  • 65
15
votes
3 answers

How do I use Power BI Desktop with version control?

Greetings beloved comrades, I am building a series of power bi dashboards, and as they go into production I'd like to put them into TFS. However, due to the large datasets involved, some of these report definitions are quite large (1.6GB). It…
Eric Hauenstein
  • 2,557
  • 6
  • 31
  • 41
14
votes
1 answer

Operations on multiple tables / datasets with Edit Queries and R in Power BI

I have two tables tbl_A and tbl_B in a Power BI file that I'd like to transform and analyze using the Run R Script functionality in Edit Queries. This would include handling missing values and joining the tables. However, when starting R, it seems…
vestland
  • 55,229
  • 37
  • 187
  • 305
13
votes
1 answer

Unable to change Power BI connection string using API

I'm trying to change Power BI connection string using their API (Microsoft.IdentityModel.Clients.ActiveDirectory). Using this API, I'm able to publish .pbix file to my PBI account. But Getting Bad Request error while trying to update dataset…
Jaber Kibria
  • 932
  • 3
  • 9
  • 29
13
votes
2 answers

A web API key can only be specified when a web API key name is provided

I was trying to get data from a vendor's REST API from Power BI. When getting data, under Web API, it keeps throwing this error. See attached screenshot. It is a POST method where you can filter by any field in the response body (yet I'm not…
Hanyu Wang
  • 141
  • 1
  • 1
  • 5
13
votes
3 answers

Dynamic DAX Number Format

I want to dynamically change the number format of a DAX measure, based on a dimension value (or indeed, based on the order of magnitude of the measure value). I understand I can use SWITCH and FORMAT, as demonstrated by Kaspar De Jonge here:…
Olly
  • 7,749
  • 1
  • 19
  • 38
13
votes
2 answers

R script in Power BI returns date as Microsoft.OleDb.Date

The essence: Why does Powerbi show data of the form 2017-01-04 (yyyy-mm-dd) like this? The details I'm trying to transform a table in Power BI using the Run R Script functionality in Edit Query. The source of the table is a csv file with a column…
vestland
  • 55,229
  • 37
  • 187
  • 305
13
votes
4 answers

Microsoft business intelligence platform vs QlikView

I have no experience at all with QlikView, but I have read great reviews about it. According to Gartner Research Report 2012, QlikView is in the top quadrant together with Microsoft, Oracle, SAP and IBM (leaders and visionaries). I am interested in…
AlejandroR
  • 5,133
  • 4
  • 35
  • 45
11
votes
2 answers

Power BI Slow with SSAS Multidimensional Cube

We are implementing Power BI with SSAS Cube Direct Query. For some reason, SSAS Power BI is extremely slow performance, however using SSDT SSAS Application or Power View or Excel is Much faster. I read that Power BI converts SSAS Multidimensional…
user11156893
11
votes
1 answer

Cannot install Microsoft Power Bi Postgre SQL connector

I am trying to use Microsoft Power Bi to connect to a PostgreSQL database. When I go to Get Data it just says that the connector requires one or more additional components to be installed before it can be used I have installed Microsoft Power Bi…
ianwuk
  • 121
  • 1
  • 4
11
votes
1 answer

Power BI, DAX--How do I count rows in one table based on values in another table?

I have two tables, lets call them Table1 and Table2. Table1 has a column of unique values, Table2 has a column with the same values but repeated. What I am trying to accomplish is to calculate the number of times that value appears in Table2 as a…
Bad_Mama_Jama
  • 186
  • 2
  • 2
  • 11
1
2
3
…
99 100