powerbi-desktop Questions
8
Solved
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-sa...
Advocacy asked 23/8, 2018 at 18:5
3
Solved
I am trying to show "Some Column Name" against "Total Amount" in Power BI.
I am expecting the following results:
But instead it's showing me the following results:
The current data type is "...
Yettie asked 20/1, 2020 at 21:12
3
Solved
I concatenated four columns using this code (to prevent null values to be linked together) in Power Query (Power BI Desktop):
= Text.Combine(List.Select(
{ [Col1], [Col2], [Col3], [Col4]
}, each _...
Laise asked 18/9, 2020 at 16:13
4
Solved
When I press refresh button in Power BI (version 2.112.1161.0) I have this error
message
! Table1
A cyclic reference was encountered during evaluation.
! Table2
Loading blocked by failures with oth...
Mediatize asked 11/1, 2023 at 6:29
4
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.
Spontaneous asked 24/1, 2019 at 19:42
3
Solved
Following are 2 measures:
SUMX ( ALL ( SALES ) , SALES[AMT] )
CALCULATE ( SUMX ( SALES, SALES[AMT] ), ALL (SALES) )
Similarly for the following 2 measures:
SUMX ( FILTER ( SALES, SALES[QTY]>1 ...
Hayton asked 15/1, 2021 at 20:5
1
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...
Brendin asked 12/9, 2021 at 2:14
3
Solved
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 onlin...
Hialeah asked 7/3, 2019 at 20:18
3
Solved
I'm totally new to Power BI so I'm tried different approached to convert my JSON file to a table but unsuccessful so far.
{
"Family": [
{
"Father": "F1",
"Age": 50,
"Mother": "M1",
"MAge": 4...
Berserk asked 3/3, 2019 at 7:30
1
Solved
The following error appears whenever I try to connect to the data sources and authenticate using oAuth login screen on iExplorer web browser.
Hereinto asked 21/6, 2022 at 13:50
3
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:
decl...
Mahoney asked 19/7, 2018 at 23:5
1
Solved
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...
Ulna asked 10/8, 2021 at 18:18
1
Solved
When changing the slicer from "All" to a specific selection, it changes both tables that are on the same page. I would like it to only filter through a specific table.
Bullwhip asked 4/8, 2021 at 19:43
1
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 popu...
Tham asked 21/6, 2018 at 12:18
1
Need to plot chart for Shift-wise state change data. I plot the stack bar chart using python Jupyter.
Sample dataset and output from jupyter is shown below.
Output:
But when I'm going to plot thi...
Marceau asked 29/3, 2021 at 9:46
2
Solved
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 cas...
Wheaten asked 5/3, 2021 at 10:28
3
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 non...
Antipasto asked 21/5, 2018 at 3:19
1
Solved
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 t...
Anosmia asked 9/4, 2020 at 14:1
3
Solved
How to get the latest date with sales Amount for all the dates between min and max date with sales Amount. In the table, some Dates may have null Amount. Here is example with expected results:
H...
Hoopla asked 8/4, 2020 at 10:42
6
Solved
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]),
F...
Jemina asked 29/1, 2020 at 10:36
1
Solved
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...
Kaceykachina asked 3/9, 2019 at 23:34
1
Solved
I have embedded powerbi report which was working fine until I changed my database.
I observed datasets.IsEffectiveIdentityRequired (in below code) was false earlier, now as it is true, I'm gettin...
Circumferential asked 9/5, 2019 at 0:19
1
Solved
I know this issue has been posted many times before, but I was not able to get a solid/working solution.
I am trying to figure out a workaround for refreshing dataset with Custom functions over P...
Orbit asked 1/12, 2018 at 6:56
1
Solved
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, A2, B6, 4
C2, A2, B3, 3
C2, A2, B7, 2
C2, A3,...
Peptone asked 18/5, 2018 at 15:5
1
© 2022 - 2024 — McMap. All rights reserved.