New Idea
0 Kudos

Please allow "Clear selections" in Slicer when Header turned off and Title is turned on.

This is one of the must have features in Power BI. When the developer wants to rename the Slicer, there are two ways. Either to rename the column itself or use the "Title" feature to create a new Title. Only the problem is once the title is enabled and Header is turned off, this takes away the ability of the developer to use "clear selections" as the option vanishes.
Please look into this. Also, we cannot change the orientation of slicer (Dropdown, list etc.) when header is turned off and title is turned on.

 

Thanks.

0 Kudos

October Update Not Updating

Status: New
by triz231 Frequent Visitor on ‎11-09-2016 11:47 AM

I have the January 2016 Version.  I have attempted to update to the latest October release, unsuccessfully.  I uninstalled PowerBI all together and reinstalled.  It still shows it is January 2016 Version.  Have not found a resolution yet.

Capture.JPG

0 Kudos

After upgrading the Personal gateway to the june version blank date fields gets imported as 1899 dates rendering my reports broken (since I filter on e.g deleted_at = blank).

 

Swithced back to older version (Apr release) returns import to normal behaviour.

 

This is an on premises scheduled refresh from an AWS RDS ProstgreSQL DB.

 

Any idea on how to correct this?

0 Kudos

Problems with Azure Active Directoryy Preview

Status: New
by dwilsontt New Member on ‎05-29-2017 11:33 AM

I am having an issue with the Azure Active Directory Preview. It was working fine up to last week but now I am getting the floowing error:

 

Data source errorColumn 'Details.Unique ID' in Table 'Unique Users' contains a duplicate value '6a094cee-605a-4a9a-924b-cf8f2c1b7c94_a672d62c-fc7b-4e81-a576-e60dc46e951d_201705251854_190.213.84.10_0' and this is not allowed for columns on the one side of a many-to-one relationship or for columns that are used as the primary key of a table.
Activity IDb43d63f8-af24-1fd3-df21-fdfda65c4f95
Correlation IDdbd0183d-dd27-56ab-598e-b16a66783ff5
Request IDf5e8d080-8a1b-0386-6971-210824d2fedf
Status code400
TimeMon May 29 2017 14:09:10 GMT-0400 (SA Western Standard Time)
Version13.0.1700.2316
 
Can anyone help?
0 Kudos

 

Hello,

We have an issue on the bar chart refresh in the Power BI Service. We have the following setting:

  • We have a line chart (left side) and a bar chart (right) as shown in the picture below.
  • Both visualizations get their data pushed from the same Stream Analytics job, so actually both visualizations should show the same result.
  • The line chart refreshes correctly. But the bar chart shows data only sporadically so that not all data points are displayed (as you can see, the line chart displays a lot of peaks more compared to the bar chart)
  • The bar chart did work correctly about a month ago!

issue.png

Maybe this is a bug in the bar chart visualization introduced in the last (or previous) Power BI service update?

 

Can you help us on this issue?

0 Kudos

Error SQLQuery to table not the same data.

Status: New
by jpsolares Occasional Visitor on ‎04-25-2017 01:40 PM

Hi,

I just make a T-SQL Query

 

#invoice, DateInvoice, Month, year, Isoweek#invoice, DateInvoice, Month, year, Isoweek

When i see it in Power(In a table) its show different.

#InvoiceNumber, Isoweek, Month, Date#InvoiceNumber, Isoweek, Month, Date

The problem that month and isoweek differ baddly.

 

Any idea to fix this thanks in advance.

 

Greetings,

 

JP

 

 

0 Kudos

A report that has one page can be exported to power point by users within the domain easily . External users are unable to export. The in progress message box keeps spinning and nothing happens . User stopped after 30 mins. I have opened a ticket with support

0 Kudos

Dear Power BI,

 

After the update the following location solution as provided in this post does not work anymore:  If we just use the postalcode we get locations in Australia insteed of The Netherlands. 

 

The solution of with the country worked untill the last update of Power BI.

Re: Problem with map and postal code

[ Edited ]
 

Just a quick update: adding the country name in front of the post code with a custom column fixed the problem for us: [Country + Post code]="Australia "&[PostalCode] that of course assumes that all customers are in Australia which is the case in that instance. Interestingly following on with the post above: the same approach with "AU" did not work.

 

Kind regards,

Raymond Peters

0 Kudos

I am not able to show the legend if there is only one value is inserted in a visualization.

As I do not have description of the measures in my title, so I need to show the legend.

 

I have only chosen one valueI have only chosen one valueI have only chosen one value. Thus I can not decide to show or not show legend.I have only chosen one value. Thus I can not decide to show or not show legend.I have only chosen two values now. Thus, I am not able to show legend.I have only chosen two values now. Thus, I am not able to show legend.

 

 

This issues seems to involve all charts where it is possible to have several values.

0 Kudos

Hello,

 

I'm getting the following error when using the sample code in GitHub. 

Invoke-RestMethod : The remote server returned an error: (415) Unsupported Media Type.
At C:\Users\user\Documents\GitHub\powerbi-powershell\refreshproduction.ps1:82 char:1
+ Invoke-RestMethod -Uri $uri –Headers $authHeader –Method GET –Verbose
+ ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
+ CategoryInfo : InvalidOperation: (System.Net.HttpWebRequest:HttpWebRequest) [Invoke-RestMethod], WebException
+ FullyQualifiedErrorId : WebCmdletWebResponseException,Microsoft.PowerShell.Commands.InvokeRestMethodCommand


# This sample script calls the Power BI API to progammtically trigger a refresh for the dataset
# It then calls the Power BI API to progammatically to get the refresh history for that dataset
# For full documentation on the REST APIs, see:
# https://msdn.microsoft.com/en-us/library/mt203551.aspx 

# Instructions:
# 1. Install PowerShell (https://msdn.microsoft.com/en-us/powershell/scripting/setup/installing-windows-powershell) and the Azure PowerShell cmdlets (https://aka.ms/webpi-azps)
# 2. Set up a dataset for refresh in the Power BI service - make sure that the dataset can be 
# updated successfully
# 3. Fill in the parameters below
# 4. Run the PowerShell script

# Parameters - fill these in before running the script!
# =====================================================

# An easy way to get group and dataset ID is to go to dataset settings and click on the dataset
# that you'd like to refresh. Once you do, the URL in the address bar will show the group ID and 
# dataset ID, in the format: 
# app.powerbi.com/groups/{groupID}/settings/datasets/{datasetID} 

$groupID = "FIll Me In" # the ID of the group that hosts the dataset. Use "me" if this is your My Workspace
$datasetID = "FIll Me In" # the ID of the dataset that hosts the dataset

# AAD Client ID
# To get this, go to the following page and follow the steps to provision an app
# https://dev.powerbi.com/apps
# To get the sample to work, ensure that you have the following fields:
# App Type: Native app
# Redirect URL: urn:ietf:wgSmiley Surprisedauth:2.0Smiley Surprisedob
#  Level of access: all dataset APIs
$clientId = "FIll Me In" 

# End Parameters =======================================

# Calls the Active Directory Authentication Library (ADAL) to authenticate against AAD
function GetAuthToken
{
       $adal = "${envSmiley TonguerogramFiles(x86)}\Microsoft SDKs\Azure\PowerShell\ServiceManagement\Azure\Services\Microsoft.IdentityModel.Clients.ActiveDirectory.dll"
 
       $adalforms = "${envSmiley TonguerogramFiles(x86)}\Microsoft SDKs\Azure\PowerShell\ServiceManagement\Azure\Services\Microsoft.IdentityModel.Clients.ActiveDirectory.WindowsForms.dll"
 
       [System.Reflection.Assembly]::LoadFrom($adal) | Out-Null
 
       [System.Reflection.Assembly]::LoadFrom($adalforms) | Out-Null
 
       $redirectUri = "urn:ietf:wgSmiley Surprisedauth:2.0Smiley Surprisedob"
 
       $resourceAppIdURI = "https://analysis.windows.net/powerbi/api"
 
       $authority = "https://login.windows.net/common/oauth2/authorize";
 
       $authContext = New-Object "Microsoft.IdentityModel.Clients.ActiveDirectory.AuthenticationContext" -ArgumentList $authority
 
       $authResult = $authContext.AcquireToken($resourceAppIdURI, $clientId, $redirectUri, "Auto")
 
       return $authResult
}

# Get the auth token from AAD
$token = GetAuthToken

# Building Rest API header with authorization token
$authHeader = @{
   'Content-Type'='application/json'
   'Authorization'=$token.CreateAuthorizationHeader()
}

# properly format groups path
$groupsPath = ""
if ($groupID -eq "me") {
    $groupsPath = "myorg"
} else {
    $groupsPath = "myorg/groups/$groupID"
}

# Refresh the dataset
$uri = "https://api.powerbi.com/v1.0/$groupsPath/datasets/$datasetID/refreshes"
Invoke-RestMethod -Uri $uri –Headers $authHeader –Method POST –Verbose

# Check the refresh history
$uri = "https://api.powerbi.com/v1.0/$groupsPath/datasets/$datasetID/refreshes"
Invoke-RestMethod -Uri $uri –Headers $authHeader –Method GET –Verbose

 

Line 78

 

Invoke-RestMethod -Uri $uri –Headers $authHeader –Method POST –Verbose

 

Appreciated if someone could help resolve this issue.

 

Thanks,

Anton

0 Kudos

In my table a blue/green line is shown.

I have just downloaded the newest Power BI desktop today.

 

Here it is shown in desktop - grey line in the bottum:

 

Capture2.PNG

 

¨Here it is shown in the service, with a green/blue line:

 

Capture.PNG

0 Kudos

Dashboard only partially refreshing?

Status: New
by mwaltercpa Frequent Visitor on ‎05-13-2017 06:59 PM

I have a sales dashboard that updates every day with prior year and current year sales and measures.  Some days, I notice that the sales are not completely updated in the dashboard, like the refresh times out. 

 

I have to refresh the dataset agian, then all the sales appear complete in the dashboard.

 

Anyone else with this issue?

 

My data is on prem csv, I have paid pro, I schedule multiple dashboards to auto refresh through the personal gateway each morning.

 

Thanks,

Mark

0 Kudos

Hello,

 

I'm working with PowerBI Desktop and I did a report to execute TFS/VSTS workitem queries. I used the REST API, so I had to call one API to execute the query and retrieve the workitems IDs and, for each batch of IDs (200 at a time), I call another API to retrieve workitems details. You can download a sample here.

 

I created some functions an a Query that calls the functions like this:

 

let
    queryId = GetQueryId(CollectionUrl, QueryTeamProjectName, QueryPath),
    queryResult = ExecuteWIQ(CollectionUrl, QueryTeamProjectName, queryId),   

    fieldList = GetFields(queryResult),
    idList = GetWorkitemIds(queryResult), 

    //Control Parameters 
    countOfIds = List.Count(idList),
    ItensPerRequest = 200,
    WorkItemsTable = #table(type table [],{}),
    Result = GetAllWorkitems(CollectionUrl, idList, fieldList, 0, ItensPerRequest, countOfIds, WorkItemsTable)
in

    Result

 

When this code runs, I get this error:

 

Formula.Firewall: Query 'MyQuery' (step 'Result') references other queries or steps, so it may not directly access a data source. Please rebuild this data combination

 

I build the functions exacly to avoid this kind of error, so I did not understand why I was getting it again. I did some debug, and I discovered that if I returned in the in clause a variable that was not in the last line of the let clause, the error disapears, and the code runs ok!!! Yes, very strange... so if I add an atributtion line of code, that don't means nothing, just to be the last line, and returns the line before it, the error desapears:

 

let
    queryId = GetQueryId(CollectionUrl, QueryTeamProjectName, QueryPath),
    queryResult = ExecuteWIQ(CollectionUrl, QueryTeamProjectName, queryId),   

    fieldList = GetFields(queryResult),
    idList = GetWorkitemIds(queryResult), 

    //Control Parameters 
    countOfIds = List.Count(idList),
    ItensPerRequest = 200,
    WorkItemsTable = #table(type table [],{}),
    Result = GetAllWorkitems(CollectionUrl, idList, fieldList, 0, ItensPerRequest, countOfIds, WorkItemsTable),
   
    //Workaround para erro => Formula.Firewall: Query 'MyQuery' (step 'Result') references other queries or steps, 
    //                        so it may not directly access a data source. Please rebuild this data combination
    workaround = 1
in

    Result

 

This is the version I used in the template you can download above.

 

Is this a Bug?? 

 

Regards,

 

Igor Macedo

0 Kudos

Events in Tureky

Status: New
by Kenan_Jaddeny New Member on ‎12-19-2016 03:34 AM

Hello every one

 

I'm wondering about if there're any upcoming events for MS Power BI in Turkey?

Thanks.

The gateways seem to disconnect from the cloud account , trying to re insert them gives an error 

"personal gateway sign in error: an unknown state error occurred Initial Response"

 

Could someone please advise ? ?

0 Kudos
 
First off
We are new to the PowerBI cmmunity, but PowerBI impresses us so far. Very nice product and we hope to contribute to the community in the future. We think we have encountered an issue and hope if you guys can help us out or if indeed it is a bug it could get registered and fixed.
 
Setup
We are using the Direct Query functionality on an Oracle database with the following Query where INSDATE is the insertdate of the record. The Enterprise Gateway connects the database to the online PowerBI environment. Within PowerBI desktop the report gets filled with all relevant records of the current day and using the publish gives the expected results also within the online environment.
 
 
let
    Source = Oracle.Database("alias_adres", [HierarchicalNavigation=true]),
    DBASE = Source{[Schema="DBASE"]}[Data],
    UNIT1 = DBASE{[Name="UNIT"]}[Data],
    #"Filtered Rows" = Table.SelectRows(UNIT1, each Date.IsInCurrentDay([INSDATE]))
in
    #"Filtered Rows"
 
Issue
Whenever a day passes the report within the PowerBI online environment it still keeps showing the records of the day before and not for the current day as we would expect. Within the PowerBI Desktop environment, after a refresh we see the records we would expect from the currentday. So the functionality works allright there. A renewed upload of the .pbix file corrects the issues on the PowerBI online environment.
 
Suspected problem
Hence, we suspect that Date.IsInCurrentDay() function uses the uploadday of the .pbix file as reference to the current day and not the system/server/current as value for the query. This would be unwanted behaviour of the functionality for us as a daily manual upload seems to be a bit tedious and get in the way of us taking a holiday now and then.
 
Consideration
We are considering using a view on the table with the currentdate within the Oracle database layer to overcome this problem, hower, as Synonyms on the Oracle Database don't work with PowerBI, it might be highly possble that views won't work either. We will have some testing done next week with the datase admin to make sure if creating a view is a viable band-aid for the issue and will keep you update in this thread on that.
 
Questions to Microsoft/PowerBI Community
Is this a known issue?
Is this only an issue with Oracle databases?
Does anyone has other workarounds or solutions other than sugggested at our Considerations?
Or did we something obviously wrong in using the functionality and should we use something different?
 
Love to hear from you and hope you can help us out!
 
Thnx in advance,
Grazz.
0 Kudos

Already a paying member, stuck in Trial Expired Hell

Status: New
by imdb Occasional Visitor on ‎05-18-2017 08:42 AM

Somehow the trial was still running though I've already upgraded. The trial behind the scenes must of expired, now I am stuck in trial/puchase purgatory. 

 

Here's what I am seeing

Screen Shot 2017-05-18 at 11.39.53 AM.png

 

When I attempt to access my data I get

 

Screen Shot 2017-05-18 at 11.29.16 AM.png

 

When I attempt to Upgrade Account I get

 

Screen Shot 2017-05-18 at 11.29.28 AM.png

 

Round and round I go. What do to do next?

0 Kudos

Make Refresh Stable

Status: New
by jmiridium Member on ‎06-13-2017 07:33 AM

I am having multiple issues refreshing the data. It's at a point that at this time we are considering going with another solution. I have added this issue to the comunity, but need an actual support issue on this:

 

http://community.powerbi.com/t5/Integrations-with-Files-and/Refresh-Errors/m-p/192553#M10806

0 Kudos

GAteway connnection to a live SSAS is throwing a error, but not showing a error message. Also the data seems to be updated so the gateway connection seems fine. Not sure why we are seing the error, and if that means that the connection can potentially fail.gateway issue.PNG

Idea Statuses