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.
powerbi
20,424
questions
78
votes
6
answers
98k
views
Difference between PowerPivot, PowerQuery and PowerBI [closed]
What is the difference between
powerpivot,
powerquery
and powerbi?
What are the use cases for each tool?
What are the limitations?
What requirements must be met to use the tool?
- 18.6k
57
votes
5
answers
64k
views
What's the difference between DAX and Power Query (or M)?
I have been working on Power BI for a while now and I often get confused when I browse through help topics of it. They often refer to the functions and formulas being used as DAX functions or Power ...
user2724541
32
votes
4
answers
44k
views
Parsing a .json column in Power BI
I want to parse a .json column through Power BI. I have imported the data directly from the server and have a .json column in the data along with other columns. Is there a way to parse this json ...
- 1,635
29
votes
2
answers
43k
views
Passing parameters to Power BI filter programmatically
In my application I'm displaying a Power BI report. It already works, so there's no problems with showing any report by its ID (guid).
But there are some reports that need to be parametrized, for ...
- 7,756
23
votes
3
answers
10k
views
Is there any way to invoke PowerQuery/M outside of Excel or PowerBI?
Our BI team is really growing to like the Power Query ETL tool used within Excel and Power BI. The functional language M/PowerQuery has great utility and it would be nice to be able to utilize outside ...
- 15.4k
21
votes
5
answers
194k
views
How to get month name from month number in Power BI?
I have Year number and Month Number in my data.
How using DAX can I get the month name out of month number?
In SSRS its very easy. But how to achieve that using DAX?
- 4,358
21
votes
6
answers
31k
views
load data into power BI from relative path
I am trying to find a solution to load an external data file but from a relative path, so when someone else open my PBIX it will still work on his/her computer.
many thanks.
- 1,917
20
votes
5
answers
67k
views
How to use SQL Server stored procedures in Microsoft PowerBI?
I want to generate reports from my SQL Server tables.
I have some already made stored procedures that I would like to use to generate reports from.
I haven't found a way to do so.
Only by ...
- 643
20
votes
2
answers
10k
views
Scraping Data from a website which uses Power BI - retrieving data from Power BI on a website
I want to scrape data from this page (and pages similar to it): https://cereals.ahdb.org.uk/market-data-centre/historical-data/feed-ingredients.aspx
This page uses Power BI. Unfortunately, finding a ...
- 916
18
votes
4
answers
12k
views
Can't get client-credentials access token to authorize Power BI
I'm trying to use the Power BI REST API, using an access token acquired with the "client credentials" method, but I keep getting 403 Forbidden on my requests.
My code follows the pattern ...
- 289
17
votes
2
answers
30k
views
Power BI: How to use Python with multiple tables in the Power Query Editor?
How can you create a new table with a Python script that uses two existing tables as input? For example by performing a left join using pandas merge?
Some details:
Using Home > Edit queries you ...
- 59.5k
17
votes
3
answers
61k
views
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 ...
- 5,082
17
votes
4
answers
32k
views
DAX Calculate function with and without FILTER
What is the difference in results of CALCULATE function if we use it with and without FILTER function. Suppose we have those two measures:
Measure1 = CALCULATE([X], 'FactTable'[Color]="Red")
...
- 6,698
16
votes
6
answers
199k
views
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.
...
- 2,725
16
votes
1
answer
2k
views
Force DAX SWITCH function to use strict (lazy) short-circuit evaluation
Set up:
Similar to this question on a MSDN forum, I have a measure that switches between various other measures (some of them much more complex than others). The measure looks like this (my actual ...
- 39.8k
15
votes
7
answers
32k
views
An error happened while reading data from the provider. The remote certificate is invalid according to the validation procedure
I'm trying to connect Postgres Database on AWS EC2 instance to Microsoft PowerBI. I tried various method available on internet but its showing the above error. Although I've done this connection on ...
- 333
15
votes
2
answers
106k
views
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 #.##...
- 757
15
votes
3
answers
48k
views
Refresh powerBI data with additional column
I have built a powerBI dashboard with data source from Datalake Gen2. I am trying to add new column into my original data source. How to refresh from PowerBI side without much issues or whats the best ...
- 155
15
votes
2
answers
8k
views
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 ...
- 59.5k
15
votes
1
answer
22k
views
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 ...
- 410
15
votes
4
answers
11k
views
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 ...
- 333
15
votes
1
answer
433
views
SQL: Most Overdue pair of numbers?
We have a this table and random data load:
CREATE TABLE [dbo].[webscrape](
[id] [int] IDENTITY(1,1) NOT NULL,
[date] [date] NULL,
[value1] [int] NULL,
[value2] [int] NULL,
[...
- 1,667
15
votes
3
answers
11k
views
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 ...
- 2,567
14
votes
1
answer
84k
views
Power BI (DAX): Distinct Count Filtered by Condition
I have a data set with publishers with revenue by month. Publishers are considered to be "active" month if their revenue is equal or greater than 1000 for a given month.
Now, I want to count the ...
- 5,270
14
votes
6
answers
38k
views
How to include 'Time' in Date Hierarchy in Power BI
I am working on a report in Power BI. One of the tables in my data model collects sensor data. It has the following columns:
Serial (int) i.e. 123456789
Timestamp (datetime) i.e. 12/20/2016 12:04:...
- 310
14
votes
1
answer
9k
views
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 ...
- 59.5k
14
votes
3
answers
3k
views
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,...
- 7,849
14
votes
2
answers
36k
views
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 ...
- 151
13
votes
4
answers
12k
views
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 ...
- 5,171
13
votes
7
answers
53k
views
How to get WorkspaceId in PowerBI?
I am new to PowerBI. I am trying to implement "App owns data" i.e. embed reports within my web application. I am following this article https://learn.microsoft.com/en-us/power-bi/developer/embed-...
- 1,438
13
votes
1
answer
2k
views
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 ...
- 951
12
votes
3
answers
4k
views
Is it possible to use R Plotly library in R Script Visual of Power BI?
Has anyone tried using Plotly or Highchart in R Script Visual of Power BI,
when I try this in R script editor and Run:
library(ggplot2)
library(plotly)
x <- 1:5
y <- c(1, 3, 2, 3, 1)
plot_ly(...
- 757
11
votes
1
answer
36k
views
How to get paginated data from API in Power BI
Let's say we have this endpoint https://reqres.in/api/users.
The response is
{
"page": 1,
"per_page": 3,
"total": 12,
"total_pages": 4,
"data": [
{
"id": 1,
...
- 4,875
11
votes
1
answer
90k
views
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 ...
- 186
11
votes
3
answers
69k
views
Hover Over Text in PowerBI
Wondering if there's a way to make a text bubble show up when the user hovers over a metric in a Power BI report.
I have tried using alt text, but that does not show up anywhere.
- 612
11
votes
1
answer
12k
views
Custom aggregate column in power bi matrix
I'm trying to create a matrix in a Power BI report summarizing Salesperson performance sliced in a number of different ways.
I know how to create a matrix with Rows - Salesperson, Columns - Product ...
- 113
11
votes
1
answer
6k
views
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 ...
- 121
11
votes
8
answers
44k
views
Get "not allowed for columns on the one side of a many-to-one relationship" errors
i have created Power bi project, It is working fine in the beginning but when i refresh my datasource , i get this error " not allowed for columns on the one side of a many-to-one relationship" . Any ...
user5593020
11
votes
1
answer
34k
views
Power BI: excluding a visual from a slicer
I have two different visuals on the same page of a Power BI doc, but one is being affected by the page slicer while the other one isn't. I have other visuals on the same tab that I want to slice by ...
- 115
11
votes
2
answers
67k
views
Combine PowerBI DAX Filter and SELECTCOLUMN
I want to create a new table based on this one:
that filters for Warehouse=2 and "drops" the columns "Price" and "Cost" like this:
I have managed to apply the filter in the first step using:
...
- 113
11
votes
1
answer
3k
views
Is there documentation/an API for the PBix file format?
We have large csv files in Azure Blobs that we want to report on.
It looks like with some M, we can use Power BI desktop to connect to the blobs and start to report on them.
We want to automate this ...
- 2,128
11
votes
2
answers
2k
views
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 ...
user11156893
10
votes
7
answers
20k
views
No QUARTER() in DAX? Really?
While building a Calendar table with PowerQuery for a PowerPivot model in Excel 2013 I use its Date.QuarterOfYear function to get the number of the quarter.
Building the same thing in SSAS Tabular ...
- 1,570
10
votes
1
answer
108k
views
Creating an index column for Power Bi
I have a table of member IDs and transactions in Power BI, I would like to create an index column for it, any suggestions?
Regards
- 111
10
votes
4
answers
32k
views
Power Bi PostgreSQL data import error - The remote certificate is invalid according to the validation procedure.'"
I am trying to connect PostgreSQL database to Power Bi. Database is hosted on Heroku. I am getting the following error -
An error happened while reading data from the provider:
'The remote ...
- 101
10
votes
5
answers
9k
views
Npgsql 3.0.3 error with Power BI Desktop
I'm receiving the following error when connecting to an AWS Postgres database that requires SSL. I recently upgraded from npgsql 2.3.2 (which was buggy) to 3.0.3 which won't connect. Any suggestions ...
- 103
10
votes
7
answers
55k
views
Is there a way to add line breaks in a string of text in Microsoft's DAX language?
I have a DAX function that pulls in multiple strings of text (from multiple columns) into one cell. But on display I want to have a line break in between the header and the body of the paragraph. Is ...
- 1,081
10
votes
2
answers
24k
views
Prevent loss of decimal separator when importing CSV in PowerBI
I was creating a repro for a different PowerBI question, and crafted this example (UTF-8) CSV in Notepad:
IssueDate,Total,Location
2017-01-02,29.50,Detroit
2017-01-03,11.50,Boston
2017-01-04,13.50,...
- 62.7k
10
votes
1
answer
8k
views
Python script in Power BI returns date as Microsoft.OleDb.Date
After importing a csv file with two columns [Date, Value] and transforming it using Home > Edit Queries > Transform > Run Python Script, the Date column shows Microsoft.OleDb.Date instead of ...
- 59.5k
10
votes
3
answers
15k
views
Multiple Linear Regression in Power BI
Suppose I have a set of returns and I want to compute its beta values versus different market indices. Let's use the following set of data in a table named Returns for the sake of having a concrete ...
- 39.8k