New Idea

HI,

 

I recently had to re write some reports due to changes made to our data warehouse, initiall i made the changes and attempted to republish the data, however the file would not publish, and just kept spinning.   I unistalled and reinstalled the gateway and powerbi and tried again, and this time recieved an error stating powerbi unable to write data to the transport connection.

 

I removed all data sets and reports from the web app, saved my pbix file in desktop using a different name, and tried publishing through desktop again, and recieved the following error:  An Error occurred while attempting to publish 'sales information.pbix': Exception of type 'microsoft.powerbi.client.windows.services.powerbiwebexception' was thrown.

 

I then tried to import the pbix file from the web and recieved this error:

 

Something went wrong
 
Failed to publish Power BI Desktop file
Please try again later or contact support. If you contact support, please provide these details.

 

Activity IDb08c123f-1bae-4f47-8098-44ec00537aee
Request ID67c1d93d-f94c-886f-b968-a556f558a7a2
Correlation ID921421f7-5d8c-df69-5505-d632a4dc1525
Status code-1
TimeThu Sep 07 2017 16:21:26 GMT+0100 (GMT Standard Time)
Version13.0.2278.219

 

i notice on the service status page there is an awareness flag stating:

 

We are experiencing a temporary issue where some users may not be able to update their Apps or Content packs. Engineers are aware of the issue and are working on a fix. Next Update by 09/08/2017 11:00 PST

 

Is this what is causing my problem, of is there another reason?   If this is the issue, is there a work around?

 

Thanks Dan.

 

 

Pin live page interactivity in iOS app

Status: Accepted
by greggyb New Contributor on ‎08-01-2017 12:03 PM

Allow pinned live pages to remain interactive in mobile apps. Live page interactivity is a large draw of this feature, but this limits a complete dashboard experience to the browser, and prevents end users consuming reports on mobile devices from having the same rich experience.

 

Per the forum thread linked below, this functionality was working in the past, but we have recently seen with a customer that pinned live pages are not interactive on the iOS app on iPads. Per an email from the Power BI support team, this lack of interactivity is by design.

 

https://community.powerbi.com/t5/Mobile-Apps/Pin-Live-page-slicer-in-ios-App-is-not-working/m-p/1605...

Status: Accepted

The following message was posted yesterday but there isn't any update and this feature is still not available... This is really needed especially as the "subscribe" button is appearing on the apps...

image.pngimage.pngCapture.JPG

Status: Accepted

Card with states visual - Data label issue

Status: New
by Sivasuba1 Frequent Visitor on ‎09-19-2017 06:28 PM

Does anyone facing the problem when using Card with States by OKViz?

 

The date label is not working after the cube refresh this morning. The color of data label should be red but it shows as green. This was working fine since Monday. I have read thru various issues report about this visual - we dont have text display issues for this but the data label color is mixed up

 

Do we need to change any settingStates setting.png

 

I am not sure what is causing this problem. Please do let me know as it's impact lot of users. 

 

Thansk,
Siva

Embedded report(javascript app owns data) is not showing images

Status: New
by dhagan Visitor ‎09-19-2017 07:40 AM - edited ‎09-19-2017 07:46 AM

I've embedded a report on a web app(javascript app owns data), the report works fine and i'm able to apply filters etc, but i'm getting 403 forbidden errors on all the images used by the report. I have no issues with the images when viewed directly on the power bi service, this is specific to embedded reports. I even created a new app(new clientId), and gave it more permissions, but that didn't help. Any ideas on how to fix this? 

 

Screen Shot 2017-09-15 at 12.18.11 PM.png

Yesterday, all my datasets were refreshing just fine but today nothing happens.

- The automatic refresh hasn't done anything.

- When I press "Refresh now", I get a "popup" saying "preparing refresh" for a split second and then nothing happens.

 

The only way to update the data is to refresh the Desktop version and then upload it. 

 

I have datasets connection to an on-premises database and one connecting to a sharepoint site.

- The on-premises connection usually works perfect, but now nothing happens.

- The sharepoint connection usually brings up an error,  if I try to refresh, but now nothing happens (I just tried it this time as a test, as it usually doesn't work automatically).

 

Can you please help troublefinding - It seems like an issue on you online portal somehow.

 

Thanks in advance.

 

// Tommy

Status: Delivered

When combined with non-SQL-datasources query-folding will often not work: http://www.thebiccountant.com/2017/07/20/sql-query-folding-bug-still-alive-sucking-powerbi-powerquer... 

 

This is really nasty. As performance optimizations is such a black art still unfortunately, many people will probably just throw the towel here, so I expect a high number of unreported cases here, so please fix.

Dashboard sharing Disabled for non-PRO users ?

Status: Delivered
by djnww Established Member ‎04-27-2017 05:28 AM - edited ‎04-27-2017 05:34 AM

We can no longer share a dashboard with users from our own workspace. I received the message:

"This dashboard contains Power BI Pro content. Only users that have Power BI Pro will have access to it"

 

I confirmed my fears by publishing the simplest of reports which is 100% non-pro content. There have been a few other mentions of it on the forum in the past couple of hours, but I thought I'd create an official post. 

 

1st sharing was disabled from Group Workspaces to non-pro users. Surely Microsoft has accidentally disabled ALL sharing for non-pro users ? If not, you can imagine the uproar.

 

Is anybody else facing the same problem ? 

 

Power BI clearly states that we are able to share personal dashboards with non-pro users. 

Error.PNG

 

 

Status: Delivered

I have been trying to roll out Power BI to my organisation (it is a rather large organisation with many users all over the country) whilst our Central IT department is working through upgrading us to Power BI Premium and I have discovered a bug that the Microsoft Customer Service person who is helping me claims is by design.

 

Bug that was discovered: When I share a report via a dashboard to a new Power BI user (doesn't already have a Pro Licenses) and the user signs up for a Pro Trial to see my report, I need to cancel the invite and resend it.

 

Steps to reproduce:

  1. Create a report and publish it to a group
  2. Create a dashboard for the report and share it with a user who is not a Pro user yet
  3. Have your user sign up for the Power BI Pro Trial
  4. User will get "Sorry, we couldn't find that report" error

 

The workaround:

  1. After your user signs up for a Power BI Pro Trial (step 3 in the above), go to your dashboard and click "Cancel Invite"
  2. Resend the invite to your user

 

This works, however, it is a bug and it is creating a lot of extra work for the people who are producing / sharing reports as well as frustrations from our end users.

 

If you could fix this or assure that this will be fixed when we move to Premium, that would be really helpful in getting our users to adapt to Power BI as their new reporting tool.

 

Thank you,

-Winnie

Hi all,

 

I have a client who is on the latest release of Power Bi Desktop (v 2.46.4732.721), although this issue also occurs on the previous version (2.46.4732.581). When they create a new measure on top of a live tabular model connection and set the formatting, the formatting only persists for that Power BI Desktop session. When they save the file and close and reopen, the formatting reverts back to the default, which is especially unreadable for percentages and currency. Is this fixable? Thanks!

Status: Accepted

The drillthrough functionality seems to have caused one big issue for me.  I have multiple reports at a summary level with multiple slicers on each page and a detail level report with even more slicers.  I have setup the drillthrough functionality to work with my 'State' slicer.  When I use the drillthrough functionality to get to the detailed report, it works properly and filters my detailed report.  HOWEVER, the other pages in my report now have the state filter set as well, but there is NO way to remove it.  For example, I drilled on 'NY' and then all of my pages now only show NY as the only value in my list of values.  The only solution seems to be to remove or clear all of the other filters (even though all of them show 'All') on the page.  

 

I will try to replicate this, but I think there is a bug as this PBIX was working very well prior to implementing drillthrough.

Status: Needs Info

When I use the drillthrough functionality to drill into a detailed report, it properly filters my detailed report.  However, the slicer for the same field does not display the value that I selected and shows 'All'.  The only way to clear the filter is to open up the filter pane and deselect the value I drilled on.  Typically, the users will see the filtered values in the slicers and they don't have to expand the filters pane.  

 

Please let me know if this is a bug or if this is the intended functionality.  If it's intended, I think it should be updated.  

Status: Delivered

Bug: Table.ReplaceValue kills all column types

Status: Accepted
by ImkeF Super Contributor on ‎08-03-2017 11:01 AM

When used in combination with "each" in the second argument, Table.ReplaceValue kills all existing column types (sets them back to any). Please fix:

 

https://social.technet.microsoft.com/Forums/en-US/c3f118eb-acb2-4e36-a398-d6c3759e795f/tablereplacev...

Status: Accepted

Analyze in Excel / CubeValue not working

Status: Needs Info
by nbailey Frequent Visitor on ‎09-07-2017 01:05 PM

Starting yesterday, none of my Excel reports that I setup using CubeValue formulas are able to refresh.  Occasionally some of the cells will return values, but most of the time all of the cells just [eventually] come back with a #N/A error.  I have some Pivot Tables in the same reports using the same ODC connection and those refresh/update without any issues, it is just the CubeValue formulas that are impacted.  If I edit the formula in an individual cell (i.e. start adding a new filter variable), it reads the data model without issue (suggesting fields to complete what I am typing), and most of the time after editing that individual cell will return an actual value.  Same thing happens if I create a second ODC connection (to the same model) - if I repoint an individual cell to the new ODC connection, I get a value.  However if I try to do a find/replace on the Worksheet with the new ODC Connection, the same issue occurs - long amount of spinning with no values being returned.

 

Since it's clearly not a connection issue, I'm not even sure where to start troubleshooting?  I found a short thread in the Community forum referencing the same issue from a couple of other users, but no resolution.  It appears to be random and intermittent based on what the other users have written.

 

Community Thread:

https://community.powerbi.com/t5/Issues/Analyze-In-Excel-N-A-Values/idi-p/187339

Status: Needs Info

Search Box on Slicer Missing

Status: Accepted
by MikeThibs Regular Visitor on ‎01-05-2017 04:39 PM

Hello,

     The Search Box on the Slicer Visualization seems to have a bug when a PBIX file is loaded to the Power BI Service. This issue is affecting the drop-down format of a Slicer. Also it seems to only affect Slicers with a larger amount of items. When there are 2 or 3 items in the slicer the search box will appear however if there are 20 plus or more items it is not working. I've tried several different browsers, so I don't believe that is the issue. Below are screenshot showing the search box has been enabled and the missing search box when you select the drop down. Please help!!! We're on the verge of rolling out hundreds of new Power BI accounts and this is a serious issue when you have large slicer needs.

 Search On.jpgSearch Not Showing.jpg

 

 

Status: Accepted

Hello,

 

Our report - which is based on MY SQL Queries - seems to experience difficulties regarding the scheduled refresh. This is the error that we got back: 

If anyone can offer any advice or provide further information that would be highly appreciatedGateway Refresh ErrorGateway Refresh Error

Status: Needs Info

We utilize out-of-tenant shared dashboards extensively and are aware of the change made yesterday to the Power BI Free service.  We've had our clients activate their free Pro trial and are using a Pro account to share out-of-tenant.

 

However, even after activation, out-of-tenant shared dashboard links are not working.  They just display the Power BI logo and it blinks continuously.  

 

I tried going to the dashboard as the owner (again, logged into a Pro account), clicking "Stop Sharing" on the dashboard and re-sharing with the client (who had activated the Pro trial) and still, they see the blinking Power BI logo.

 

Using developer tools in the browser, I see a failed XMLHttpRequest:

URL: https://wabi-us-north-central-redirect.analysis.windows.net/powerbi/invitation/dashboards/invitation...
Method: HTTPS POST

Error code: 401 (Unauthorized)

 

Looks like yesterday's switch-over broke out-of-tenant dashboards.  This seems to happen all the time, out-of-tenant sharing is very unstable and doesn't seem to be tested well enough when changes are made to the Power BI Service.  I've opened many other tickets reflecting these issues on this site.

Please let me know if you need any more details, all of our clients are dead in the water right now (even after activating the Pro trial).  @v-haibl-msft - you've been very helpful in the past on keeping me informed & updated on issues like this so wanted to proactively make you aware what's happening here.

 

Regards,

Caleb Blanton

Status: Accepted

Issues in connecting to tabular model

Status: Accepted
by Wybie_TPG Visitor on ‎09-05-2017 07:51 AM

I'm encountering issues when I try to connect PBIDesktop(2.49.4831.521(x64)) or import data from our Tabular SSAS model (SQL server 2016 standard edition).

When I connect live to the model the project works fine for a little while, but after a few clicks it start giving the following error:


Error Message:
An unexpected exception occurred.

OData Error Message:
Failed to execute the DAX query.

When I want to import data it works fine for most measures and dimensions, but for some measures I get an error:

 

DataSource.Error: AnalysisServices: An unexpected exception occurred.
Details:
    DataSourceKind=AnalysisServices
    DataSourcePath=172.xxx.xxx.xx;CubeNameXX

 

The query that it tries to execute is = Cube.Transform(#"CubeNameXX",
        {
            {Cube.AddMeasureColumn, "Amount", "[Measures].[Amount]"}
        })

 

The srange thing is that we also use this measures in SSRS, without any issues, but after the PBI connection SSR Sdoesn't work either until we delete and recreate the measures. Than SSRS work fine, untill we again use PBI and the issue starts again.

 

I'm out of ideas how to solve this issue, does anyone encountered such issues befor or have ideas to solve it?

 

Many thanks!

Status: Accepted

All of the sudden (perhaps after the April 2017 update?), any dashboards we share out-of-tenant from Power BI Web are missing the tabs along the bottom to switch between the different reports in that dashboard.  

We tested with in-tenant sharing and it works fine - only an issue when shared externally.   

 

We tried creating a new dashboard from scratch with 2 simple tabs and published out of tenant - same issue.  All tabs are just gone!  

 

 

By the way, I did see a similar thread (http://community.powerbi.com/t5/Issues/Report-tabs-missing-on-shared-dashboard/idi-p/150884) but it seems too different from what we're experiencing.  In that case, 3 out of 5 tabs disappeared and it happened when shared internally or externally.  Our issue happens only when sharing externally.  Perhaps the same issue.

 

We noticed a warning on the client side that only appears when looking at it out-of-tenant - this may be related to what's happening or perhaps not:

/13.0.1700.1783/scripts/ai.0.js:1 AI: USRACT_StringValueTooLong message:"string value is too long. It has been truncated to 1024 characters." props:"{value:Error: [$injector:unpr]

http://errors.angularjs.org/1.5.9/$injector/unpr?p0=%24templateCacheProvider%20%3C-%20%24templateCac... at

https://app.powerbi.com/13.0.1700.1783/scripts/powerbiportal.dependencies.externals.bundle.min.js:25... at

https://app.powerbi.com/13.0.1700.1783/scripts/powerbiportal.dependencies.externals.bundle.min.js:62... at Object.d [as get]

(https://app.powerbi.com/13.0.1700.1783/scripts/powerbiportal.dependencies.externals.bundle.min.js:60... at

https://app.powerbi.com/13.0.1700.1783/scripts/powerbiportal.dependencies.externals.bundle.min.js:62... at d

(https://app.powerbi.com/13.0.1700.1783/scripts/powerbiportal.dependencies.externals.bundle.min.js:60... at e

(https://app.powerbi.com/13.0.1700.1783/scripts/powerbiportal.dependencies.externals.bundle.min.js:60... at Object.invoke

(https://app.powerbi.com/13.0.1700.1783/scripts/powerbiportal.dependencies.externals.bundle.min.js:60... at https://app.powerbi.com/13.0.1700.1783/scripts/powerbiportal.depen}"

u.warnToConsole @ /13.0.1700.1783/scripts/ai.0.js:1

There seems to be other issues with PBI of late (data failed to load when first opening a dashboard) so perhaps the tabs missing are part of a bigger problem.  However, for now that is the problem that is getting in the way of us delivering analytics to our clients.

 

Any help would be greatly appreciated!

 

 

-Caleb

 

P.S. We had another issue with out-of-tenant dashboards where the Export Data just didn't work for them.  It was eventually fixed, but I'm beginning to wonder whether or not out-of-tenant sharing is the red-headed-stepchild of the PBI feature set.  It could certainly use a little more testing with each release...while I love the pace of innovation of PBI this isn't the first time that something in this dark, scary corner of PBI was broken and our clients were impacted.  Food for thought if this post happens to cross into any PBI QA LOS.

 

Status: Delivered

In desktop and embedded the tooltip when hovering over a field in table or matrix is persistent.

When the report is published to .com the tip fades after 5 seconds.

 

Its particularly useful on wrapped text fields in the table to have the popup tip persist so the text can be read.

 

Can behaviour be made consistent, preferably permanent until focus changes, ideally configurable.

 

thanks

M.

Status: Accepted
Idea Statuses