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
2
votes
1 answer

SQL Plan variance scientific notation

I'm dealing with a three piece datapath: client application, host integration server, db server. Client application (MS Mashup Engine) is generating queries that pass through MS SQL Server to a legacy IBM iSeries DB backend. I'm running into issues…
Alexander Toptygin
  • 407
  • 2
  • 8
2
votes
0 answers

Leaflet map not displaying GeoJSON data

i am trying to render some points on a leaflet map embedded in power Bi web. The data submitted to Leaflet is in GeoJSON format. When i input this data everything works fine and the point is correctly displayed: var someFeatures = { "type":…
Luca Longobardi
  • 31
  • 1
  • 3
2
votes
1 answer

How to check if current start and end dates are in previous period (start and end dates)

I have a tricky problem I am working on. I've made several attempts at capturing the data but have been unsuccessful. I have a table in Power Bi that looks like this: The key is in ascending order as well as the StartDate field. I would like to…
StelioK
  • 1,771
  • 1
  • 11
  • 21
2
votes
3 answers

How to deal with header names changing in CSV data source?

Will make this short and sweet - we have a massive .CSV that we are linking to PBI Desktop. Some of the header names in this .CSV were not optimal and have since been updated by the SQL backend. However, PBI is not happy with not being able to…
ballade4
  • 79
  • 3
  • 10
2
votes
0 answers

Automation on PowerBI using Python

I want to write python script to automate some process in dashboard of PowerBI. My use cases are about: Open powerBI and click to page 1 of dashboard. click some filter and then capture the screen. click the other pages and do step 2. I try to run…
CokeZero
  • 21
  • 1
  • 4
2
votes
1 answer

401 - Unauthorized error during Dataset Refresh PowerBI

I am trying to do the Dataset refresh for a PowerBI Report. I created the gateway and I am able to do the dataset refresh from the admin portal. I could validate that the refresh happend successfully from UI i.e. Last Refresh column in the Admin…
Krishnan
  • 958
  • 5
  • 21
  • 44
2
votes
2 answers

Power Bi: Refresh "Publish to Web" link

I have created Power Bi dashboards using Sql Azure as Data Source. I have published the reports on to the Power BI Portal and enabled a scheduled refresh policy. The reports are getting refreshed without any issue in the portal. I have used the…
Priyanthi
  • 21
  • 2
2
votes
1 answer

Powerbi refresh report

We are publishing our powerbi reports embedded into a website with a PowerBI Premium Plan. All our analytic visualizations are on PowerBI but we are in troubles to offer some user interactions through the interface. Specifically, we want to confirm…
PabloCocko
  • 110
  • 1
  • 8
2
votes
1 answer

Power BI: Calculating Week number from Date Column, starting from Saturday and Ending on Friday

I need to calculate WeekOfYear from date column, which starts from Sat and ends on next Friday. I tried WEEKNUM DAX Function, but the option for WeekStart Day is limited which is 1 or 2 (Sunday or Monday), How can calculate the week numbers which…
Ashish25
  • 1,965
  • 1
  • 15
  • 16
2
votes
1 answer

how to calculate monthly budget till current day in power bi Desktop

I have a budget broken down by month. But I need to calculate it till current day. For example : Budget** PostDate** Jan $2,125,889 1/1/2018 Feb $4,141,659 2/1/2018 Mar $4,320,698 3/1/2018 Apr $4,461,430 4/1/2018 May …
Serdia
  • 4,242
  • 22
  • 86
  • 159
2
votes
1 answer

Power BI >> Images not coming up on app

I have a power BI dashboard connecting to SSAS Data Model ( via Live Connection) We have a requirement to display the images on Power BI App. We have a dimension table having Account Name and every account name will have an image/logo. Initially –…
Aravind
  • 179
  • 1
  • 2
  • 14
2
votes
1 answer

Post Method in Power BI

I wrote Power query to post method like follows let url = "https://XXXXXXXXXX/OAuth/Token", body = "{ ""grant_type"": ""password"", ""client_id"": ""XXXXXXXX"", ""client_secret"": ""XXXXXXXXX"", …
Naira
  • 55
  • 1
  • 1
  • 9
2
votes
1 answer

Mobile view is not being shown for embedded powerbi report

We have created a PowerBI report having both the desktop verion and mobile virson. Its showing desktop and pone view properly when we are testing at following sample site after putting correct information.…
Gurpreet Kailey
  • 567
  • 9
  • 26
2
votes
4 answers

Duration calculation in hh:mm:ss using Power BI

I have the following DAX in Power BI to calculate duration. How can I include the seconds? Total Duration = sumx('Sheet1'; hour('Sheet1'[Duration])) + TRUNC(sumx('Sheet1'; MINUTE('Sheet1'[Duration]))/60) & ":" & mod(sumx('Sheet1';…
Nathi Mazibuko
  • 23
  • 1
  • 1
  • 3
2
votes
1 answer

How to outline border of the slicer in Power BI Desktop

How can I outline the border of the slicer? I want to change color of the border of the window where it says "All". I do not need like this: I need something like that" Anyway to achieve that in Power bi?
Serdia
  • 4,242
  • 22
  • 86
  • 159
1 2 3
…
99
100