Questions tagged [microsoft-powerbi]
Self service data integration and visualisation service provided by Microsoft. It can integrate data from Excel and other Office programs, and all major databases and analytics tools and web services
112
questions
0
votes
0
answers
5
views
Power Bi - how to export to excel by another user
I am having problem with exporting a table from Power BI. I have a simple report - three tabs, in each a table from the same source, very similiar to each other. When the report is published and ...
- 1
0
votes
0
answers
29
views
Create a new column in Power BI from values from a second table
I need to add a new column in TableA with a value of a column in TableB. One slight issue is that the return value in TableB will be a different column then what was being referenced.
TableA = column ...
1
vote
0
answers
14
views
Group by - Sign vs Group by - Parity
This may sound like a silly question but I searched MS KB and have been searching for 2 days now in google.
I want to understand the difference between Group by - Sign and Group by - Parity. I believe ...
- 435
0
votes
0
answers
18
views
How to use slicers to choose columns in a table?
I have a table with columns Product, Units, Price, Sales (Units*Price).
I want a slicer to switch between Units, Price, Sales, and display these in various visuals interchangeably.
So the slicer will ...
- 131
0
votes
0
answers
14
views
How do you directly and automatically import data from a public Tableau dashboard to a PowerBI dashboard
As the title says, I need to scrape data from a public Tableau dashboard and import it directly to a PowerBI dashboard. No middle-men should be involved.
- 113
1
vote
0
answers
24
views
Using a seperate date for FTD outside of datamodel in excel report
I have a data model named Sanction in the following format.
Sl. Date Loc Product Num Amount
1 01-06-2023 Loc1 Pro1 2 5
2 02-06-2023 Loc2 Pro2 5 6
I am ...
- 119
0
votes
0
answers
15
views
Is it possible to activate Power BI in On Premise Data Gateway?
I have installed an On-premises data gateway. I use it for powerautomate-tasks.
Now I want to access with Power BI to a database in our company.
But the On-premises data gateway says "Power BI - ...
- 199
1
vote
0
answers
306
views
Connect to MariaDb datasource in Power Bi
I have successfully connected to my MariaDb/MySQL datasource in Power Bi Desktop using the Oracle MariaDB ODBC connector.
I use Import mode to be able to model the imported data in Power Bi. So far, ...
- 428
0
votes
1
answer
38
views
Does Power BI have an equivalent of Metabase's X Ray feature (automatic insights and analysis)?
One of the best parts of Metabase are X rays https://www.metabase.com/docs/latest/exploration-and-organization/x-rays
Does Power BI have an equivalent? Eg give a tabular csv data source, and have ...
- 1,101
0
votes
1
answer
160
views
Power Query: How to get conditional running total?
A header
Another header
RUNNING TOTAL
5
NULL
0
5
1234
5
5
NULL
5
5
NULL
5
5
5678
10
5
9012
15
Let's say I have access to the first two columns in Power Query. How would I go about getting the ...
- 101
0
votes
1
answer
1k
views
Parse a nested XML file once in Power Query
I am struggling with the following problem: I have an XML file that contains several nests. There are several nested XML files. The goal is: To read in all XML files in Power BI, i.e. Power Query, and ...
- 1
0
votes
0
answers
61
views
PowerBI IIS Reverse Proxy asks for credential but does not login
I have a PowerBI installed in an IIS and works with all of these URLs:
localhost:8080/reports
HOSTNAME:8080/reports
10.1.10.10:8080/reports
And I am trying to do this with Reverse Proxy:
localhost/...
- 393
0
votes
1
answer
299
views
Calculate % of total during drill-down
I have a Power BI Matrix visual as shown below.
At the moment it is showing the ISO Week Number. You can drill down to see the week ending date (not really a drill-down as it's the same level), then ...
0
votes
0
answers
27
views
How to check data by column, with date filter
How do I find in my table new values added in a column by date?
I have a table, where I have a column with the contract numbers of my clients, but I want to make a comparison, if on my previous date I ...
- 3
0
votes
1
answer
114
views
How to do VLOOKUP in my PowerBI table
Gentlemen, in my table I have a column CC (Number of Contracts), and another column "DATE" with the dates of each contract, but I want to make a comparison (Something like a PROCV in Excel),...
- 3
0
votes
2
answers
46
views
Get total count of distance with overlapping ranges excel
I am trying to find a way to calculate the total distance from overlapping ranges. I have attached an image to help explain this. Essentially I want to know how much of my given range has an object on ...
- 3
0
votes
1
answer
90
views
How to return only the value of the last month
I have a dashboard where in my data I have a column called "Data Base", because it is a column where it has dates of all the days that I update, and in my dashboard it shows by the months, ...
- 11
1
vote
1
answer
13k
views
How to do SUMIFs in Power BI (CALCULATE/SUM)
I have a table in excel that uses SOMASES, the following formula:
=SUMIF(Table[[#All];[Book Balance Value]];Table[[#All];[Product code]];[@Product])
It sums all the values of Book Balance Value, ...
- 11
0
votes
1
answer
1k
views
Highlight MAX and MIN values in Power BI table visual using DAX
I have a table similar to the below in Power BI.
DAX to create table:
Sample Table = {("A", 2, 3), ("B", 3, 1), ("C", 8, 12), ("D", 4, 15), ("E", , 3)...
0
votes
0
answers
956
views
PowerBI - Need measures based on two separate tables to sum correctly in column total
I have a measure that calculates percentage changes between two separate tables.
This measure is used as a rough way of predicting the next quarter's totals based on new weekly data at the time.
I ...
- 1,146
0
votes
0
answers
58
views
How would you create a tree from a list and display it in Excel or PowerBI?
I have a list that I don't maintain, and I want to reorganize it and display it in some visual fashion, like a tree. (In my mind, I'm imagining the old tree function in DOS.)
Imagine a family tree ...
- 1
0
votes
2
answers
499
views
How to add Epi Week aka MMWR Week column in Power BI
My dataset has a date column. I need to assign the correct Epi Week/MMWR Week to each row. I can't do it by hand because the dataset spans five years and has over 18,000 rows.
The Power Query function ...
- 289
1
vote
1
answer
2k
views
Remove trend line from a Power BI line chart with continuous x-axis
I need to remove the trend line from my Power BI line chart. The trend line was automatically generated and is not meaningful in my data analysis. I can't find an option to remove it. The trend line ...
- 289
0
votes
1
answer
1k
views
List.Sum in Power Query is not ignoring null values
I added a column with this code:
= Table.AddColumn(#"Changed Type", "Total Quantity", each List.Sum(
{[species_males]+[#"species_females-mixed"]
}))
List.Sum is ...
- 289
0
votes
1
answer
314
views
How to tell which users are running which reports?
I apologize if this isnt the right domain. I searched all the stack exchange communities.
I'm using Microsoft PowerBI and would like to know which of the reports created are being run and by which ...
- 281
0
votes
2
answers
2k
views
Power BI bookmark conflicts with slicers
I ran into a bookmark/slicer issue in Power BI. When I try to set a bookmark with more than one filtering setting, I have to update the bookmark every month.
My general bookmarks point to a certain ...
- 11
0
votes
0
answers
3k
views
Connecting Power Bi to protected Excel using a connection string
I am trying to connect Power Bi Desktop to a password protected Excel file. I have looked online for solutions and everything points to the same conclusion. Power Bi does not support connecting to ...
- 1
0
votes
2
answers
2k
views
Excel: Power Query - how to repeat block of code for each row in a table
I have JSON in format like this:
{
"data": [
{
"date": "2021-01-01",
"data": 10
},
{
"date": "2021-01-02",
...
- 845
0
votes
1
answer
25
views
powerbi parse sheets in excel file
I'm importing a list of excel files into PowerBI. So far, I've imported the folder, expanded the files to show the list of sheets, and expanded the sheets to show columns.
Here is my code so far
let
...
- 131
0
votes
1
answer
676
views
xlsb PowerBI error External table is not in the expected format
so I read that Excel binary format is faster and better, so I saved my table in this format. Unfortunately I found out that my other workbook which was importing one sheet from this now has problems ...
- 889
0
votes
1
answer
319
views
Power BI formulas not calculating properly
I have a visual that I want to calculate as a percentage above or below a target goal. Let's say I have a table head(5) that looks something like this:
id
Date
Inbound Requests
Outbound Responses
1
...
- 5
1
vote
1
answer
513
views
Power BI sort by column (Date) is producing different results
I have two graphs that are based off of the same dataset. I had an issue with sorting the graph chronologically, so I sorted by a YearMonNum column. The data looks something like this:
id
YearMonNum
...
- 11
0
votes
0
answers
1k
views
Power BI Desktop turns white when browsing a bit
I have a really tiny Power Bi application, 32bit, getting about 800 lines from a single table with about 200 columns.
The size of the app is less than 1 MB.
Whenever I browse for about 30 seconds I ...
- 101
1
vote
1
answer
2k
views
Sum of previous year Power BI
I'm working in Power BI with data in the following format:
Year Number
Week Number
Sales Value
1
1
20
1
1
15
2
5
32
...ect
...ect
...ect
I'm currently using the measure Total Sales = SUM(Table[...
- 15
0
votes
0
answers
27
views
Excel Power Pivot Sums are off
For work I am extracting data from a huge .csv file (1.754.488 rows), including revenue numbers for different customers at different months. When I load this .csv file into Power BI and create a ...
- 1
0
votes
1
answer
318
views
How to refresh an uploaded data source for a report created in Power BI web app?
I created a Power BI report using the Power BI website interface at app.powerbi.com. My data source is an Excel table that I uploaded to the web app. Now I need to update the source data. However, it ...
- 289
0
votes
1
answer
3k
views
Power Bi: formula similar to Excel's MAXIFS with multiple criteria
In Power Bi I have a similar Table and I'm trying to figure out a way to calculate in column "G" the maximum value (only for Gender F) for each Team and each Day.
In Excel I would use ...
- 139
0
votes
1
answer
94
views
PowerBI - How to See All Pages Being Linked to
I have a page called "Courses".
On this page, I select certain filters.
When I log into https://app.powerbi.com and select the filters, there is a Tab on the left that says "Courses&...
0
votes
1
answer
190
views
Power BI Check If Value Takes Place Before a Certain Time
I have data that looks like this:
Joined Time null null 10:01:00 AM 02:20:00 AM
I want to add a column that has the following logic:
If "Joined Time" < 09:00:00 AM then "PM"
if ...
0
votes
2
answers
171
views
How do I add a column to a Table in a row with data from another column?
I have a query that aggregates MySQL.Database output.
What I would like to do is update the Table in Data to contain the value of Schema for each row in the Table.
I think it would be something to do ...
- 1,553
1
vote
1
answer
4k
views
How can I use Excel to make a chart with two x-axis at different scales?
How can I use Excel to produce charts like the images below? Is it possible?
I want to have two different x-axis scales with major tick marks every 10 values. The only data I would want to display ...
- 373
0
votes
1
answer
1k
views
Why did On-premises Data Gateway sign-in fail?
When attempting to setup Microsoft's On-premises Data Gateway, after successful installation, the login repeatedly returns a sign-in failure.
Following the setup process, an email address to setup the ...
- 10.1k
0
votes
1
answer
134
views
Microsoft Power BI desktop — columns col1 and col2 (from excel) make a chart with col2 y axis vs col1 axis
Microsoft Power BI desktop -- after importing excel columns col1 and col2 make a chart with col2 (y-axis) vs col1 (x-axis). Very much like the title says, after importing a spreadsheet from excel, ...
- 233
0
votes
1
answer
147
views
Loop through visualization in power bi
So I want to have a visualization that is basically a table form, but with visualizations that loop for each customer, is there a control or visual that I can use to do this in powerbi? Please see the ...
- 205
1
vote
1
answer
4k
views
Power BI Report Server - change maximum size of uploaded file
Power BI Report Server allows uploading report files to the server up to 2GB in size.
The limit is set by default to 1GB see details from the documentation
You can upload files up to 2 GB in size, ...
- 1,702
0
votes
1
answer
3k
views
PowerBI - Getting a count per day from data containing date and time
I'm fairly new to PowerBI and am having difficulty with getting a count per day form data containing both date and time. I'm using Direct Query and currently have date_closed and Count of date_closed ...
- 174
0
votes
1
answer
4k
views
Refresh Power Query For Excel File in OneDrive
I have a Microsoft Form that saves to an Excel file in my OneDrive. I use Power Queries to manipulate the data. This works fine for when I need open the excel file on my computer and I can then ...
0
votes
1
answer
247
views
Designing a mass attendance system with Excel and PowerQuery
I am building an Excel spreadsheet for tracking a large number of personnel's daily attendance records. All data examples shown here are fictional, including the data structure. Only the gist of the ...
- 103
1
vote
2
answers
650
views
In powerBI, using a measure breaks the relationship between two tables. What am I doing wrong?
I am doing membership statistics for an organization. In our membership_subscriber table, we have the the dates when the membership begins and ends. There are multi year memberships. I need to show ...
- 11
3
votes
1
answer
20k
views
How to remove a data source from Power BI Desktop?
Edit: I found a solution--see my answer below.
The answers I've read are old and no longer work (possibly because Microsoft makes substantial changes to the UI on a regular basis).
I tried File -> ...
- 289