20,652 questions
Advice
0
votes
1
replies
54
views
How can I truncate the 15 lkh data set which is unfiltered to filter then upload on MySQL
I want that the data will arrange in a proper manner firstly the data have clear and remove duplicate and missing values then I write a my code in pandas to upload and process the same thing again ...
- 3,278
0
votes
0
answers
19
views
How to compare substring to userprinciplename substring?
I'm trying to create RLS that will compare user1 with user1 because the domains are different. So if email is [email protected] and userprinciplename() [email protected], that should match.Some of the ...
- 14.5k
0
votes
0
answers
44
views
ERROR WHEN TRYIN TO UPDATE A DASHBOARD POWER BI (Npgsql) - Esp/Eng
I trying to update a dashboard in power BI, but I get this error
Tipo actividad new (this is the name of a measure/table) Se produjo un
error al leer datos desde el proveedor:
'Npgsql.Tls....
- 28.1k
0
votes
0
answers
76
views
Power BI Security Manage Roles Issue
DAX expression used to be:
[Email] = USERPRINCIPALNAME() || [Manageremail] = USERPRINCIPALNAME()
Due to the company's changed name, @xy.com has changed to @zw.com.
People still log in with the xy.com, ...
- 671k
1
vote
1
answer
9k
views
How to create a new table in Power BI with only distinct values from parent table after filters applied
I have a table with two columns which contains date and sales order. I want to create an another table using DAX which contains distinct sales orders getting data from sales order column for making ...
CommunityBot
- 1
0
votes
1
answer
24
views
Issue with Python Visuals in Power BI Embedded (.NET Core)
I am facing an issue with Power BI Embedded reports in a .NET Core application. The report contains Python visuals, which work correctly in Power BI Desktop and Service, but they do not render when ...
- 32
0
votes
0
answers
20
views
How to make quick measure of each data reference back to the same category of the original data?
pbix file:
https://x0.at/dnPB.pbix
So I have a line and clustered column chart. On the line y-axis, by default my original data (Median Gross Monthly Salary under the table Median Salary of FTP) will ...
- 1
1
vote
1
answer
67
views
Remove Cast on int fields on directQuery to 2 billion row fact when computing averages
Using Power BI directQuery to databricks SQL warehouse, I see the queries getting generated to compute an average have
SELECT
SUM(CAST(int_field AS DOUBLE)), COUNT(int_field)
FROM
fact
...
- 2,315
0
votes
1
answer
46
views
How to calculate overlapping 4-month rolling averages with a month slicer?
I have an attendance summary table with the following columns:
EmployeeID
Date
WorkHours
I need to create a visual (or table widget) in Power BI that shows employees who worked more than 48 hours ...
- 14.5k
1
vote
0
answers
59
views
An error happened while reading data from the provider: 'Object reference not set to an instance of an object.'
I am able to connect to OracleDB from Power BI desktop. after publishing the dashboard and having the on premises gateway setup, it was working fine. I installed on premises gateway on another system ...
- 1
Advice
0
votes
0
replies
37
views
How to do same layout align in power bi service for paginated report
My paginated report is displaying well align on web layout view .
But if I switch to print layout view , the page display is misalign so how can I have same align for both layout view .
I am using ...
- 1
2
votes
1
answer
8k
views
How to have actual calendar in a slicer in power bi?
When our power bi report runs it runs it for current date which is created by Relative slicer. Our user would also like to have some options to select different date ranges using an actual calendar ...
CommunityBot
- 1
1
vote
2
answers
95
views
Adjust paginated api call to enable refresh in PowerBI Service (M)
I'm reworking a dashboard that is fine on PBI desktop but can't refresh on PBi service because it includes dynamic data sources (meta api). I'm trying to adjust the original code following Chris Webb'...
1
vote
1
answer
48
views
Creating a Basket Analysis that Customers who buy X also LATER bought Y
I am trying to make a visual in Power BI that shows me what people order second, if they order x product first. Very similar to a basket analysis but I don't want to know what was in the same cart as ...
- 2,355
0
votes
1
answer
10k
views
How to do countifs in powerbi
I want to do countif in PowerBI (Example: count of total item with condition #1: having transaction of 2 or more, condition #2: year)
I have sample data comprised of PO (transaction) #, item #, date (...
CommunityBot
- 1
-1
votes
0
answers
19
views
Matrix PBI presentation with monthly YTD vs YTD-1
In PBI, I need to create a matrix that, based on the selected month:
Display the data for the current month and the data for previous months of the same year.
Display the data for the months of the ...
- 19
0
votes
0
answers
25
views
How to define visual-level formatting (color, size, etc.) in Power BI PBIP visual.json vs baseTheme?
I’m currently working on a project where I take an image of a Power BI dashboard and automatically generate a Power BI PBIP project that replicates the exact layout and visual design of the dashboard ...
Advice
1
vote
1
replies
65
views
Modeling Recoverable Hours and Overtime in dbt/Power BI
I’m working on a reporting model that tracks recoverable hours and overtime for staff under a specific contractual agreement. I’d appreciate any advice on how you would approach modeling and ...
- 21
0
votes
0
answers
39
views
Query loading a lot of data from a small file [closed]
I have a power bi report with four connections to four excel files.
One of the files is around 1500 rows and 800 KB of memory.
The query i am interested in appends three queries, each one of those ...
- 31.4k
0
votes
1
answer
3k
views
Microsoft Advanced Hunting Query API works for some tables but not others in power BI
I am using the following API call in Power BI to access Advanced Hunting data from 365.
https://api.securitycenter.windows.com/api/advancedqueries
Using this API works with some tables but not others ...
2
votes
2
answers
103
views
Rank (TopN) within Group
I have a table of data, and I want to sort by STATE, and then for each STATE, return the TopN (say Top 3 for example) COMPANY per state.
Using the generic visual filter for Top 3 Company, by Value, ...
- 124
0
votes
1
answer
61
views
Fabric Dataflow Gen2 not showing all columns of an excel sheet because of the dimension property in the xml
I am working on a new Dataflow Gen 2 to import Excel files from SharePoint.
The problem I am running into is our vendor, who is supplying the files, is not properly setting the worksheet dimension ...
- 1,011
-1
votes
2
answers
189
views
How to automaticaly switch between dashboards?
I would like to switch between dashboard in Power BI.
I prefer power bi desktop app, in power automate is it possible create an automatic workflow?
If power automate doesn't work there is another ...
- 15.2k
0
votes
1
answer
39
views
How to show latest date first (descending order) in Power BI Matrix column headers?
I am building a Power BI dashboard where my Matrix visual has employees in rows and dates in the column headers.
The date field I am using is:
Hours_Provided_by_Manager_ScriptOutput_AMOps[...
0
votes
0
answers
30
views
Writing a calculation group designed to make a slicer inactive
I have a slicer on PeriodSlicer[Period] for All Time, Full Year, Year to Date and Selected Dates.
Selected Dates should apply whatever dates are selected in the Calendar slicer, while the others ...
- 264