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
8
votes
2 answers

How can i load my file from s3 to powerBi?

I want to get some csv files from a bucket in s3. As there is no connector, i need to go through a query to reach s3. How do i set my query ? Tried to use postman and copy the info from the preview in postman, but to no avail. Postman Headers and…
Joe le clodo
  • 97
  • 2
  • 5
8
votes
4 answers

Python console in Power BI

I'm currently working of Power BI with python scripting. I'd like to print (using the function print) but I'm not able to find a way to see my printed message anywhere. I've already search on Google and Stack Overflow if a console exists on Power BI…
Benjamin Audet
  • 463
  • 3
  • 12
8
votes
2 answers

Show 0 value on Line Chart in Power BI for missing data

I have a table with sparse values, but in my line chart I'd like the line to go back to zero when there's no data to show. e.g: instead of: I want: To produce the first graph I used a generated table with a series of values for the x-axis, and…
Dan Rayson
  • 1,315
  • 1
  • 14
  • 37
8
votes
3 answers

How to generate PDF output of powerbi embedded report

I have a powerbi report embedded to my webpage. What I need is to add an "export" button to my page and export the report to the PDF when the button is clicked. How can I achieve this? People online advises using report.print() or window.print(),…
Eray Balkanli
  • 7,752
  • 11
  • 48
  • 82
8
votes
4 answers

Trying to Reorder Columns in Data View in Power BI

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
  • 105
  • 1
  • 1
  • 7
8
votes
2 answers

Python Plotly in Power BI

I'm trying to build a Power BI tool for some data analysis, and one of the plots I need is an inverse quantile plot (quantiles on x axis, values on y axis). Power BI does not have this, and I can't find one on the app marketplace, so am using Python…
Dr. Andrew
  • 2,532
  • 3
  • 26
  • 42
8
votes
1 answer

ADFS Single-Sign-On for SharePoint 2013 on-premises, Power BI and custom web app?

Scenario There is one user store, namely an on-premises AD. ADFS provides authentication for SharePoint 2013 and Power BI. The custom web app needs to authenticate users from AD. The web app back-end also requires access to the SharePoint REST…
Suthan Bala
  • 3,209
  • 5
  • 34
  • 59
8
votes
1 answer

Why OData api called multiple times in power bi desktop

I have a Power BI Desktop application that accesses one Data Source which is an OData feed. When refreshing the data in Power BI Desktop it takes much longer . After clicking on Refresh in the popup it shows "Evaluating" and "Loading 2 KB..." for a…
Ajeet Singh
  • 717
  • 2
  • 6
  • 13
8
votes
0 answers

steps to integrate PowerBI report on Java application

JavaScripts Required jquery.js powerbi.js Generate AAD token I assume that you have Native application built already and all required Power BI Access has been given.If not then refer steps A to C below. I used the steps mentioned on this…
Ashore
  • 77
  • 1
  • 1
  • 4
8
votes
3 answers

Measure in DAX to calculate YTD for chosen month only for Power BI

How to construct DAX measure to calculate sum of YTD value for specific month? Here we have FactTable grouped by months. FactTable is filled with both Actual data and Forecast data. The only way to know when Actual end is information in table [Cut…
Przemyslaw Remin
  • 6,276
  • 25
  • 113
  • 191
8
votes
1 answer

DAX Equivalent to T-SQL AVG OVER(PARTITION BY)

Apologies if this is a simple thing to achieve but after reading several similar posts, I cannot seem to find the right answer. What I am basically trying to do is replicate the functionality of calculating an average over a group of records. Below…
Alan Schofield
  • 19,839
  • 3
  • 22
  • 35
8
votes
1 answer

Measure that counts entries that contain a specific string

I am making a report in which I have to show the take-rates of different items. Each item exists of a three letter string, and all items are pooled in one and the same column as a large string, separated by spaces. I am now trying to create a…
Dries Weytjens
  • 113
  • 1
  • 1
  • 6
8
votes
4 answers

POWERBI - Object reference not set to an instance of an object

I'm trying to connect oracle database using prowerbi desktop. Throwing following error Details: "An error happened while reading data from the provider: 'Object reference not set to an instance of an object.'" Any idea why i see this error? I have…
Praveen Govind
  • 2,619
  • 2
  • 32
  • 45
8
votes
3 answers

Power BI Embedded - Access Token

So I have some graphs in Power BI which I want to share with my clients. I'm making a custom page here on my server and trying to embed those graphs using Power BI Embedded setup. I'm following this link…
asn559
  • 81
  • 1
  • 6
8
votes
1 answer

Power BI report integration in asp.net mvc application

Can you please let me know how to integrate Power BI report in Asp.Net MVC application ? Application Details : Asp.Net MVC4 Hosted on Windows Server. Thanks in advance.
user2266837
  • 587
  • 2
  • 5
  • 12