help required
34 TopicsCannot expand next hierarchy in Matrix
I found an issue in a visual in Power BI service. I have a hierarchy of Rows: Month -> Week -> FltDate. But I cannot expand to the level of FltDate. And when I try fixing it in edit mode, removing and re-inserting FltDate to the Rows, it works. But when I save the report and reopen it in view mode, everything remains, it cannot be expandedSolved12KViews1like11CommentsIs it not possible to publish reports from your workspace to free users (I am a Pro license)
Hi Bro, Hope you are well. As the title says, do I have to create a new workspace before I can put my report in this new workspace, and then publish this report to free users in the new workspace? Also, can I set the user to come in and open the link to my report to display it full screen? Thanks in advance. BR, SoldierSolved988Views0likes4CommentsNew Scheduled Refresh Plan (An error has occurred. Something went wrong. Please try again later.)
Hi there, I'm trying to add new New Scheduled Refresh Plan but I got this error An error has occurred. Something went wrong. Please try again later. Even I enabled the SQL server agent please anyone can share with me a solution.Solved12KViews0likes7CommentsVisibility of entries on PowerBI Report Builder
Hi All, I have recently downloaded report builder and have connected it to my PowerBI Data. I need to generate a report for each company ID, as shown below: I did this by changing the visibility to the expression =IIf(Fields!CODE.Value = "COMPANY3", false, true) This part is fine because I just want to hide the code but show the data for the rest of the companies. My question is: Is there an easy way to generate this table for company 1 without having to manually change this expression every time? If I want the same report for company 1, is it possible to have a selection tool where I select company 1 and then get the same table but only where company 1's name shows. Thank you for your help900Views0likes2CommentsPowerBI Map How to add click event to navigane other Url.
Hi, If anyone having idea like in PowerBI Map How to add click event to navigane other Url. Actually i am binding locations in the map page when user click on particular bubble in map i need to navigate user to another web side(URL). Please suggest . Thanks Satya881Views0likes1CommentExit from a mobile report
Hi, I'm using the Mobile App to connect to a PBI Report Server on premises. I don't see a possibility to exit from a report. When connecting to the Service, there is a little arrow that opens a navigation list. When connecting to the RS on prem, this arrow is missing. The only way to exit is to shut down the app or to use the back button several / many times (since this navigates through the whole page history until it exits the app. Is it a bug or a feature that this navigation list is missing? ( in case someone wants to suggest the Mobile Apps subforum: I tried it already, and I found the same question from someone, posted 2019 - in both cases someone answered that there should be the arrow opening the navigation list, but it is not there ... https://community.powerbi.com/t5/Mobile-Apps/Navigate-back-to-start-exit-a-report/td-p/2100794 https://community.powerbi.com/t5/Mobile-Apps/power-bi-mobile-app-exit-button-from-the-report/m-p/869497#M5218 ) Thanks and Regards Michael5.6KViews1like12CommentsSharing Power Bi Reports to people without them logging in.
Hi I need help with sharing a Power Bi report externally from my organisation. I want to embed the report on a website and allow people to view it without having to login to a sharepoint site. Any help greatly appreciated.Solved4.9KViews0likes3CommentsHow to Query Report folder structure of PowerBI report server and see all the hierarchy of folders ?
How to Query Report folder structure of PowerBI report server and see all the hierarchy of folders ? I would like to query PowerBI report server and want to see how folders have been organized .I want the nested structure so that I can make decision in re-designing the folders based on my Business line and sub departments. I m technical user and not want to see what data is present in the reports but just the structure and objects on report server .Solved3.6KViews0likes4CommentsBest Option for Power BI Data Repository
The current Finance role that I am in involves standardizing reports for a wide audience to use. I have developed multiple Power BI reports that others are using, and I want to have a data repository for all current and future Power BI reports. The current location of my data is on my personal computer, but I want the data to be available for other analysts to grab when they want to develop their own Power BI reports/analysis. Unfortunately, I cannot connect directly to SAP HANA (IT will now allow it) but instead have to query the data out of SAP HANA using Analysis for Microsoft Excel and connect to flat files/workbooks that hold the data. I am currently trying to decide on the best location to house the data for the Power BI reports, and I am currently looking into using SharePoint, SQL database, a shared server, or Azure. I think Azure is the least likely option due to cost and the required involvement of IT, but I still want to include it as an option, nonetheless. Is there someone that can give the pros and cons of each (to use as a data repository) for the organization’s Power BI reports? I have never used SQL or Azure as a data connection in Power BI, so any information would be helpful. It is just me that will be maintaining this data repository, so I am trying to keep it simple but efficient. Ideally, I would not be adding a week’s working hours as a database administrator on top of my current role. Below are what I have so far as my options: SharePoint- This is the option I am leaning towards mostly as of now. Pros -It would not require an on-premises data connection for Power BI Service. -Can use a macro to refresh the queries held in each excel workbook that would be held on SharePoint and then refresh the reports in Power BI Service -The team I work for manages the SharePoint site for the organization -It would not require additional cost unless we start to get close to the storage capacity of our SP site Cons -Takes a long time to bring data into Power BI Desktop and slower refresh connecting to an online data source -Can potentially be a lot of excel workbooks and folders SQL database Pros -Can use Select statements within Power BI reports to gather only the data I would need instead of pulling in an entire dataset (Not a huge benefit I think but a benefit, regardless) -Additional capabilities in Power BI because of connection to database? (Direct Query?) -Can create relationships between datasets (Not sure if I would use/need this feature) Cons -Would have to use an on-premises data connection for Power BI Service. Would maybe require a virtual machine to run scheduled refreshes. -Would require the skill and time to manage the database Shared Server Pros -Would be faster than using SharePoint (Online data repository) Cons -Would have to use an on-premises data connection for Power BI Service. Would maybe require a virtual machine to run scheduled refreshes. Azure- Do not know too much about this option. Pros -Can handle a lot of data (More than a SQL db I believe) -Additional capabilities with Power BI? -Would I need an on-premises data connection in Power BI Service for this, since the data is housed in the cloud? Cons -Most complex solution -Costly -Would most likely require assistance of ITSolved13KViews0likes13Comments