When filtering in large tables, after applying a second filter in de query editor I always get the following error: DataSource.Error: AnalysisServices: The expression contains a function that cannot operate on a set with more than 4,294,967,296 tuples. When applying only 1 filter, I don't get an error. ... View more

Is it possible to change the titles dynamically to show the filters selected and can it be independent for each chart? ... View more

I am connected to a SharePoint List from PowerBI. I then updated the list to rename a column from "Title" to " Project" and also added two new columns. I then removed the existing SP List connection and reconnected to recognize the new changes. Once completed, I am not seeing the changes that I made to the SP list. Just to see if PowerBi was caching anything on my machine, I installed PowerBI on another machine and perform the connection process again to the same SP list and I got the same results. It seems that the problem may lean towards Sharepoint, but I welcome all feedback to help me get past this most frustrating issue. Thanks, Ron ... View more

While it is possible to add new Measures in a non SSAS connection, it is not possible to do in a SSAS live connection. Please implement the new measure creation in SSAS ... View more

I am trying to create a measure in which i am trying to find the MAX date from a docdate column of a sql table i.e sales-transaction between 2 specific date ranges. Basically the table has sales transaction of all the distributors & their corresponding retailers. I need to find the distinct distributor & retailer codes based on the last transaction date or highest transaction date between specified dates. I tried creating measure but got lost while applying filters for date. Here is what i tried. Maxdocdate= calculate(max(docdate),docdate>=01-04-2016,docdate<=31-05-2016) can anybody enlighten me with some fruitful solution. ... View more

I would to create a calculated columns as difference between two columns, how can i make it? ... View more

I created a measure using the SumX and Filter functions, see example below. It works for the most part, except for strings with spaces in a certain table named SalesDetail. I figure it's a problem with the relations of the data tables however I've deleted all relations to the table I am trying to filter and it still won't sum. Examples that work: 1. A/V Sales = SUMX(FILTER(PriceLines, PriceLines[ProductSegment]="A/V"),SalesDetail[Sales]) 2. Controller and I/O Sales = SUMX(FILTER(PriceLines, PriceLines[ProductSegment]="Controllers & I/O"),SalesDetail[Sales]) 3. Drive sales = SUMX(FILTER(SalesDetail, SalesDetail[WE_Subsegment]="Drives"),SalesDetail[Sales]) Example that does not work: 1. Test Sales = SUMX(FILTER(SalesDetail, SalesDetail[WE_Subsegment]="Controllers & I/O"),SalesDetail[Sales]) note*: "Controllers & I/O" is a value under WE_Subsegment that is spelled correctly both in the table and in the formula. ... View more

When connecting to a SQL server DB using a sql user that is a member of the db_datareader role on the database, the table names are visible but when you preview the data, the power bi desktop client says that the tables are empty. When I connect to the database using SQL Enterprise Manager using the same user credentials, I can retrieve the data. ... View more

Please provide the ability to export reports/dashboards that are embedded into an application. ... View more

I'm publishing a dataset from Power BI desktop, getting a successful publish message, but the dataset and reports built off of it online are not actually updating. If I rename the dataset and publish, it publishes successfully. I have many reports online built off of the current dataset, so renaming and starting over is not really an option. ... View more

The publish to web is hiding the flag, about, and expand-to-full-screen links on the following webpage when using Edge/IE: http://www.theenergycollective.com/atlaspublicpolicy/2380955/the-fast-lane-to-more-evs. The same webpage looks correct on Chrome. ... View more

0 down vote favorite I'm trying to import data from a web page to Power BI Desktop. The URL is the following: https://casa.sapo.pt/Venda/Apartamentos/Maia/?sa=13 It contains data about housing prices, characteristics, etc. The query returns an empty table, although if I browse to the page with any browser and without authentication or login, I see it contains the data I'm looking to analyse so I guess the publisher has disabled somehow the query I'm trying to make. Does anyone know a workaround? ... View more

Hello, I am learning BI Desktop, but the Add Conditional Column dialog box has some issues, as described below 1. When I reopen the dialog box, the (first 2 of 3) Operator Values that I selected are not there. The other values on the row are there. 2. Pressing the Delete key in a Value field, deletes the row. To me, the Delete key should delete the value that I typed in the Output field. 3. How do you check for a null value in a date field? I tried typing in null in the Value field and also tried leaving the Value field empty, neither worked. I also tried using the Otherwise fields Enter a value option, thinking it would work as a catch-all, that didn't work either. ... View more

How can a simple import of a small excel data sheet (348k xlsx file) that consists of just 33 columns and 1600 rows become a whooping 77 mb pbix file, even before anything else is done but connecting the data. Is it supposed to be like this? I suspected both formats to hold adequate file compression levels... ... View more

I have successfully create a Power BI Desktop report and exported it as a Template File. When I tested it, it correctly prompted me for entering the value of the parameter at start up. However, when I shared the template file with a colleague and when she open the file, the parameter window did not show up. Has anyone else experienced this problem? ... View more

The ability to have bars on a bar chart change color based on their data value. This would have each bar act like a KPI, changing colors ie. "Data Value < 0 Bar Color is Red" else all bars are gray. ... View more

I published PowerBI content to a group, and I'm sharing only the dashboard with users that are not included in the group. Some users can see the data, others get "Can't Display Visual" errors. I've triple checked that I've provided everyone with the same access, but I still get issues. ... View more

I have created several reports that use the attribute slicer as well as the date drill down features. When I run locally on Desktop, they run smoothly, however, when I publish to to my workspace and share, the visuals load at a snail pace. Any thoughts? ... View more

How I can export rows after filtering in a report or panel ?, similar to what would in a PivotTable in Excel where when you double-click generates the records that meet the filter. ... View more