Have questions about Power BI? Come hang out with us in the May 2020 edition of our monthly LIVE question and answer hangout on Saturday, May 2nd @ 9:30am Central.

Questions

Q:-how should I convert billions to crores?

Q: Any ideas on allowing a user with zero experience an easy way to add commentary on a report for print? For example board report. Would an embedded powerapp be the route

Q: For RLS is there a way to pull the email ids from an SQL tablet of authorised users to the Security in Web service?

Q: Anyone requested a graphic representation of PQ steps vs just the normal text?

Q: Gents, we are building Dashboard for DBAs and they need to manage 100x of servers. is there a way to avoid creation of 100x copies of dash and 100x connections for each and how to handle Gateway?

Q: What is fundamental reason that Time Intelligence DAX doesn’t work in direct query mode? What is workaround?

Q: Does SQL Server come with Premium Capacity?

Q: is there a way to change the currency based on a filter? (some numbers are in euro, other are in pond)

Q: What is the difference between SSRS report vs Paginated reports?

Q: following up on the RLS question, will we ever see finer grained object permissions aka lower level than workspace

Q : Any chance of correcting the naming from Time intelligence to Date intelligence? Since that is what it really is.

Q: Any chance of support for Time Intelligence? Or at least support for time in things like slicers?

Q: What is fundamental reason that Time Intelligence DAX doesn’t work in direct query mode? What is workaround?

Q: Gents are there any plans to add filtering to Paginated reports, to avoid jumps between Power BI designer and Paginated reports?

Q: Tips for Visio Visual

Q: Does PoweBI enable the copy visual in embedded service ?

Q: do you have any example of overlapping charts (e.g. like the Covid one from last week)?

Q: Hello, can two slicers (from same dimension) on a page interact with two different fields in a single table? All the visuals being on the same page

Q Can u make an example of the Decomposition Tree & also for the Synoptic Panel visualization

Q. Date tables have relationship with Date/time but still shows blank data. Why?

Q: What is fundamental reason that Time Intelligence DAX doesn’t work in direct query mode? What is workaround?

Q: How do implement a pop–up effect on bookmark?

Q: I have a measure that calculates % change period over period using daily data. It works fine on the daily granularity. When I drill up to month/qtr/yr not so. Is there a way to fix that?

Q: Hi guys, there is a way to sort the pie or donut chart like for % or name ?

Q: @Guy in a Cube how do we get numbers represented in Lakhs & Crores in PBI Visualizations?

Q: Official or trusted dataset for countries and codes + Lat/Long – where to find?

Q: RE: Date Tables. How do you handle that with multiple dates in 1 table. I.e Start/End dates?

Q: What tools do you guys use to screen recording, zooming in while live sharing and highlighting? Just curious!! 😁

Q: How to create parameters which help us to bring historical files dada in data model

Q: Any chance of more videos working with Power BI Report Server. All I ever hear about is Premium this and Premium that. In many of those cases, you don’t need Premium, you need Report Server.

Q:When will Azure Dev Ops build pipeline be available for Power Bi?

Q: How do you restrict access to subset of data within a data for set of users?

Q: For Patrick. Any v1 tenant migration solutions to force an org to v2 only? 🙂

Q: For how many guest (external) users on O365 admin portal can I assign a Power BI Pro license? Is there a limit?

Q: Hey, can we set locale settings for the enterprise gateway ?? or it will take locale settings of the server where gateway is installed?

Q: What are the plans for the new metadata format: when it goes to GA, what’ll happen to the current metadata format? Will it be dropped or we will be able to choose the one we need?

Q: ETA on live connection support with composite models?

Q: In a Bar chart I would like to show Month and Year something like this. Could you please advice Mar Apr Jun Jan Feb Apr Sep Jan Mar Jun Oct ______2018____|_____2019_____|____2020____|

Q: What is the most creative thing you’ve done in Power BI?

Q: Patrick. You mentioned about combining date and time tables but never completed that thought.

Q: IF I import a File (Excel) only once, is there a way to avoid Refreshes every time you Transform Data

Q: can composite model allows user to connect to 2 dataset in a single pbi file?

Q: ZEBRA alternative visualizations in POWER BI

Q: There is another option but paying dedicated server for pbi embedded? We need some reports for our customers, is an start up, we definitely can’t afford that much. What do you recommend?

Q: Can PowerBI show/store Duration datatype in visuals as mm:ss? I think its d.hh:mm:ss only right now

Q: I have a measure that calculates % change period over period using daily data. It works fine on the daily granularity. When I drill up to month/qtr/yr not so. Is there a way to fix that?

Q: I am sharing Power BI reports for more than 200 users, but after setting up everything, I can’t copy the list of user with permission for later use? 😞

Q: What are the plans for the new metadata format: when it goes to GA, what’ll happen to the current metadata format? Will it be dropped or we will be able to choose the one we need?