20,652 questions
0
votes
0
answers
32
views
Custom last 4 periods DAX calculation issue
I'm trying to create a DAX measure in Power BI that calculates the average total number of issues per category across the last 4 custom periods (Versions) which happen irregularly.
I managed to ...
1
vote
0
answers
83
views
How to add labels to TopoJSON file which will display in custom shape map in Power BI?
I have a custom shape map in Power BI which I generate using a TopoJSON file. Below is a snippet of the code and also what the resulting shape map looks like. As can be seen, the map is not ...
0
votes
0
answers
88
views
Entra external users access to Power Bi 'analyze in excel'
I am considering a scenario where an organisation has the following:
Organisational Entra Id tenant. This includes their own users and is associated with PowerBi/fabric licensing (Premium amd pro)
...
2
votes
1
answer
107
views
Publish to web button does not appear in Power BI Service
I'm trying to publish a Power BI report to the web, but the "Publish to web" option doesn't appear in the menu.
Here's what I did:
I followed this tutorial to create a professional email ...
0
votes
1
answer
55
views
Dax Measure for count of students with all subjects pass. Even 1 subject Failed that Student considered as failed
Problem Statement:
I need a DAX measure to count the number of students who have passed all subjects within a selected date range.
A student should only be counted as "passed" if none of ...
2
votes
1
answer
41
views
Power Bi simlation for different scenarios
I am trying to build a graph which should be shown based on the condition selected. The data used is below.
year
value
filter_scenario
condition
2021
-11000000
NULL
2022
-32000000
NULL
2023
-40000000
...
0
votes
1
answer
205
views
Microsoft.AnalysisServices.Tabular Server.Connect() fails with valid token
I'm successfully connecting to a Power BI Service instance to run commands from C# code using AdomdConnection and have problems connecting to the same Power BI Service instance with Microsoft....
1
vote
1
answer
50
views
Determining Quarter / FY dates on a chart
I am working in Power BI and ran into an issue. What I have done so far is track GWD (Get Well Dates) for all my programs, dating back to 2023. So each program has a GWD of something like "...
1
vote
0
answers
41
views
Columns missing in Power BI
i have a power bi report that sits on the web version. I had to add two additional columns to the dataset. it links to a View in a SQL DB, so i updated that and its all correct on that end, refreshed ...
0
votes
1
answer
841
views
Power BI REST API – Missing Application Permissions (Dataset.ReadWrite.All etc) for Service Principal
I'm building an automation pipeline to publish Power BI reports via REST API from AWS Lambda using a registered Azure app (service principal).
My Azure App is registered successfully, and I’ve ...
1
vote
2
answers
67
views
Selecting column based off of current month
I have an excel spreadsheet of values that gets imported into Power BI. The columns of the spreadsheet are based off the months of the year, and the rows then correlate to user values during that ...
1
vote
1
answer
108
views
DAX measure: if statement to return a variable as blank based on condition
I have a table like this:
My "Delta" column is a measure I created, looking like this:
Delta =
VAR delta = (DIVIDE(
SUM('Devices Data'[count]),
'Devices Data'[Count LY])
-1)
...
1
vote
0
answers
56
views
Error connecting to Power BI Service from C# to execute XMLA script
When I run this C# code from MS Visual Studio to connect with Power BI service I get Error: The connection either timed out or was lost. What could be wrong? I checked the XMLA endpoints in Power BI ...
1
vote
1
answer
203
views
Why does using a relative path with Web.Contents cause sharepoint authentication issues in Power BI
I'm experiencing an authentication issue when trying to load an Excel file from SharePoint using Power Query in Power BI Service. I'm using OAuth with an Organizational Account to authenticate against ...
2
votes
1
answer
58
views
Is it possible to automate color code for stacked column plot in Power BI and have correct label names at the same time?
I have a very simple fruit_sales dataset as shown:
Fruit
Sales
Apple
10
Banana
40
Guava
20
I imported this data from an Excel file in Power BI. And I plotted it as a stacked column chart as shown. I ...
1
vote
3
answers
82
views
How to pivot/unpivot data for a visual in Power BI without using Power Query [closed]
I have a visual that I need to display in a certain way, where I think Unpivot would be the solution in Power Query. However the data set its coming from is our 'main' data set and I can't pivot/...
1
vote
1
answer
19
views
Concatenate URL Power BI - Error update automatical
Good afternoon everyone!
I have a query in Power BI, where I have a column with "PedidoId".
I have a function that creates a URL using the "PedidoId" column.
When this function is ...
1
vote
1
answer
61
views
DAX Query/Expression syntax question ":="
In many articles and in the DAX formatter, I see examples of definitions of DAX measures using the syntax of <keyword> := <expression>
I don't see this in any of the syntax documents, and :...
2
votes
1
answer
53
views
How can we simplify navigation and filtering in Power BI reports?
I am facing some difficulties in navigation and accessibility challenges within the PowerBI reports.
Problem:
Users have to go through multiple repetitive steps (e.g., selecting year, centre, team) ...
1
vote
1
answer
79
views
Data Flow Gen1 with Dynamic Data Source/Pagination
I have an API I want to call that uses pagination. I followed this blog: How to do pagination in Power Query, and got it working on Power BI desktop to get all the data with multiple calls and paging.
...
1
vote
1
answer
65
views
How can I include Department data from Xero's P&L Report in my Python API for Power BI?
I’ve successfully created a working connection from Xero to Power BI using Python to pull the Profit & Loss (P&L) report. Now, I've been asked to include department-level (tracking category) ...
1
vote
0
answers
66
views
How to set PowerBI small multiples barchart as different colors?
I'd like to make each brand for wave 2025 different color in powerbi small multiple barchart while wave 2023 bars should remain grey.
See below image - on Y axis there are particular brands, green bar ...
1
vote
1
answer
38
views
PowerBi data refresh from the source using a set value
I need that user could specify a specific date and the report would refresh from data source to show it. It could be chosen from a calendar, date picker or simply by writing down a date in the field ...
2
votes
0
answers
19
views
Power BI Many to Many relationship with vessels issue
I have a table which has VesselPositions for every insured ship. Everyday new data is added for the vessel.
In that Table I have a column named: IMO, Longitutude, Latitude, VesselPositionDate.
I also ...
1
vote
1
answer
127
views
How to dynamically provide colour hex codes (from a dataset) to Deneb (Power BI) Visualizations Using Vega/Vega-Lite?
For reference, we have been using the following template as a starting point: https://github.com/PBI-David/Deneb-Showcase/tree/main/Gantt%20Chart
I have these rows of data within my visualization that ...