I am receiving this cryptic error when trying to update a Desktop (pbix) dataset using the Power BI server (on a personal gateway). The pbix file contains connections to ODBC data merged with SharePoint (Excel) files. Some of the ODBC tables are retrieved and formatted using a table-valued Power Query function. All of this works fine in Power BI Desktop but I receive this weird error in the Power BI service.   Any ideas?       Full error details:   Data source type:   Processing error: We cannot convert the value "[Function]" to type Function. Cluster URI: WABI-WEST-US-redirect.analysis.windows.net Activity ID: c90096fc-14bc-4590-8c87-89155570b7a6 Request ID: 6e7a151d-501c-69c7-787d-77ecf4d46df0 Time: 2017-01-05 20:27:49Z ... View more

I create a report on Power BI Desktop with a Project Online Odata feed as data source. I can connect and update from PBI Desktop without any problems.   However, when i publish it to Power BI, and go to Schedule Refresh, i get this error under Data Source Credentials: When i try to edit the credentials, i set to OAuth2 and enter the correct credentials but i got the error below:    I'm pretty sute that the correct authentication method to Odata feed is OAuth2, but i tried the other methods and got the same error    I'm not able to update the credentials in any situation. I've tryied to republish the reports, create a new one from scratch but i got always the same situation.   Best Regards, Alessandro ... View more

    I have an odata data source created using PowBI desktop with organizational acount authentication choosen. After publishing my dataset to PBI service I'd like to configure my data source for scheduled refresh but after publishing the source cannot be scheduled becuse credentials are not filled:               When trying to edit my credentials, OAuth option is no longer showing so my credentials cannot be entered:               ... View more

Hi all,   I have just notived the when creating Hierarchy Slicer's in PBI they don't seem to populate. They do work however within PBI desktop. I believe this same isues happened back in December sometime.   Hope you can help.   Thanks,   Stu ... View more

Ever since I started to use Power BI, I have this refresh issue as below:   Microsoft.Mashup.Engine1.Library.Resources.HttpResource: Request failed: OData Version: 3 and 4, Error: The remote server returned an error: (500) Internal Server Error. (The request uses too many resources.) OData Version: 3, Error: The remote server returned an error: (500) Internal Server Error. (The request uses too many resources.) Next refresh for AnnualLeaveCount_TimeOffBal2 is scheduled for 01/05/2017 05:32:00.           Microsoft.Mashup.Engine1.Library.Resources.HttpResource: Request failed: OData     It is confusing that the refresh sometimes will succeed while at most times fail. Even if I click on" Refresh Now" at times it will take me 2 to 3 tries to succeed.   May I know why this happens and how can I solve it? Thanks ... View more

I'm starting a new post because I can't find any existing posts that have quite the same problem, but it is very similar to the problems we've been seeing here since November. Power bi service, mostly newer pbix files, using Azure SQL sources, so no gateway. Credentials (basic, not OAuth2) will stick for a refresh or two then drop. I've had to reenter them almost daily, for a few weeks now. Once reentered on one file, the other files in the same group will also work, until the creds are dropped again. And for some reason, the error message suggests I'm using OAuth2 creds, but these files have never had an OAuth2 source, And there are no files in the group using OAuth2 either. There is no problem refreshing the desktop files.  Thanks, Vincent ... View more

I am experiencing an issue where the ISO coutry code for Nigeria (NGA) is being located in the middle of Russia.  Based on what I have read in the help documentation the 3-letter ISO code is the most reliable way to map country locations.  All other African ISO codes I am using work accurately with this one exception.   Am I missing something?  Is there any easy way to resolve this, or perhaps a temporary work-around?       ... View more

Hi,    I'm posting this in the issues topic, since I can't seem to figure out why I have this issue, but I keep having this. Please see the topic here:   https://community.powerbi.com/t5/Service/Data-not-shown-in-visualization/m-p/106493#M17380     Summary: - There are two clustered column visualizations in my report, one with categories, one with subcategories. - When clicking category A in visualization 1, the appropriate subcategory data is shown in visualization 2 - When clicking category B in visualization 1, for a particular subcategory, the data is shown as 0 (zero) in visualization 2 * When using import mode, the data IS shown correctly, so it's DirectQuery related (I use an "on-premise" SQL Server via Gateway) * The issue also occurs with the Pie chart, (100% and normal) Stacked Bar chart and Funnel visualization * The issue does NOT occur with the Area Chart, Multi-Row, Table, Line Chart   If I can help by providing more info, please let me know! ... View more

Hi Folks,   We have been seeing frequent issues with the scheduled data refresh in Power Bi online. Our data is refreshed directly from Azure Sql Database and we see this issue atleast 5-6 times a week (sometimes more).  The issue is more frequent for the report "MucpViewAndClickTracking" which has the largest amount of data compared to our other reports.    Failure Error msg : the last refresh attempt failed because of an internal service error.   Other data Technical Information: Activity Id: 02f891d3-1fbc-400e-ae56-067c67e47608 Request Id: 5c6b2b09-f221-488b-ab43-01c5fe509286 Cluster Name: DF-MSIT-SCUS-redirect.analysis.windows.net Refresh Start Time: 12/29/2016 20:38:11Z Refresh End Time: 12/29/2016 22:00:12Z   Let me know if you need more information.  ... View more

Perhaps someone can solve this mystery... I have a simple table pinned to a dashboard showing current year, budgeted & prior year 'units'. The mobile/web dashboard and desktop/web report all display the correct amounts. HOWEVER, when accessing the report table via clicking from the mobile dashboard (sorry for the screenshot truncation), the report shows different amounts:   Here's what I've tried (so far) with no luck: trashed/re-pinned table to dashboard quit all open mobile apps restarted iPhone refreshed dashboard tiles (from web & phone) refreshed data from desktop & re-published re-checked joins confirmed enterprise gateway functioning properly (data is coming from SQL Server 2012)   I haven't ruled out human error yet , but is anyone aware of a bug?   Thanks, DannyD ... View more

Hi all. Been playing around with BI for a awhile now and am attempting to use it to generate a 'printable' status report for a client. While that in of itself has been a challenge I have come across a fairly obvious bug and was wondering what the status of it being look at, if it currently is at all.   When using the table visualization I am able to do things like conditinal color formating for values, and overall settings like table style alternating. These all look great, but I have some clients who still prefer paper and will want to print it out. This is where the 'bug' kicks in.   For some reason it's ignoring most if not all of the color output on the visualization when it's being printed. It doesn't matter if I print to our color printer, to PDF, or even out to One Note. In all cases it looses the coloring. I do know that it is attempting some of it as the one image i'll show you can see the rows have a slight intensity difference between them, but not the grey color banding from the table setting.   So here are the list of things I see currently not work: 1. I couldn't turn the column headers off so I changed them to white. One the screen they are invisible, but when you do the print out you can see them (e.g. TaskName right under the Milestone text box). 2. Color banding doesn't seem to work at all other than changing the darkness of the text slightly. 3. Finally in the last column 'Health Values' or Status-Color code all you see are the numbers which i'm using to generate my conditional formating on.   Any feedback would be greatly appreciated.     ... View more

On a combo chart, when viewing data points under See Data feature, values for lines are not shown. The line values of Contact Rate and Outbound Contact Rate as missing from the data view.   ... View more

recieved error of "Bad IL Range" when trying to update data from MYSQL database. nothing was changed on the microsoft bi reports or the mysql server and untill today it updated just fine with no errors. Can someone point me in the right direction of what needs to be done to fix this? ... View more

Hello Team,   I have one table with couple of rows and define total at the bottom,but it is not showing correct numbers and surprisngly when i export data into csv and used autosum over there ,it looks correct. Attached images for both the option.     ... View more

Hi,     I've a report that contains several slicers with the dropdown list option selected. In PBI Desktop its possible to activate a search box on these slicers, but, on the PBI Online the search box desappears... Is that a known bug? If it is, is there an estimative on when it will be fixed?   PBI DESKTOP (with search box) PBI ONLINE (search box option selected) PBI ONLINE (no search box available) Beste regards, Rafael ... View more

Hi,   I have a slicer, set as a drop down. The search function does not appear to be available. This is only a problem when the report has been published. It is available when in Power BI Desktop.    Slicer in PBI Desktop As you can see, the search box is at the top of the items available within the slicer PBI Online - Search  There is a gold/yellow marker on the Search item within the menu.  PBI Online - No Search Box I expected to see the search box above the items, like PBI desktop.   I have tested different browsers, Chrome & IE 11.  Is this a known bug?   Regards, Simon ... View more

Hi,   Im unable to create Group Workspaces and seeing the error below. I have gone through similar issues which have been raised in this community.   However, there are other points I needed to bring in: 1. On https://app.powerbi.com/groups/me/managestorage  I see my account shows it as "Pro user" with storage space of 10GB 2. On https://portal.office.com/account/#subscriptions I see details as below   * So am I a Pro User or a free user? * Am I permitted to create Group Workspaces? * How should I raise a ticket with microsoft?   Thanks in advance ... View more

We need to have Unit of Money for Indian Customer. All the banks and financial institutions use these units. These are as follows Lakhs  the format is  (INR 1,00,000)  - Has grouping for 5 zeros in the format shown. Crores the format is  (INR 1,00,00,000)  - Has grouping for 7 zeros in the format shown. For all official reporting & regulatory reporting this format is user. All our clients today need to create custom columns for these values. Its big pain and show stopper for better adoptions and consumption.   It would be great if we have Excel like formating for number in all the visuals and have Lakhs & Crores in Display Units. ... View more