Power BI Desktop is the desktop application for Power BI, a free, self-service analytics tool.
Questions tagged [powerbi-desktop]
3559 questions
0
votes
1 answer
Extract latest value from each row in a column
I am trying to create a DAX calculated column that only shows the new value added in the row. My data is collected in where for each new entry a new row is created where an entry is appended either at the start of the string or at the end. This…

Steve_Greenwood
- 546
- 8
- 20
0
votes
0 answers
dynamic kusto query in powerbi - getting error saying that query isn't supported in DirectQuery
I'm using powerbi and want to let the user select a parameter in the dashboard (date in my case) and pass the value to a kusto query I'm running.
I read a lot about it, to name a…

Ofek Agmon
- 5,040
- 14
- 57
- 101
0
votes
0 answers
Views or Tables in Power BI
This is a fundamental architecture question for Power BI. I have developed star schemas for years and now my job is wanting me to go into the UI world as well. I want to start off correctly, so I was wondering if I should create views and import…

SurfingViolinist
- 51
- 5
0
votes
1 answer
Conditional Formatting when condition is met on two columns
Within Power BI I have two columns, one that contains Yes or No and the other a Date Column.
What I am looking for is for when the answer in Column 1 is No and is older than two days then highlight as Red (similar to what can be done in excel)
I…

Sc0719
- 73
- 10
0
votes
1 answer
Power BI is missing Google Sheet connector
Power BI provides the Google Sheet connector which is no more in Beta version and should be available on any lates Power BI version.
On my laptop I'm running the version 2.114.664.0 64-bit (February 2023) and I have updated Power BI also on the same…

Francesco Mantovani
- 10,216
- 13
- 73
- 113
0
votes
1 answer
How to exclude specific columns in a matrix visual?
I'm trying to build a matrix visual which shows the Product code (sku) and the quantity sold in the last 30 days, 60 days and 90 days (Aantal verkocht in laatste xx dagen). Now I want to also add the supplier(leverancier) to the corresponding…

MrRose
- 1
- 1
0
votes
1 answer
How to set location based in country name when latitude and longitude is 0 (null)
For example, I have some fields with 0 for latitude and longitude.
This happen because in the database, those columns are null (longitude and latitude is unknown).
How can I simply set the country name for latitude and longitude 0? (in this case,…

Potter
- 434
- 8
- 21
0
votes
1 answer
Can slicers be used a stored procedure parameter in power bi to filter underlying data
Can we pass the slicer values as stored procedure paramter when connecting to a sql for developing a PowerBI report so that once its deployed in powerbi service the end user can use slicer to filter the report
I tried to use a stored procedure …
0
votes
0 answers
Power BI Desktop: Sizing Matrix Visual to A4 Page
I have created a matrix visual in Power BI Desktop and I need to fit it to an A4 PDF Page (landscape format). Unfortunately the matrix is quite big, so I have to scroll vertically and horizontally to view the whole matrix visual and when I export to…

AzUser1
- 183
- 1
- 14
0
votes
0 answers
How to enter parameters into power BI template pbit file and then letting those load before next dynamic parameter is selected
I have four parameters that are required in a pbit powerBI template for the report to load. However, the fourth parameter(org_ids) is a dynamic dropdown parameter that needs the first three parameters to refresh and get the list of values that will…
0
votes
0 answers
Can a guest user refresh a dataset in Power BI?
Can an invited guest user(external user) refresh a dataset in Power BI ?
I am facing an issue with Scheduled refresh for Scorecard/Goal Dataset for an Invited/External user. It is always throwing an error.
Can anyone please help ?
I went through the…

Sreejith Sreekumar
- 13
- 3
0
votes
0 answers
Is there a way to show map from Python in powerbi?
I am trying to show a map of rail lines on powerbi. The map html was generated from the python library folium. Is there a way to show it on powerbi?

helpme
- 163
- 3
- 9
0
votes
1 answer
How do I correctly use report-level filters in Power BI?
I am fairly new to Power BI and working on my first project. I currently have two separate sql views setup and connected to my project as well as a simple visual for each one. They both share a common field that I want to filter on, call it…

Migals
- 1
- 2
0
votes
0 answers
Measure Table preventing refresh. Stuck on 'Creating Connection in model'
I'm trying to refresh locally on Power BI Desktop. I have a few measure folders. All of the data tables has been refreshed. However, the measure tables (a table with nothing but dax measures in it), are preventing the refresh from completing. They…

zach
- 759
- 1
- 9
- 21
0
votes
0 answers
How to Save user slicer selection on powerBI
I need one help, I have one powerBi report which contains 5 slicers on this. so I want when user select any slier that time this selection need to save and when next time user open this report, earlier selected slicer need to set and open the…

NitinK
- 1