Stack Overflow
Stack Overflow

Questions tagged [powerbi-desktop]

Power BI Desktop is the desktop application for Power BI, a free, self-service analytics tool.

3559 questions
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
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
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
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

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

PowerBi Error. We're unable to connect. Please delete your credentials and try again later

The following error appears whenever I try to connect to the data sources and authenticate using oAuth login screen on iExplorer web browser.
Emmanuel Millan
  • 411
  • 1
  • 4
  • 12
7
votes
3 answers

Power BI Desktop - How to change data source?

When I'm trying to change my existing data source (Microsoft Azure CosmosDB) to Blob Storage, the Change source is disabled. How do I workaround this? I have gone through various questions but none of them were similar to mine. Any help is much…
Dee
  • 483
  • 2
  • 11
  • 24
7
votes
1 answer

Creating a Measure that returns DISTINCT COUNT by Country and Brand in Power BI

I have a table like below: Country, Advertiser, Brand, Spend C1, A1, B1, 10 C1, A1, B2, 5 C1, A2, B3, 0 C1, A2, B4, 20 C2, A1, B1, 8 C2, A1, B5, 7 C2, …
user1330974
  • 2,500
  • 5
  • 32
  • 60
6
votes
2 answers

DAX Service recall rate measure

I'm struggling to write/calculate this measure in DAX. The definition of recall rate is count of repeat service bookings (count of distinct booking number, should be distinct anyway but just in case) for a customer, asset combination within a week…
jhowe
  • 10,198
  • 19
  • 48
  • 66
6
votes
1 answer

How to store credentials in Power BI DataConnector?

I'm building a custom Power BI DataConnector which uses OAuth. I'm following the github example. But this stores client credentials (required for the 'code flow' in OAuth) as plain text files. Is there a secure alternative to this ?
Neeraj
  • 2,376
  • 2
  • 24
  • 41
6
votes
1 answer

Creating New Columns in Power BI with a Python Script

I am trying to run a python script so that I can create a household count based on the residential address column and residential city column. Both columns just contain strings. The script that I have tried can be seen below: dataset['id']…
Data Science Acolyte
  • 195
  • 2
  • 15
6
votes
3 answers

How to JOIN summarized data from two queries into new table in DAX Power BI

I have 2 queries: Premium: and Losses: How can I simply summarize data from Premium query and LEFT JOIN it to summarized data in Losses query using DAX? In SQL it would be like that: declare @PremiumTable table (PolicyNumber varchar(50), Premium…
Serdia
  • 4,242
  • 22
  • 86
  • 159
5
votes
2 answers

How to edit an already created Python Script in PowerBI?

In my Power BI dashboard, I created a Python Script that accesses an API and generates a Pandas data frame. It works fine, but how can I edit the Python code? I thought it would be something simple, but I can't really find how to find it in the…
neves
  • 33,186
  • 27
  • 159
  • 192
1
2 3
…
99 100