Yesterday, I had created a dashboard from a dataset connected to Elasticsearch. But today morning (29/09/16), I found the contents of the report was missing, but the dashboard does not show any issues. How can I retrieve the report's content back? Note: all other reports and contents are safe. ... View more

I'm having an issue where I get different results when I create a dataset with certain steps such as filtering out data and sorting, delete the steps, and recreate them again. Sometimes rows are left out and what I have in the Power Query screen doesn't match when I create a table in the report. I have had one line of data with an amount of 350 and if i create a table in the report and have it do a summation, it multiplies it by 2 and displays 700. This multiply by 2 happens randomly to other numbers in the same column as well. I have rows appear and disappear and the number multiplied by 2 go back to what it should be when the only change i do to a dataset is sort the dataset by date. Please advise! ... View more

Azure MySQL: Unable to connect to any of the specified MySQL hosts. Error Code: DM_GWPipeline_Gateway_MashupDataAccessError Can not connect to MySQL database in Azure. Also tried changing the hostname to the ip address but it did not help ... View more

NULL ... View more

We are unable to refresh our power bi reports, its not showing anything and is affecting all our reports. We checked the server health and power bi gateway all is working fine. Could you please help us to see what's causing this issue if its specific to our reports. And if it has affected overall than please provide update in order for us to update our clients. Thank you Laxmi (v-laxmo) ... View more

http://community.powerbi.com/en-us/documentation/powerbi-webinars/ Returns page does not exist. ... View more

When using a Live Connection to SSAS Cube, I am not getting any formatting for calculated and base measures when using Multi Row Card. When we use this visual even when the format string is specified to remove decimals, the values are rendered with 2 decimal places. Similar thing is happening for Percent formatting and I'm getting a value of 0.xx instead of xx%. ... View more

Exported csv data file with Cyrillic chars some time return wrong characters if the report was modified over the IE. ... View more

I prepared a dataset which contains info from multiple sources, ODBC connection and GA. Tried to schedule automatic refresh using gateway and it fails. I took test dataset with 2 sources separately, seems to be working that way, i.e. one dataset with info ONLY from GA can be automatically refreshed and another dataset with info ONLY from Database (connection using ODBC) also can be refreshed. When put together, refresh fails. Can u pls help with that issue Thx ... View more

The tables with conditional formatting look fine in desktop. As of last week,when published, the table visuals which have conditional formatting are completely blank, just white squares. ... View more

When using iframe in HTML the share option gives user direct access to link. Is it possible to hide the option from user. ... View more

When using iframe in HTML the share option gives user direct access to link. Is it possible to hide the option from user. ... View more

When using iframe in HTML the share option gives user direct access to link. Is it possible to hide the option from user. ... View more

I do have different data sources but my values ("descriptors") are the same in the sources. Although Power BI does not recognise this so I have to change the colours manually. An intelligent colour coding that recognises once the descriptor is the same and colours the bars in the same colour would be perfect. ... View more

Let me first stat that I'm new to Power BI. Using the Power BI Desktop, I've not been successful using the DIAD lab, I've not been successful at generating a visualization for anything. When I go to create dashboard and add visualizations the charts/graphs do not generate. All I get is a representation of a spinning courser in the upper left of each visualization. I've tried this on two different machines, both using Windows 10 enterprise. I know this is not much to go on but I don't know where to start looking. One of the instructions indicated he had seen this before but could not point me in a direction for resolution. Any ideas are appreciated ... View more

I have a Tabular data model with [Calendar] and [Incidents] data sets. The [Incidents] data set has [Create Date] and [Resolve Date]. I create a relationship for [Calendar].[Date] -> [Incidents].[Create Date] (this is marked as active) and a relationship for [Calendar].[Date] -> [Incidents].[Resolve Date] (marked as inactive). I then create 2 measures; Created and Resolved. Both use the CALCULATE and USE RELATIONSHIP functions e.g. Created:=CALCULATE(sum([Incidents],USERELATIONSHIP('Incidents'.[Create Date] = 'Calendar'.[Date]). The results are perfect when querying the Tabular data model via Excel. However, PowerBI will not show the correct totals for the Inactive relationship when there are more than say 20 items in the visual. e.g. if you want a tabular visual that shows Resolved by [Assigned Group], and there are 50 assignment groups, the total is < than actual total. I have tried to replicate with the same data in SQL and Excel and it works just fine. Only Tabular data models are the problem. Please help ... View more

We are trying to calculate sales over differing rolling periods given the maximum date in the dataset - I have tried multiple formula but in each case when you set the start date equal to a formula the calculation is not correct - take a look at the following examples for a rolling 7 day calculation Working - Past 7 Day Bill Count = CALCULATE(DISTINCTCOUNT('rep SaleDailyTurnOver'[SaleID]), FILTER ( ALL ( 'rep SaleDailyTurnOver'[SaleDate] ), 'rep SaleDailyTurnOver'[SaleDate] >= DATE(2016,8,21) && 'rep SaleDailyTurnOver'[SaleDate] <= MAX ( 'rep SaleDailyTurnOver'[SaleDate] ) ) ) Not working - Past 7 Day Bill Count = CALCULATE(DISTINCTCOUNT('rep SaleDailyTurnOver'[SaleID]), FILTER ( ALL ( 'rep SaleDailyTurnOver'[SaleDate] ), 'rep SaleDailyTurnOver'[SaleDate] >= (MAX ( 'rep SaleDailyTurnOver'[SaleDate] ) - 7) && 'rep SaleDailyTurnOver'[SaleDate] <= MAX ( 'rep SaleDailyTurnOver'[SaleDate] ) ) ) We also did something similar for the datesbetween function in the calculation, with similar results - Past 7 Day Bill Count = CALCULATE(DISTINCTCOUNT('rep SaleDailyTurnOver'[SaleID]), DATESINPERIOD('rep SaleDailyTurnOver'[SaleDate], LASTDATE('rep SaleDailyTurnOver'[SaleDate]), -7, DAY)) ... View more

I am trying to import data from a MySQL database located on a server but I keep getting one of the two messages mentioned above. My initial database had table header written in camelCase. I tried changing it to snake_case, also I tried removing all my data from the tables and had the same issue. ... View more

I have created Bar with Line combo chart in that I want to display the forecast line .Please provide the solution.I see analytics properties available in the August released Power BI desktop,But it doesn't have option to display forecast line. Currently I am using August released Power Bi version. ... View more