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

Difference between PowerPivot, PowerQuery and PowerBI

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
  • 17,975
  • 51
  • 129
  • 180
55
votes
4 answers

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 Query, but I am unable to tell the difference…
user2724541
29
votes
4 answers

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 column? Example: Key IDNumber Module …
eclairs
  • 1,515
  • 6
  • 21
  • 26
29
votes
2 answers

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 instance, with current year or person who views the…
andrew.fox
  • 7,435
  • 5
  • 52
  • 75
21
votes
3 answers

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 of the context of PowerBI. Is there or are there…
dkackman
  • 15,179
  • 13
  • 69
  • 123
20
votes
2 answers

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 way to scrape Power BI is hard, because everyone…
am.rez
  • 876
  • 2
  • 12
  • 24
20
votes
3 answers

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?
Serdia
  • 4,242
  • 22
  • 86
  • 159
19
votes
5 answers

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 rewriting the queries. Thanks :)
Asaf Savich
  • 623
  • 1
  • 9
  • 29
18
votes
6 answers

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.
Nelson Gomes Matias
  • 1,787
  • 5
  • 22
  • 35
17
votes
2 answers

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 can utilize Python under Transform > Run Python Script.…
vestland
  • 55,229
  • 37
  • 187
  • 305
17
votes
4 answers

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 demonstrated in this AzureAD sample. In fact, to isolate this…
cgrayson
  • 279
  • 1
  • 3
  • 9
16
votes
4 answers

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") Measure2 = CALCULATE([X], FILTER('FactTable',…
Przemyslaw Remin
  • 6,276
  • 25
  • 113
  • 191
15
votes
0 answers

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 measure has more cases): VariableMeasure = VAR…
Alexis Olson
  • 38,724
  • 7
  • 42
  • 64
15
votes
1 answer

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, [value3] [int] NULL, [value4] [int] NULL, …
Hell.Bent
  • 1,667
  • 9
  • 38
  • 73
15
votes
6 answers

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 AWS RDS. I installed required dependencies (GAC)…
Mr.Robot
  • 333
  • 1
  • 2
  • 13
1
2 3
…
99 100