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.
powerbi
20,483
questions
1
vote
0
answers
8
views
How to add expression value into datatable column in power bi dax
I am trying to create a table from dax function
Datatable,
I know I can create static table from datatable, but I want to add sum of sales into column of datatable function.
I'm trying to do like ...
0
votes
0
answers
14
views
Not able to connect Power BI with Dataverse
While connecting the Dataverse table with Power BI I get the below error-
DataSource.Error: Microsoft SQL: A connection was successfully established with the server, but then an error occurred during ...
0
votes
0
answers
9
views
Call Power Automate HTTP Request Trigger in Power BI for data source
In Power Automate I have a HTTP Request Trigger automation set up that generates some data and returns the JSON.
When this Power Automate flow is set to 'Anyone' for "Who Can Trigger The Flow&...
0
votes
0
answers
13
views
Row Totals not Populating in PowerBI chart
I am building a report on PowerBI Desktop.
I have a measure that is producing column totals but is not producing row totals.
Pipeline Target =
SWITCH (
TRUE (),
ISINSCOPE ( '...
1
vote
0
answers
16
views
POWER BI What is causing the circular dependency?
I am trying to create a new table called 'daily_rainfall' in Power BI with 5 columns: city, total_rainfall_3months_ago, total_rainfall_2months_ago, total_rainfall_last_month, total_rainfall_this_month....
1
vote
3
answers
42
views
Converting char to date and pulling past two years data
I need to pull data from tables with millions of rows and limit it to just the past two years. I am working on developing a SQL statement to enter into Power BI to limit what it pulls. Obviously I am ...
0
votes
0
answers
17
views
Area with field [Dates], type Temporal on X & Y axis
According to Vegalite AREA, Area works for X as temporal or ordinal field and Y as quantitative only. I have large dataset that consists of mainly 3 columns, Milestone ID, update Date and Targets (...
0
votes
0
answers
10
views
401 (Unauthorized) Request Id when calling Get-DataGatewayCluster with a service principal
Currently trying to use a service principal in order to check power BI connection status
Connect-DataGatewayServiceAccount -ApplicationId $xx -ClientSecret $xx -Tenant "xx"
$scopeLevel = &...
0
votes
0
answers
17
views
Any way to display 50,000 characters or more in Power BI Report Desktop
I have a table with HTML content that can go as high as 500K characters - this is HTML markup plus text. Any way to display that in Power BI Desktop? Shielded HTML and HTML5 Content Plugins do not ...
0
votes
0
answers
15
views
Power BI - Using Summarize and Maxx, then remove filter
I'm working on a visual which is a number of guages, each related to a particular location within the organisation. I'm trying to create a measure which will give me the same max value across all ...
0
votes
1
answer
22
views
I want to return the max value of a row and then return the header in Power Query
I want to be able to return the maximum date of a row, but I want to return the heading of the column rather than the actual date. But, I want it to write the heading instead of the date. For example,...
0
votes
1
answer
15
views
Writing back in Database using Power Apps without giving database access?
I have created a form to write back into the a Power BI database table using Power Apps but I have more than 200 users who are going to use it so I don't want to give database access or Power BI ...
0
votes
0
answers
18
views
How to extract the column from a Power BI Hierarchical filter?
When asking what filters are aplied to your embedded report you can ask report.getFilters().
But when the filter that is applied is an hierarchical filter you wilt get the target with the interface:
$...
2
votes
1
answer
25
views
Need help in filtering using measure in power bi
I have 2 measures in my power bi report which show cumulative trend based on two date columns namely created date and closed date. The 2 trend lines show total number of bugs created vs total number ...
0
votes
1
answer
8
views
Which date shall I use for incremental refresh in Power BI: Invoice Date or Last Modified Date?
I would like to know which date shall I use to perform incremental refresh on my sales invoice table in power bi?
Invoice Date: Date when an order get invoiced. this date can be in the future as use a ...