Hi!   I'm using the new dual axis line chart functionality introduced in the last months, but I'm not able to customize data labels. While it works for the labels of all variables (in Y1 and Y2), when I try to customize series selecting just one variable and changing the data label settings (text size/color, background color, etc.), it immediately switches back to default.   Are you experiencing the same issue?   Thank you in advance.   ... View more

I have created a daily bar graph for one month on my page. It formats perfectly in the desktop (whether 1 bar or 3 bars displayed below). I can't figure out why it displays differently after I pin to the dashboard. I've tried reformatting the single graph pinned to the dashboard apart from the page and simply displaying less data. Nothing seems to work. Help!   Current Online Dashboard display: Desired/Actual Display (on desktop):   ... View more

  This is what I see a few minutes after opening a file with data in it (imported mode). March update. And yes, I turned on the metadata preview feature...   ... View more

I am having an issue where within the PBI report builder IDE my paginated report works as intended. However, when I publish the report to the service through my gateway I is not pulling back any records. I am using and oracle DB connection. Has anyone experienced this issue, and have a solution for it? Any guidence would be appreciated. ... View more

Sorry PowerBI team but I have to say the experience is atrocious and this is going to be a bit of a rant.....  I'm just spent the last 5 hours fighting to try and do something which should be simple.... publish a report and then periodically update the data from a script running on my local machine.   Issues:   the "new look" UI doesn't seem to actually notice gateways until you refresh the entire page.  the "new look" UI Test Connection button doesn't actually do anything  the "scheduled refresh dialog" confusing claims that I don't have a personal gateway, and despite setting up a folder datasource seems to want to get permissions for individual files within that folder then promptly throws a useless "sorry Dave I can't do that" error when I try to connect to them.   Ok so then I give up on gateways and decide to just use OneDrive (Business)...  PowerBi desktop seems too dumb to realise that if I get data from a csv in a local onedrive folder, it should really be using a onedrive URL  so then I use "Web" datasource and and run into the issue where Desktop just claims it can't get access. (Fixed eventually after finding a *years-old* problem report that suggest I can go to Edit-queries and fiddle the data source to ask me to enter my credentials again) Here's a suggestion... the web version has an idiot-proof "datasource from OneDrive" button.  Did it not occur to you to add one in the Desktop app to match it? 😞 Hooray - now I can create a report and publish it.  This bit actually works.  Now to test that data sync works....  Fire up excel, open the synced version of the csv , make a few changes, save again (after suffering Excel's incessant complaints that it really doesn't like CSVs)  Wait a bit... hmm no sync.... find the "refresh now" button in datasets and hit it.  Wait some more.... no sync.  Eventually come across this link https://docs.microsoft.com/en-us/power-bi/refresh-data (amongst what seems like a dozen similar but subtly different takes on PowerBi data synchronisation...)   which contains this gem...    Important Be cautious in how you handle file management on OneDrive. When you set a OneDrive file as the data source, Power BI references the item ID of the file when it performs the refresh, which can cause issues in some scenarios. Consider the scenario where you have a master file A and a production copy of that file B, and you configure OneDrive refresh for file B. If you then copy file A over file B, the copy operation deletes the old file B and creates a new file B with a different item ID, which breaks OneDrive refresh. You should instead upload and replace file B, which keeps the same item ID.      So basically, any time I copy over my locally synced file or simply recreate it using a script, I'm actually getting a new file with a different ID and PowerBi can't cope with that.  Seriously.... wth?  Did you stop to ask yourself how that was supposed to work for people rebuilding their spreadsheets from scratch and xcopying them across to OneDrive?  Here's another suggestion .... by all means use the ID but if you can't resolve that, look for a file with the same path as the one that disappeared!  That really can't be too hard right? 😉    ... edit after further investigation...   Hurrah - it appears this is wrong but the fact it isn't is obscured by the fact that the "Refresh Now" action besides the dataset doesn't actually refresh immediately but instead has a lag of around 5 minutes between the time that my PC thinks the file has synced and the time that changes reach the web app..    So in summary, a "normal" file operation to rewrite/copy over the file in your local OneDrive folder _is_ effective but you need to be patient to see the changes....   So at this stage I've pretty much given up for the day (though will come back tomorrow to figure out how I might copy new data to the file without trashing the ID) but I'll just say you managed to convert someone who was initially excited about the possibility of using PowerBi shared reports to someone who regards the whole experience as thoroughly unpleasant.    One final suggestion (a serious one) ....  PowerBI is an application I want to love - it can really do some impressive stuff  (I generally use it for local data exploration) but so much of the experience is an exercise in frustration - probably more so than any other MS product I've used.   I'd genuinely urge you to conduct some user-studies and watch people trying to use this thing for real to perform tasks they don't already know how to do.  I think you might find it eye-opening....     ... View more

when publishing reports from the desktop to the service that include the Azure Marketplace as a source (i.e. Date Table), credentials are invalid and cannot be updated preventing setting up a scheduled refresh or successfully completing a manual refresh. This error is only occuring for reports recently published to the service as reports with the Azure Marketplace as a source that were already published to the service and had an exisitng refresh schedule set have not been impacted. ... View more

Hi,   I am sharing a dashboard with RLS to guest users outside of our tenant. When I tested it on one of my own guest account, I see the user metric report is automatically shared with the dashboard I share (see print screen). Guest users can now see all usage data, this seems like a bug. I only want the members of the Workspace to be able to see the usage details, not the viewers and certainly not the guest viewer.     All input is much appreciated.   Kind Regards, Linv ... View more

There is a wrong tooltip translation on Visualizations pane in Power BI Desktop and Power BI Service. “형식”(Format) tooltip text should be “서식”.   ... View more

I Have a dashboard that under gateway connection is using the (power Bi - personal) data gateway there is no data source connections listed when i use the drop down menu, but the report and dashboard are set to refresh every evening and do so with no issues. I have uploaded a new dashboard that uses the same data sources, but every time i try to refresh I get the message below. I am also a power Bi Pro user and every time I try to log a tick I am getting a bad request error message. PLEASE HELP !!!! Something went wrong. There was an error when processing the data in the dataset. Please try again later or contact support. If you contact support, please provide these details. Data source type Processing errorThe credential stored in the cloud is missing. Cluster URIWABI-NORTH-EUROPE-redirect.analysis.windows.net Activity ID5f059a0c-dabb-4e8c-b498-b9beaaed25fa Request ID0c3b679a-7943-8e91-7cad-4f9dd751c426 Time2016-12-13 11:00:58Z ... View more

Hi all,   A bit of context, I have published a PowerBI report and have shared it across to my team via Teams. For the report, I have been using an Excel file as the dataset. I have set it to autorefresh every day at midnight. So far, the auto refresh has been working perfectly for the past 2 months or so. However, today I got an email notification notifying me that the refresh failed. This was the error displayed:   Web.Contents failed to get contents from 'https://redactedhisonpurpose.sharepoint.com/sites/DealPipelineforDirectPE/_api/web/getfilebyserverrelativeurl('/sites/DealPipelineforDirectPE/Shared%20Documents/PE%20Direct%20Deal%20Pipeline.xlsx')/$value' (404): Not Found   I thought that it was weird, as it seems to me that the PowerBI service was not to able to find the file. I tried manually going to the url via a web browser, and was met with a 404: Not Found Error. I thought this was weird, as it has never ran into this kind of issue before.    The next step in troubleshooting was me trying to replace the dataset manually. I went into the report via PowerBI desktop and attempted to change source for my dataset. I inserted a new sharepoint url (have made sure that the url can be found) and tried to change it, but I was met with this error     It says that it was not able to authenticate based on my credentials. I am positive that my Office365 email and password are absolutely correct. I am not sure why I am getting this error.   I appreciate any help in sorting this issue. Many thanks in advance! ... View more

Hi,   SynaptiQ is a Photovoltaics monitoring software and we are working on the Power BI solution to provide to our clients a new way for them to access their data and create new user-friendly dashboards. For this, we need datasets that are refreshed automatically and daily. As the free version account doesn’t include the gateway + automatic refresh, we made a workaround and used Excel file in OneDrive that hosted the SQL queries that we wanted.   However, this solution was not really convenient because we couldn’t create groups to separate clients, we couldn’t use the PowerBI desktop to have standard Dashboard to share to different clients easily and we couldn’t change the dataset without deleting it on PowerBI services and putting it back with the new SQL queries in the Excel file.   We decided thus to sign up for the PRO version (account is sqreport@3e.eu) to have access to the group feature and the gateway + automatic refresh.    Unfortunately, when we create a dashboard and we want to share it to some client with free PowerBI account, we cannot… Because we use PowerBI Pro features.   So now the question is: what can we do to provide to the client (that has a Free PowerBI account) a standard dashboard template designed in PowerBI Desktop?   We see a real interest from dozens of clients wanting a BI solution for their data and this would be a good first impression if we could provide to them a simple standard dashboard for free.   Thanks for your help.   Kind regards, ... View more

I wanted to list the issue here even though it was asked Monday in the forum. It doesn't appear that it was actually answered though since I can't download an old version of PowerBi to test it. I need the authorization in order to pull data from the Airtable API. Is there something else I can use or is this a bug?    https://community.powerbi.com/t5/Desktop/REST-API-web-data-source-Authentication-Header-is-gone/m-p/1009630#M478188 ... View more

I am using the Gantt 2.2.3 and I need the legend to distiguish between two types of schedule we use for our projects (BL and Actual) The legend works fine (ish) until the start dates for the two categories in legend are the same. Here is what I mean:  in the 1. case it works just fine and showing the BL schedule (yellow) and Actual Schedule (blue) correctly - in this case both, the start and the finish date for the BL and Actual Schedule are different.   3. case is a bit problematic, but does not display faulty view at least: in this case start and finish dates for Actual and Baseline Schedule are the same. (this becomes a bit of a problem when a project does not have Baseline Schedule assigned, then it displays them the same - seeming that also the project without BL schedule has BL schedule and the dates are the same as in actual schedule...) However this is not the biggest problem, but  would be nice if it could show the line under "shadow" showing that the BL and Actual dates are the same.   THE PROBLEM COMES IN EXAMPLE 2: here the start of BL and actual schedule is the same, BUT the finish is different, but the legend is not showing that! This is a very big problem as it shows faulty data.  (just an example dates)   I have build this view with another gantt chart - Gantt Chart byt MAQ Software and is shows the data correctly and also many testing has been done and there is no mistake in the data.          ... View more

Hi, I am hoping you can help me resolve an issue I have noticed today.  I am using a guage which measures volume until yesterday Vs an expected forecast until yesterday (Target = CALCULATE(sum(Forecast[Forecast]),Forecast[date]<Today()) .  The desktop is updating ok with revised target updated as day of month progresses.  But when i publish, it continues showing the day before yesterdays target on dashboard (instead of yesterdays as it shows on desktop). If I change the target formulae to include today (<=Today()) and then although it shows 1 day extra target on power BI desktop, but shows correct on published dashboard as (< Today()). How can I fix this? Thanks for your assistance. [date]   ... View more

Hi all,   I have 6 datasets in my powerBi service. I have set up auto refresh of all thesedatasets via a personal gateway. Recently I notice that some of my datasets not refreshed as scheduled. Those dataset are quite big reports( 0.6 GB , 0.5GB and 0.38 GB) and small reports refresh without any problem. These datasets don't refresh at same time  i have spread them to give enough time gap for refresh each dataset assuming that if all reshresh same time could coulf heavy data traffics. I checked my gate way is alway online and activated. I have upgraded gateway and poweBI desktop to see whether that would fix the problem. But datasets refresh still fails. Error message I get was,   This is really headache for me. Please can anyone help me to get rip of this issue   Thanks ... View more

The problem is that I will re-publish the dataset with the replacement of the version preponderance. After that I update the data set, the update is successful. But going into the report, I do not see the outdated data, and not updated. When you refresh the page, clear the cache, exit the browser, nothing changes. Only deleting helps, and then publishing the dataset again. After that, the data in the visualization is updated automatically, but it is very inconvenient. Help me please. ... View more