Stack Overflow
Stack Overflow

Questions tagged [powerbi-desktop]

Power BI Desktop is the desktop application for Power BI, a free, self-service analytics tool.

3559 questions
5
votes
3 answers

Is there a way to add line breaks in a string of text in M (Power BI)?

I concatenated four columns using this code (to prevent null values to be linked together) in Power Query (Power BI Desktop): = Text.Combine(List.Select( { [Col1], [Col2], [Col3], [Col4] }, each _<> "" and _ <> null),"; ")) I was wondering if…
DatAlessia
  • 73
  • 1
  • 1
  • 7
5
votes
3 answers

DAX Get the last date with positive sales regardless the Date row context

How to get the latest date with sales Amount for all the dates between min and max date with sales Amount. In the table, some Dates may have null Amount. Here is example with expected results: Here is what I have tried. These are all DAX measures.…
Przemyslaw Remin
  • 6,276
  • 25
  • 113
  • 191
5
votes
2 answers

All rows and total of the rows showing same values in power BI

I am trying to show "Some Column Name" against "Total Amount" in Power BI. I am expecting the following results: But instead it's showing me the following results: The current data type is "fixed decimal number" I tried changing it to "Decimal…
Paras
  • 81
  • 1
  • 1
  • 7
5
votes
3 answers

Convert json List Record to Table value in PowerBI

I'm totally new to Power BI so I'm tried different approached to convert my JSON file to a table but unsuccessful so far. { "Family": [ { "Father": "F1", "Age": 50, "Mother": "M1", "MAge":…
Jayendran
  • 9,638
  • 8
  • 60
  • 103
5
votes
1 answer

How to refresh report that uses custom functions on Power BI Service?

I know this issue has been posted many times before, but I was not able to get a solid/working solution. I am trying to figure out a workaround for refreshing dataset with Custom functions over Power BI service. My query looks like the following:…
Pratik Bhavsar
  • 808
  • 8
  • 32
5
votes
1 answer

How to set OR logic between two slicers for the attributes from same dataset?

I'm trying to set OR logic between the two slicer filters. The two slicers are from same dataset. Below are more details: My source table: Visual with slicers: My goal is, if I select any value from slicer 1 and also from slicer 2, my visual…
user3588007
  • 227
  • 3
  • 15
4
votes
0 answers

Unable to send a POST Request using Power Query in Power BI Service

I need to send a POST request to generate an access token in Power Query. In Power BI Desktop, a POST request is sent, and it works as expected. However, when I try to refresh after publishing the report to Power BI Service, a GET request is sent…
Kaveesha Silva
  • 111
  • 1
  • 5
4
votes
1 answer

Summing up the Created Measure on a Card Visual

This is my data, App_Num Processed_Date State A1 10 Feb 2021 Open A1 10 Feb 2021 Closed A1 22 Feb 2021 Closed A2 22 Feb 2021 Closed A2 20 Feb 2021 Closed A2 21 Feb 2021 Open A3 20 Feb 2021 …
Student of the Digital World
  • 2,971
  • 16
  • 62
  • 116
4
votes
1 answer

Refresh report that uses custom functions on Power BI Service?

I am trying to figure out a workaround for refreshing dataset with Custom functions over Power BI service. My query looks like the following: Data source for _op_kiekis let Source = Loginai_File, #"Invoked Custom Function" =…
Dmitrij Holkin
  • 1,995
  • 3
  • 39
  • 86
4
votes
5 answers

Sort column circular dependency in Power BI

I have to sort month name from January to December in Power BI Desktop. Power BI sorts the column according to the alphabetical order. Here is my dataset: When I am using sort by column by month number, I am getting an error of circular…
Aditya Ranjan
  • 135
  • 1
  • 2
  • 11
4
votes
1 answer

How to extract Month and Year from column in PowerBI powerquery

I have a column (monthyear) in the image below. I want to extract the Month and year from the column to put it in the new column. Note: In my dataset this information goes for every day of the year So the new column would look…
lydol
  • 111
  • 1
  • 3
  • 11
4
votes
1 answer

PowerBI - Gateway error with ODBC (Hive) Data source

We have PowerBI report with data source as ODBC (Hive -- connected through MS Hive ODBC driver). Now, we need to configure gateway so that data can be refreshed periodically. However, while adding an ODBC data source in Gateway we are getting…
Ruchita P
  • 359
  • 1
  • 4
  • 17
4
votes
1 answer

Unable to refresh data in power Bi service while connecting to sharepoint list and document folder of all listed sites

Hi I am currently trying to develop a reporting tool. There is a SharePoint online list which has various SharePoint sites in that list. My objective is to retrieve all SharePoint sites from that list and to connect to the documents folder of all…
Faizan
  • 105
  • 15
4
votes
3 answers

How to load large images in PowerBi

I want to load pictures in PowerBi, problem is that pictures are a bit bigger than 32kb so it's showing just a part of the picture. Is there some quick way to go around PowerBi limitation and display entire picture? I fetched pictures from…
Pesa
  • 241
  • 1
  • 3
  • 8
4
votes
1 answer

Any reason not to use Bidirectional Cross Filter Direction in Power BI?

See Screenshot. We are looking at the relationship between two tables, and there is a setting that effects how filtration works. REF: https://community.powerbi.com/t5/Desktop/cross-filtering/td-p/140592 For some reason, Both is not the default. Any…
HillOfBeans
  • 99
  • 10
1
2
3
…
99 100