New Idea
0 Kudos

Hello, I'm playing with MaxMind database worldcitiespop, a database that has a record for all cities in the world.

I know, more than 3M eneteries is too much, but the problem seems happening just with a few thousands.

 

I have no problem listing more than 4000 cities for New Zealand or Switzerland:

 

 


New ZealandNew ZealandSwitzerlandSwitzerland

 

 

 

 

 

 

 

 

 

 

 

Australia.PNGFrance.PNG

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

Problem starts with Australia, 20,000: location are all listed down a certain parallel:

 

 

 

 

 

 

 

 

 

 

 

 

 

 

France 60,000: same problem

 

 

 

 

 

 

 

 

 

 

 

 

And so on with, Italy, United States, Spain, Mexico or whatever. After a certina limit of pins the map just cannot hold it.

I found the same problem with ALL Custom Visual maps except for GIS.

 

 

 

 

Status: Needs Info
0 Kudos

Hi,

 

I have moved all my reports to run of one data model from the PowerBI service in the hope that if I change it in one place it changes it in them all.

 

Unfortunatly I have found out that you cannot edit the shared query in the report.

 

This makes it very annoying as I then have to open up the report with the shared data model before I can make any changes tpo the query.

 

I would be more useful if it is possible to amend the query in all reports using the shared datset.

 

Thanks

Status: Delivered
0 Kudos

Error en dashboard

Status: Delivered
by CerescosBI Frequent Visitor on ‎05-23-2017 11:54 AM

Hola a todos,

 

Desde la semana pasada algunos de los usuarios con los que comparto mis informes no pueden acceder, por el error que muestro en la imagen de abajo, descubrimos que con actualizar los iconos desde su sesión el problema deja de suceder, lo raro es que cuando vuelven a iniciar sesión vuelven a tener el mismo problema.

errorPowerBI.png

 

 

 

 

 

 

 

 

 

 

 

 

Saludos,

Status: Delivered
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

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

I am very new to PowerBI, I want to add REST API like /API/{TicketId}/audit.json  here {Ticketid} should be dynamic and filled from another API  /API/Ticket.json

is this type of integration possible in Power BI, if yes please let guide me on this

0 Kudos

I have selected green as the background for my slicers (a green which is part of my color theme).

When I select the item (in this case LCY or DKK) the selected item is showed as black in Power BI Desktop, but in power bi service it is not possible to see which item that is selected, both of them are shown as green

 

 

 

 

Status: Delivered
0 Kudos

Schedule Daily Refresh MORE THAN 8 Times

Status: Delivered
by ctembe Visitor on ‎05-17-2017 05:29 AM

Hi,

 

How can one Schedule a DataSet Refresh on Daily Basis, more than 8 Times (Which is LIMIT Currently on Cloud Service)

 

Please suggest..

 

Regards,

Chaitanya Tembe

Status: Delivered
0 Kudos

Hi,

 

I have tested the new conditional formatting - data bars... the data bars for the positive values are always drawn from zero (from the axis), regardless setting the numeric minimum value or use of lower value, see figure below...
Minimum has an effect on visualization only for negative values and maximum for positive values ... I do not know if it was the intention ...
In my example, I would like to use a bar in the range of 15 - 19, as allowed by MS Excel... Is / will be this possible?

 

Thanks

Petr

 

Conditional_Formatting_Bars.JPG

Export PowerPoint Blank Slides Problem

Status: Accepted
by aungpyae Occasional Visitor on ‎03-09-2017 03:14 AM

Hello,

 

I tried to export to PowerPoint but it created blank slides. I can export to PowerPoint by using existing examples created by Power BI itself. However, for my own report, I could not export.

 

Regards.

Status: Accepted
0 Kudos

Can't change ClickDimension connection parameters

Status: Accepted
by mmohabbat New Member ‎05-24-2017 03:55 PM - edited ‎05-24-2017 03:56 PM

I attempted to add a ClickDimensions appsource within PowerBI. The wizard asks for the Datacentre then credentials. Unfortuantely I entered the wrong credentials and despite deleting that workspace and attempting to re-add, there is a bug I have found (I assume).

 

Each time I add the ClickDimensions connector it prompts for the Datacenter location but not the credentials. It's like the credentials are being cached somewhere. There is a workspace but no datasets to edit. I've tried deleting the workspace numerous times to no avail. I've also tried clearing browser cache and logging off the session. 

 

There is no way of amending the credentials after the fact so I cannot connect at all.

 

Thank you

Status: Accepted
0 Kudos

Filled Map resets on right-click

Status: Delivered
by amwithi Visitor on ‎05-30-2017 09:02 AM

Visual: Filled Map

Issue: Map resets upon right-click.

Occurrence: When a map is filtered down by e.g. selecting a region, right-click deselects the selection (resets the selection) to all.  This defeats the purpose of filtering down.  As an example, on a map of Counties, a user can click a particular county and filter the result set by that county.  If user wants to see this filtered data/records, right-click allows for those options.  However, with the new flaw, when a user right-clicks on the filtered visual, the options are present but the filter is removed.

First observed: 05/25/2017.

 

This feature is in reports about to go into prodution.  Please address issue ASAP.

Status: Delivered
0 Kudos

Hi

 

I am testing out a report which I created on Power BI desktop.  I use online services to connect to one of my sharepoint List. I could save and publish it on my o365 account.

 

But when I refresh it in the Power BI online, I encounter an error.

 

Please see attached.

 

Wondering if any folks had the same issue before? Any ideas or help deeply appreciated!

 

Cheers

BY

 

 

 PowerBI refresh error.PNG

Status: Needs Info
0 Kudos

Hello,

 

When attempting to connect to the Marketo Content Pack with the ClientID & Client Secret, I can successfully log in, but the data does not load.

 

On the dashboard created by the content pack, it hangs indefinitely, and in the Report it creates it generates the following error after a minute:

 

Something went wrong
 
Unable to load report
Please try again later or contact support. If you contact support, please provide these details.

 

Activity ID236ac89e-c3b7-0234-d08f-75090432a2ab
Request ID70d07e5a-873a-186e-c0e6-1097a6f13931
Correlation ID66e247e0-ab91-2f2a-515c-3726bf72ed16
TimeThu Jun 01 2017 11:28:21 GMT-0400 (Eastern Daylight Time)
Version13.0.1700.2352
 
This is with only 1 month's worth of data selected to pull in as well. Our Marketo users have full access rights to API permissions as well.

 

Status: Needs Info
0 Kudos

Hello,

 

I am facing slowness issue with all of my reports.
Some times report works faster and some time it works worse.

If in report there is more complex logic, like I have measures, then the slownes can be significant different. For example to refresh page after changes date range or other dimension slicer, it took up to 10 seconds for refreshing tables\charts, but in other time, for example 2-3 hours later it works better and time to refresh tables\charts tooks 1-2 seconds for the same report with the same data set, then the slowness appearance again with the same data set.

 

All reports have imported data from DB views and has star schema in data model, one fact table and around 10 dimensions.
The total count of rows in fact is about 3.5 Millions rows. The dimensions has 10-100 rows. In report I am looking for data for one year (~200K rows).
The data is automatically refreshed from Azure DB every night by scheduler.

 

Does something make influence in performance of my report outside of my reports? Like PBI updates, maintenance works, loading servers with other customers in the same time, etc..

 

Any information which can help me will be appreciated.

 

Regards,

Valentyn Zubenko

 

Status: Delivered
0 Kudos

Hello, I've submitted a ticket to whitelist my account, but now I'm unable to connect my Data Gateway to my gov.us powerbi account. My data gateway is saying it's connected, but it's connected to the free-trial account that was set up prior to the gov.us account. 

Status: Delivered
0 Kudos

PBI filters.JPG

I'd like to disable people to change the filtering option on shared reports. I shared it via My workspace and I thought that it's read only so they can't change it, but yesterday I could see that they can if they want to, but I don't want then to be able to change it at all as some of the information is restricted that's why I filtered it out.

 

These are simply shared reports via powerbi, not embedded or anything else.

 

Can I change this to real read only?

 

Thanks, Szilárd

0 Kudos

Hi Everyone.

 

I've installed a new SQL Server Analysis Services instance on Tabular Model for testing with Power BI Desktop. When using the Import option, it works fine.

When setting up a Live Connection, I can see the model and the cube I've created, but when using any attribute or measure in any visualization, It shows the error: Can't Display the visual. 

 

Error Code:
OpenConnectionError

OData Error Message:
Failed to open the MSOLAP connection.

 

Any ideas?

Thanks in advance.

 

Status: Needs Info
0 Kudos

Larger Dataset Fails To Publish

Status: Needs Info
by Jmcgrath Frequent Visitor on ‎05-03-2017 08:52 AM

Whenever I try to publish large dataset publishing to PowerBi just spins.  Occassionally dialog box will just disappear no notification or error and report is not published.  Anyone have any success publishing larger datasets to online service?

Status: Needs Info
0 Kudos

Pull data from JIRA

Status: Delivered
by RasikaOgale Frequent Visitor on ‎05-18-2017 02:07 AM

Hello All,

 

I am using JIRA Content pack to import the data to Power Bi. I am getting following two error:

Please help me to understand why am getting those error.  

1. Error 

"We found extra characters at the end of JSON input.. The exception was raised by the IDataReader interface."

 

2.Error 

Failed to update data source credentials: Web.Contents failed to get contents from 

"JIRA url"Smiley Sad404): Not Found

Status code:400

 

 

Status: Delivered
Idea Statuses