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
10
votes
7 answers

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 requires some workarounds. There's no equivalent…
erop
  • 1,510
  • 1
  • 14
  • 27
9
votes
1 answer

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 the slicer, so I want to select which visuals are…
Gunter Herd
  • 95
  • 1
  • 1
  • 5
9
votes
2 answers

Get Local Time on Power BI Service

As you all might already know, TODAY() function returns UTC time when published to Power BI Service. Our requirement is to return the local (EST) date. As a solution, we created a custom measure that adds UTC offset hours for EST in NOW() and…
Pratik Bhavsar
  • 808
  • 8
  • 32
9
votes
3 answers

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 certificate is invalid according to the validation…
shubham.a
  • 91
  • 1
  • 1
  • 3
9
votes
6 answers

Power BI Desktop DAX restart running total column

I have a table where every person has a record for every day of the year. I used this function to achieve a running total based on the daily balance column CALCULATE( SUM(Leave[Daily Balance]), FILTER( ALLEXCEPT(Leave, Leave[Employee Id]), …
LynseyC
  • 93
  • 1
  • 5
9
votes
3 answers

Programmatically Deploying Power BI Reports to Power BI Report Server and change Connection String

Is there any method to deploy Power BI reports to Power BI Report Server without having to manually copy these files, upload them to the server and finally change the data source connectivity information for each report on a report by report basis…
Mr. Bhosale
  • 3,018
  • 1
  • 17
  • 34
9
votes
1 answer

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 Type, and Values - count of Sales which will show…
Spector
  • 93
  • 1
  • 1
  • 5
9
votes
1 answer

Data scraping from published Power BI visual

How to import data in any programming way from published specific Power BI visual to another PBI report or SQL Server table or just scrap it to local drive? I would like to achieve the same effect as by clicking on three dots ... in the right upper…
Przemyslaw Remin
  • 6,276
  • 25
  • 113
  • 191
9
votes
4 answers

Callback not being invoked

I am building a custom Power BI visualization, so I have access to a javascript file which is consumed by the platform. I don't have access to any markup, only an element that is injected where I am to mount my visualization. I am trying to mount a…
Mister Epic
  • 16,295
  • 13
  • 76
  • 147
9
votes
3 answers

How to connect google sheet with power bi?

I am trying to connect google sheet with power bi using R Studio, there is a video on youtube by stephnie locke, but that is just a short video and dont help completely. any one there which can help properly and completely.
Azam Saleem
  • 129
  • 1
  • 1
  • 3
9
votes
8 answers

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 can help me ??
user5593020
9
votes
5 answers

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 there a way to code in a line break with DAX? FYI,…
jschlereth
  • 1,071
  • 2
  • 10
  • 12
9
votes
5 answers

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 would be appreciated. DataSource.Error:…
Jon Capezzuto
  • 93
  • 1
  • 4
8
votes
1 answer

Power BI extract .pbix and decode DataModel from XPress9

How can I automate the exporting of .pbix to .pbit without Microsoft services? Some hacky solutions using autogui, power automate amongst others. Otherwise does anyone have a python solution or any solution to decode DataModel file from .PBIX…
izzleee
  • 315
  • 3
  • 11
8
votes
3 answers

Connect to Power BI XMLA endpoint with Python

Since the announcement about XMLA endpoints, I've been trying to figure out how to connect to a URL of the form powerbi://api.powerbi.com/v1.0/myorg/[workspace name] as an SSAS OLAP cube via Python, but I haven't gotten anything to work. I have a…
Alexis Olson
  • 38,724
  • 7
  • 42
  • 64
1 2 3
…
99 100