Hello,    Is anyone else having issues with date parameters in PowerBi Paginated Report?   We have tried this in Chrome and Edge - changing a date parameter using the calendar date picker. The picker seems unresponsive to any actions once there is a date filled in. We couldn't change the month or year on it.    We can change the date via typing in the date value, just the picker is not working.    Any ideas on how to fix this or why it is happening?   Thanks! ... View more

Not publishing to the app by default is much more efficient.  when publishing test files, one must remember to go back and exclude them from the app.  This can result in major problems with files under test being published to customers.  If the service defaulted to NOT including publiushed items in the app (or even gave an option?) a lot of this heartache could be avoided.  It's a much lower risk problem not publishing a report to an audience than reporting the wrong thing. ... View more

I think the new Power BI deployment pipelines UI/UX that removed the colorful icons for reports, datasets, and dashboards is harder to use. The new "line drawing" icons require more attention to differentiate between the different types of assets. Could you add colors to the line drawing icons? ... View more

At some point within the last two hours, the Direct Query portion of our composite model stopped working.  See screenshot of error.   ... View more

Dear Microsoft Team,   I hope this message finds you well. I am writing to report a bug that I discovered yesterday in the Waterfall chart's total column within the Power BI service. Upon reviewing several dashboards I've created, I noticed that the total column of the Waterfall chart is not displaying the bar and data label as expected. Instead, I can only see the column labeled as "Total" along with a small colored line at the end of the bar. This discrepancy is not observed when viewing the same dashboard within the Power BI desktop application, where everything appears to function correctly. I kindly request your assistance in resolving this issue as soon as possible to ensure the accurate representation of data in our reports.   Thank you for your attention to this matter. ... View more

The DataMart has been working in the main, although automated refreshes have stopped a few days ago. Now I can't even refresh manually and am getting the following error.    Error: undefinedErrorMessage=The current operation was canceled because one or more operations failed..HttpStatusCode=0.   This means all the work that we've done to establish this new process using PowerBI risks being compromised. If we can't fix this, then we may have to abandon it, which would not be great.  ... View more

Perhaps you could restructure this forum.        idea != issue   idea : a thought or suggestion as to a possible course of action.   while an issue means:   an important topic or problem for debate or discussion. ... View more

Hello there,  I am hoping to get some support. I am puzzled with the error I started seeing since last week, 1st August. My model refreshes seamlessly in PowerBI desktop, but after publishing to Pro Workspace it fails to refresh, both when trigered manually or via scheduled refresh. What is strange, every time I refresh it refers to a different SharePoint hosted excel file as a source of problem.    All files are unchanged - in structure and names. Sharepoint access remains unchanged as well. Credentials are correctly provided too.    Any support or guidance will be much appreciated.    Data source error: DataSource.Error: <ccon>Web.Contents failed to get contents from 'https://xxxxxx.sharepoint.com/teams/SD-Collaboration/_api/web/lists/getbyid('d2c701f2-8b0b-4f2c-89f8-74e8ae1cf9ec')/RenderListDataAsStream?Paged=TRUE&p_SortBehavior=0&p_ID=500602&ix_Paged=TRUE&ix_ID=500602&PageFirstRow=70001' (429): . DataSourceKind = SharePoint. DataSourcePath = https://xxxxxx.sharepoint.com/teams/SD-Collaboration. Url = https://xxxxxx.sharepoint.com/teams/SD-Collaboration/_api/web/lists/getbyid('d2c701f2-8b0b-4f2c-89f8-74e8ae1cf9ec')/RenderListDataAsStream?Paged=TRUE&p_SortBehavior=0&p_ID=500602&ix_Paged=TRUE&ix_ID=500602&PageFirstRow=70001. </ccon>. The exception was raised by the IDbCommand interface. Table: sp_COVID-MasterList. Cluster URI: WABI-NORTH-EUROPE-J-PRIMARY-redirect.analysis.windows.net Activity ID: 013724c9-4519-4b64-a8b7-d6ee099d5a89 Request ID: bb445de9-d223-edda-1172-d5a71ef29ecb Time: 2022-09-07 09:10:59Z ... View more

Hello    I have just installed the Feb 2018 update for Power Bi and i am no longer able to open any .pbix files. I recieve the message;    Unable to open document; we weren't able to restore saved database to the model   There is a current forum open - http://community.powerbi.com/t5/Desktop/Unable-to-open-document-we-weren-t-able-to-restore-saved/m-p/352734#M158674    I have followed some previous blogs of uninstalling/reinstalling, and the error still remains. Can anyone help please?   Thanks ... View more

I believe this issue coincides with the June update. 2 days ago PBI Desktop stopped allowing me to refresh data and produced the following error: JSON integer 4294967295 is too large or small for an Int32. Path '[4].MaxLength', line 1, position 1697. I tried other reports that access the same database and they also error out with this message - the position information changes. So I opened a NEW file on Desktop and attempted to bring down some tables from the database and it errors out with the same message. Everything was working fine until the June update hit. Strangely, the published report on service being accessed by multiple individuals is still running the Scheduled Refreshes and working. It is only an issue on Desktop.  I have other reports - accessing data on customers sharepoint sites and excel datasets and all are working properly. It's a problem because I can't do any work for this customer. Has anyone else experienced this issue. ... View more

Hi Team,   While signing into power bi desktop using our organizational account, we are facing the "we have encountered error while trying to signin, Missing Wamcampat_id_token in WAM case".   We are using the latest version of power bi desktop (June 2023).   Kindly help resolve the issue.   Thanks, Sabari ... View more

Power BI users can create subscriptions in workspace apps and do not require permissions in the workspace. However, they are currently unable to see a list of these subscriptions anywhere in the service. Please update the Preferences -> "Power BI subscriptions" list view to display all subscriptions created by the user, regardless of their access rights. Alternatively, update the list view to display subscriptions created in an app by users who do not have access permissions to the workspace.   Background:  We are a premium capacity with Pro users, and each of our 13 premium workspaces contains hundreds of reporting artifacts (both Power BI dashboards and Paginated Reports). We distribute this content via Apps, and limit access to reporting content via audiences. We do not allow direct access to these workspaces. As a result, none of our users have workspace permissions, and are unable to see their app subscriptions in the Notifications\Power BI Subscriptions list. To view their subscriptions, they must open the subscribed report in the app, and access the Subscription pane to see if they are subscribed.  ... View more

We distribute reports to our users via Apps, and do not allow direct access to the app's workspace. Since none of our users have workspace permissions, they are unable to see their app subscriptions in the Notifications\Power BI Subscriptions list. To view their subscriptions, they must open the subscribed report in the app, and access the Subscription pane to see if they are subscribed.  Please provide users with the ability to see their app subscriptions in the Notification > Power BI subscriptions list. ... View more

Appears to be daylight savings issue according from details established on other peoples posts, listed at end. I am on Australian Eastern Server and my Time Zone is currently AEDT (Melbourne based). When Power BI receives 1st October 2017 it is changing it to 30th September 2017, this obviously is skewing results in Power BI.   I have tried converting it in many forms as a workaround such as directly from text etc yyyymmdd but on preview in desktop the queries window shows correct date, however once in either Power BI desktop or app.powerbi.com the date is appearing as 30 Sept 2017.   Other users encountering this on desktop (is now occuring on app.powerbi.com also), I can confirm that this bug has only recently made its way to app.powerbi.com https://community.powerbi.com/t5/Desktop/Date-Bug-in-Power-BI/td-p/374693 https://community.powerbi.com/t5/Desktop/Incorrect-dates-displaying-in-desktop-but-web-is-fine-when/td-p/343121 https://community.powerbi.com/t5/Desktop/Doesn-t-display-October-1-2017-error/td-p/352957 Also a bit weird that this link for support (http://community.powerbi.com/t5/Service/Where-do-Bug-Reports-go/m-p/16413#M5179) goes to create an idea when i click contact support. Yes I am a pro user so thats not the issue. Perhaps clear instructions for how to lodge a bug, especially when one so critical exists would be helpful. ... View more

We used to be able to test the RLS of multiple reports that shared the same dataset by going into the dataset's options --> Security --> Test as Role to view main report as a specific user.  I could then do to the panel on the left, and select a new report (that shared the same dataset), and it would allow me to view that report as the specified user as well.   However, starting last week, the option to select another report is no longer available. If I click on the workspace icon, it just redirects me to the workspace.   We really need this functionality to be brought back as there is no other way to test RLS for these reports now!     ... View more

I have implemented a static RLS based on office key on a dimension table of a star schema.  The RLS works perfectly in Power BI desktop when I "View as".  The RLS works perfectly fine when I "Test as Role" in the dataset security setting in Power BI service.  However, end users that are impacted by the RLS recieve the following error:   "The query encountered security filters on a table relationship that cannot be reconciled for the current user. Please contact..."   I have changed the RLS multiple time, moving to the different dimension tables that have the appropriate office name or office key.  I have also put the RLS directly on the Fact table & still recieve the same error.     The error began when I published a new version of a previous report, replacing the old version that had basically the same type of RLS in place filtering the data based on office name.  I rebuilt the permissions lists for the new report but not having any luck getting the RSL to show anything.   Current Desktop Software Version: 2.107.683.0 64-bit (July 2022)   Any hep would be appreciated!     **UPDATE**  After additional testing the users impacted are any users that have their names added to multiple locations in the dataset security setting in Power BI service.  If I limit the user to see only one location the data appears but if they are supposed to see multiple offices based on their position the error appears.  Was under the impression that the new July update added multi RLS capabilities. ... View more