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
11
votes
6 answers

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:23 PM Reading (decimal) i.e. 123.456 A new…
Mike Demmons
  • 180
  • 1
  • 1
  • 8
11
votes
3 answers

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(x = dataset$period, y = dataset$mean, name = "spline",…
Dave D.
  • 737
  • 3
  • 10
  • 23
11
votes
1 answer

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 process so I guess an option is to create our own…
Michael Blake
  • 2,068
  • 2
  • 18
  • 31
10
votes
3 answers

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 way to do?
Ajju Bajju
  • 105
  • 1
  • 1
  • 4
10
votes
1 answer

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: FILTER(oldtable;oldtable[Warehouse]=2) and then in the…
Lorenz Joe
  • 103
  • 1
  • 1
  • 5
10
votes
5 answers

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-sample-for-customers I have downloaded the sample app…
devanalyst
  • 1,348
  • 4
  • 28
  • 55
10
votes
1 answer

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 dates. Before running the script, the same values in the…
vestland
  • 55,229
  • 37
  • 187
  • 305
10
votes
3 answers

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 example: Date Equity Duration Credit …
Alexis Olson
  • 38,724
  • 7
  • 42
  • 64
10
votes
2 answers

Custom Paging using a stored procedure with OData feed C# without Entity Framework

I am wondering if anyone can help me, for some time now I have being trying to figure out how to implement custom paging in a OData feed (v4) Web API 2 to feed a power bi feed and having no success. The data is derived from a database first,…
Jimbo Jones
  • 983
  • 4
  • 13
  • 48
10
votes
1 answer

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, "first_name": "George", …
David
  • 4,785
  • 7
  • 39
  • 63
10
votes
1 answer

Pass several parameters in StartLogin function

I am building a custom connector to connect to our API via OAuth2. This is so we can use our api as a data source to powerbi. // Resource definition Resource = [ Description = "MyAPI", Type = "Custom", …
sudeepdino008
  • 3,194
  • 5
  • 39
  • 73
10
votes
1 answer

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
Roy25
  • 111
  • 1
  • 1
  • 3
10
votes
2 answers

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,Atlanta 2017-01-05,13.50,Detroit When I load this…
Jeroen
  • 60,696
  • 40
  • 206
  • 339
10
votes
1 answer

Connecting PowerBI Cloud to PostgreSQL

I have a PowerBI instance and a Postgres database on Heroku. In my search the PostgreSQL connectors for PowerBI all seem to be for…
mikebz
  • 3,277
  • 8
  • 37
  • 50
10
votes
1 answer

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 distinct number of "active" publishers over a…
AME
  • 5,234
  • 23
  • 71
  • 81
1 2
3
…
99 100