New Idea

I try to get my table from my dataset in Bigquery into Power BI Desktop. But unfortnately I m getting to follwing error:

 

DataSource.Error: ODBC: ERROR [HY000] [Microsoft][BigQuery] (100) Error interacting with REST API: Not found: Job first-projec:job_dm6z7i391YiYbOwjL7t-ydZ4V26dd6dfnv8
Details:
DataSourceKind=GoogleBigQuery
DataSourcePath=GoogleBigQuery
OdbcErrors=Table

 

I tried the following to lose this error:

- Changing this line in the M source code:

Quelle = GoogleBigQuery.Database(null)

to:

Quelle = GoogleBigQuery.Database([BillingProject="Billing-Project-Id"]) 

- I used the Simba ODBC driver as described here : Simba-BigQuery-ODBC-Driver-Quickstart2.pdf

 

Is this still a bug in Power BI?

 

P.S: my dataset and google cloud storage are in the same region, europ-west2

 

 

Selecting colors in Data Color tab on visuals and they are not accurate

Status: Accepted
by Shelley Member ‎10-05-2018 01:21 PM - edited ‎10-05-2018 01:34 PM

Ever since the September release, when I select colors in a data colors tab, the color I select is not what PBI applies. I am using a JSON color theme - it always worked just fine - but with this release it does not. I tried reloading the JSON file and still the same. I try to select green and it applies pink, for example. This is making PBI useless for conditional formatting. In addition, I cannot select any colors accurately at all, so my file looks like a piece of junk.

Status: Accepted

Fix the "Data Loading" / "Almost Done" issue

Status: New
by SMHolck Frequent Visitor on ‎10-02-2018 02:56 PM

Multiple people in my organization are unable to view published apps in our Power BI tenant.  They can sometimes click Apps and then wait for it to load forever.  You see a brief message "Data Loading" followed by "Almost Done."  And it will spin for hours.  My entire company has a Pro license.  The data loads fine in my Power BI desktop.  Issue happens on both IE 11 and Chrome 69.   Good thing I'm not currently doing my presentation on why you should use Azure!AlmostDone.png

 

I've seen this happen often and on.  You never know when it is going to happen.  My Azure admin says when he logs in to Azure portal it tells him no known outages.

 

 

Hello there, we have some published reports using the Facet Key custom visual, however today those visuals are not working in any level (not the PBIX in desktop, neither the ones in our workspaces and not even the ones that we previously published to web).

 

Here are the things I have tried so far:

- Updating the visual from the marketplace

- Deleting the visuals and create them again

- Activating the "Modern visual header with updating styling options" in the desktop reports

- Saving that previous file with another name and even as a template

- Publishing the report to a workspace, and export it as a PBIX

 

So far the only way I have found this visual to work again is to create a file from scratch and draw everything again. However since we have lots of reports created and lots of work done in the query editor, data editor and in the report itself, we would like to avoid this solution if another one may be suggested.

I also matched the "Current file options" in the new file with the old ones and still didn't work.

 

Help would be appreciated.

Regards

Status: Accepted

why powerbi app in web browser (firefox 2018) show multiple scroll that not appear in the power bi desktop when we design the page, i can't find where the option to disable this multiple scroll, please check and hire more manpower to take care powerbi, to much basic and simple bug.

These circled scroll bar is not appear in powerbi desktop, its really disturbing the view

sc.jpg

Status: Needs Info

Hi everyone,

 

Since the latest PBI service update the Chiclet visual is not working within published reports. The issue has been raised in the Community forum but yet to be resolved:

 

https://community.powerbi.com/t5/Service/Slicer-works-on-Desktop-but-not-well-Online/m-p/242274/high...

 

From initial testig this is what we have found:

 - various versions of the visual work within PBI Desktop (also variety of versions) but whenever published doesn't work as it should

 - when published online the visual doesn't refresh the other affected visuals (instead it either does nothing, displays the wrong information, or requires a different visual to be clicked before it is refreshed)

 - only under one circumstance were we able to get it published correctly (that was to an account we created years ago in O365 - all other accounts, including new accounts created in O365 today, fail to load the visual properly)

 - the visual works fine within the Windows 10 PBI App

 - the issue (that we have kown about) has been ongoing for the past few days - corresponding with the latets PBI Service update

 

Any help would be much appreciated as we have over 50+ reports using this visual and it's quite an embarassing to have to explain to users/customers we're not sure why or when the issue can be fixed.

 

Thanks

 

Jarrod

Hierarchy Slicer do not work on IE11

Status: New
by MPeinado Regular Visitor on ‎05-09-2018 03:03 AM

Hierarchy Slicer do not work on IE11.  Yesterday,it worked fine...

??

 

??1.jpg

Error in credentials (R) - Power BI Service

Status: New
by pbardales Visitor ‎11-05-2018 09:07 AM - edited ‎11-05-2018 09:26 AM

I uploaded in a power bi Service a Power BI file where i am using R script (power query) , when i try to configurate the schedule refresh I get the next message in the credentials part ( it runs without any problem in Power BI Desktop);

Captura.JPG

I have installed the last version of the personal gateway, and the versions of the R Packages that are supported by Power BI service (https://docs.microsoft.com/en-us/power-bi/service-r-packages-support)  but I cant's run this succefully, I don't know what to do ...

Bug in Editing Titles on Visuals

Status: New
by Shelley Member on ‎07-16-2018 07:59 AM

There appears to be a bug that's driving me crazy. It seems to be every time I go into the title of a visual and want to delete characters, it deletes the who visual. Here's exactly what seems to be happening. For example, I have a KPI visual. I want to edit the title, so I hit the paint roller, scroll down and click into the Title Text box and arrow over to the characters I want to delete. I hit the delete key to try to delete half the text. When I click the delete key once, it deletes one character, and then takes my cursor out of the Title Text box! When I hit delete again to delete the remaining characters, it now deletes the entire visual. This happens all the time with the latest release because it's natural to hit the delete key multiple times to delete multiple characters. As you can imagine, this is frustrating and inefficient. (Incidentally, I just discovered, if I use the backspace first and then the delete key, hitting the delete key more than once does not take me out of the Title Text box and actually works as imagined).

 

Capture.PNG

 

After update my report and publish in pbi service, the images lost. Help me.

 

If I delete my report and publish in a new link, the images appeared again. The problem is I lose my link...

 

versao.PNGmy versioninicio.PNGon power bi desktopweb.PNGon web

 

 

Thanks with Regards, 

Status: Needs Info

When using the "Relative" style Slicer, I am unable to select options from either dropdown in my report in the Power Bi Service.


I have noticed this issue since Wednesday, 9/5. It is working on Power Bi Desktop, but my users cannot modify the timeframe in the Service. My option is to use the "Between" style in the interim until this issue is fixed.

 

DropDown menu options:

[Last, Next, This]

[Days, Weeks, Weeks(Calendar), Months, Months(Calendar), Years, Years(Calendar)]

Status: Needs Info

text filter element does not work

Status: Accepted
by nexter83 Occasional Visitor on ‎06-19-2018 04:20 AM

The text filter element does not work. If you write text in it, the filter will work. But you can not reset the filter

Status: Accepted

Hi there,

 

It seems we were able to reproduce this https://community.powerbi.com/t5/Issues/Custom-Visual-not-visible-in-Power-BI-Apps/idi-p/341683 and it looks like a bug. It affects not only custom visuals, but Image and background as well.

 

 

This is how test report with Image visual and Tachometer custom visual should look like. Original report works in Workspace and Apps.

 

 

To reproduce:

  1. Duplicate this report with Save as…
  2. Edit newly created report and save changes
  3. Update Apps
  4. Clean browser cache and Go to Apps
  5. Image and custom visual are not visible

 

  1. Open report in Workspace and then go to Apps
  2. Custom visual is cached and visible, Image is not visible

 

 

  1. Save As this report again with a new name
  2. Update App, clear browser cache and open Apps
  3. Image and custom visuals are visible now

 

 

Now. Let’s say I have 3 reports in Apps: Rep1 – original (visuals are visible), Rep2 – edited duplicate (visuals are not visible), Rep3 – duplicate of Rep2 (visuals visible). If I delete Rep2 and Update App it will broke Rep3 and I don’t see visuals again in Apps

 

 

Status: Needs Info

This is the specific Power BI Visual published by Microsoft that is currently broken:

 

https://appsource.microsoft.com/en-us/product/power-bi-visuals/WA104380786?src=office&tab=Overview

 

This was working as desired before updating to the July 2018 version of Power BI.

 

I use a Year slicer using the same Date field that I use for the Timeline Slicer. If I have the year 2017 selected in the Year slicer, I see all 12 months in the timeline slicer. If I then select 2018 in the Year slicer, the Timeline Slicer should update to show all months in 2018 up to the current month (August). But instead it is showing all 12 months. If I try to select a month, the timeline slicer refreshes the data/visuals on the page, but does not filter down to the selected month in those visuals. In fact even the Timeline Slicer itself refreshes, but does not indicate that you have made a selection.

 

If I click on another report page and then click back to this report page, the page will then update and show only the appropriate months and the Timeline slicer acts as expected. At least until I select Year 2017 in the Year slicer. Then it refreshes the visuals on the page and the Timeline slicer will only display the months through August for 2017 and similary will refresh the visuals on the page when you select a month, but does not actual filter the visuals down to that month or even indicate that a month was selected.

 

This was all working in previous versions of Power BI.

Broken2017.PNGWorking2017.PNG

The top image shows the broken timeline slicer, I then switched to page 2 in the report and then back to page 1 and took a screenshot of the working slicers.

 

Please help!

Status: Accepted

Looks like this issue was reported at least once before and was supposed to be fixed a year ago? https://community.powerbi.com/t5/Issues/Make-Desktop-and-Cloud-Slicers-Consistent/idi-p/179444

 

The slicers in the Desktop and the slicers on the Service behave differently for the same exact report. See two different examples below. The Desktop version turns the font white and the buttons black - which makes it very easy to see. However, on the Service, selection only turns the font white, it does not change the button to black, making it very difficult to see what has been filtered. These should behave the same for ease of designing around userfriendliness. In addition, it would be cool if we could select the color for when the filter is click (e.g. instead of black, perhaps we'd like to show green?). Thanks. 

Capture.PNGDesktop and Service UnselectedCapture2.PNGDesktop SelectedCapture3.PNGDesktop and Service UnselectedCapture4.PNGDesktop SelectedCapture5.PNGService SelectedCapture6.PNGService Selected

Status: Accepted

Bug in Editing Titles on Visuals

Status: New
by Shelley Member on ‎07-16-2018 08:13 AM

There appears to be a bug that's driving me crazy. It seems to be every time I go into the title of a visual and want to delete characters, it deletes the who visual. Here's exactly what seems to be happening. For example, I have a KPI visual. I want to edit the title, so I hit the paint roller, scroll down and click into the Title Text box and arrow over to the characters I want to delete. I hit the delete key to try to delete half the text. When I click the delete key once, it deletes one character, and then takes my cursor out of the Title Text box! When I hit delete again to delete the remaining characters, it now deletes the entire visual. This happens all the time with the latest release because it's natural to hit the delete key multiple times to delete multiple characters. As you can imagine, this is frustrating and inefficient. (Incidentally, I just discovered, if I use the backspace first and then the delete key, hitting the delete key more than once does not take me out of the Title Text box and actually works as imagined).

 

Capture.PNG

The custom visual Power KPI Matrix (https://appsource.microsoft.com/en-us/product/power-bi-visuals/WA104380814?tab=Overview) which is developed by Microsoft is not possible to upload to the organizational custom visual store. The error message is "Legacy Visuals are not supported." Uploading other visuals like the Chiclet Slicer, Word Cloud or Bullet Chart by OKViz was no problem.

When my resaerch was correct, this is because an old Power BI API is used in this custom visual (https://community.powerbi.com/t5/Service/Issues-with-Microsoft-Visuals-in-Organization-Visual-librar...). When we need to ask our customers to rebuilt their reports because of Microsoft not supporting their own published custom visuals, this would be a terrible argument to use Power BI.

 

As we need to shut down the usage of custom visuals, besides certified visuals from the organizational store, this is an urgent topic for us.

Status: Accepted

Issues uploading into Organizational Visuals

Status: Accepted
by JamesBI Regular Visitor on ‎06-29-2018 09:53 AM

We use the organization visuals so that users are able to see which visuals have been reviewed and are approved for use. We have noticed that not all visuals will upload, many will error out with no rhyme or reason. For example, the cluster map visual (developed by Micro

soft) was updated on 5/28/2018 so it is newer and it comes back with an error. Why are some of these visuals not working?cluster map error.png

Status: Accepted

PowerKPI Custom Visual Broken

Status: New
by GregatOB Visitor on ‎06-26-2018 02:22 PM

Around 3:30 - 4:00 PM CST today (June 26th), the PowerKPI custom visual broke on reports hosted in app.powerbi.com, as well as reports that I run locally in PowerBI desktop. 

 

The underlying data did not change.

I did not update the PBIX file

I did not download any updates to PowerBI.

I do not understand how this could have happened.

 

Please advise! I would particularly like to know if support for this custom visual has changed without notice.

 

https://appsource.microsoft.com/en-us/product/power-bi-visuals/WA104381083?tab=Overview

 

Flow map custom visual not working

Status: Declined
by dcresp Member on ‎02-05-2018 07:34 PM

The flow map custom visual in PBI Desktop was working yesterday but does not work today. I have tried the flowmap 1.2.6 example file and can also not get this working. Everything worked fine yesterday. I expect that changes to PBI have caused this.

Status: Declined
Idea Statuses