Skip to main content
20,652 questions
Newest Active Bountied Unanswered
Filter by
Sorted by
Tagged with
78 votes
6 answers
98k views

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?
xorpower's user avatar
  • 19.2k
34 votes
4 answers
49k views

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 ...
eclairs's user avatar
  • 1,705
22 votes
7 answers
38k views

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.
Nelson Gomes Matias's user avatar
  • 2,077
21 votes
5 answers
73k views

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 ...
Asaf Savich's user avatar
  • 653
19 votes
3 answers
76k views

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 ...
Marc Pincince's user avatar
  • 5,232
18 votes
2 answers
34k views

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 ...
vestland's user avatar
  • 62.1k
18 votes
4 answers
13k views

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 ...
cgrayson's user avatar
  • 289
17 votes
3 answers
66k views

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 ...
Ajju Bajju's user avatar
  • 175
16 votes
2 answers
3k views

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 ...
Alexis Olson's user avatar
  • 40.4k
15 votes
2 answers
9k views

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 ...
vestland's user avatar
  • 62.1k
15 votes
1 answer
22k views

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 ...
user9824134's user avatar
  • 410
15 votes
1 answer
448 views

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, [...
Hell.Bent's user avatar
  • 1,667
15 votes
4 answers
43k views

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 ...
Hanyu Wang's user avatar
  • 161
14 votes
1 answer
9k views

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 ...
vestland's user avatar
  • 62.1k
13 votes
4 answers
13k views

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 ...
AlejandroR's user avatar
  • 5,199
13 votes
3 answers
5k views

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(...
Dave D.'s user avatar
  • 777
13 votes
1 answer
3k views

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 ...
Jaber Kibria's user avatar
  • 968
12 votes
1 answer
102k views

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 ...
Bad_Mama_Jama's user avatar
  • 196
12 votes
2 answers
83k views

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: FILTER(...
Lorenz Joe's user avatar
  • 123
11 votes
4 answers
85k views

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.
itsPav's user avatar
  • 640
11 votes
1 answer
6k views

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 ...
ianwuk's user avatar
  • 121
11 votes
4 answers
34k views

Is there a way I can reorder columns in 'Data View' within Power BI? I tried doing it in Power Query first but when the data loads into the table, the columns automatically rearrange.
Ifad Noor's user avatar
  • 135
11 votes
2 answers
2k views

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 ...
user avatar
10 votes
1 answer
115k views

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
Roy25's user avatar
  • 119
10 votes
5 answers
9k views

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 ...
Jon Capezzuto's user avatar
  • 103

1
2 3 4 5
…
414