Join us live as we answer your questions about Power BI!

Questions

Q: I’d love for a opinion on how you think Azure Synapse fits in with Power BI.

Q: I get confuse sometimes between measure and column can u clarify it and when to use what?

Q: any improvement in the app navigation in the coming months?

Q: Why do measures now include table names? Does it matter where my measure lives?

Q: Let’s suppose I have two columns in a table i.e. From Date and To Date. How can i generate all the Dates between these two dates?

Q: How to Filter Multiple Columns in same Table using DAX , some how not getting result. Planning to create video on that!

Q: Any plans for Python in Power BI Dataflows?

Q: Is there a Dax equivalent of the M Query List.Dates?

Q: Is there any possibility to extract data from matrix visual as it is to excel?

Q: I’m using flow map visual in PBI. it’s having an issue. if source and destination are same then it won’t show any flow. do you have any tips to avoid.r else could you suggest any alternative visuals

Q: Hey guys, I have a question about publishing best practices: We need the ability to publish reports from one workspace to different apps. Any idea how to achieve that or which workarounds exist?

Q: How to Identify calculated column when we switch relationship layer. calculated column icon is not visible on relationship layer.

Q: Another interesting question. I am planning to create a model where i want to track all infected people due to COVID. Wanted to track Infected people as a chain , like IF A infected B and B infected C and C infected , if I select A ,

Q: measure and column sometimes get really confuse!!!!

Q: Is there a way to find out which tables/views are used in the report and which are not, so I can delete the one that we are not using?

Q: Hi! Client sends data in excel files on weekly basis. Where would u store that file and which connector would u recommend for reports that has schedule refresh. Thanks!

Q: what are data sources which doesn’t require Gateways for data refresh

Q: How can we use an AD group to override RLS (see all rows)? Such as the case of an Executive member AD group

Q: I cannot get my YOY calculations to be accurate with a fiscal calendar

Q: Why does capacity region gets change frequently in case of any outage in powerbi server?? even capacities were not visible.

Q: Is it possible to create folder on data layer similar option which we get on relationship layer.

Q: using python to draw visuals in Power BI? I tried but faced some issues in using the columns from my table?

Q: What recommendations would you have for users that want to have hierarchies that span two tables?

Q: When will be getting option to write SQL queries on dataflows

Q: Sometimes while writing a DAX the measure which the power bi suggests is not shown can u tell why it does not suggest or why such scenarios may arise??

Q: How can we convert a model from import to direct query?

Q: can we use 2 different datasets for paginated reports?

Q: What would be the most efficient way you would choose to check the fact table with dimension table to make sure all dimensions are captured (e.g. dimension missing)

Q: What do you think of including dataflows in the architecture in combination with aggregations and composite models (directquery & import)?

Q: What’s the way to customize tabs in a report as a drop-down menu on left side of the panel?

Q: Is there a way to keep track of usage across all workspaces and apps? Will it be audit logs only?

Q: Could you name the PBI competitors? Do you have any guess about the size of PBI marketshare?

Q: when composite model will be available in PBI?

Q: Just like sync slicer can we do same with Filters?

Q: “Usage Metrics Report” dataset gets auto created first time when we request for same. My Q is there a way to control the refresh schedule for this dataset. Note: I am pro user but not an admin.

Q: what’s the best way to capture the text, like a survey from a pbi report, and display it realtime on the same report? i want to take the 5 star feedback from users and their comments about the PBI.

Q: what is the real added value in combining PBI and Azure Synapse

Q: is there a possibility to increase the size of a report Page so I don’t need to create to many pages

Q: Is there a possibility to increase the size of Power BI Report size? So I don’t need to create too many pages

Q: Do you have an idea when lasso select as filter for visuals are coming .?…great feature for Scatterplots and timeseries

Q: how can we manage the slowly changing dimensions?

Q: Is there any way to deploy PBI reports\dashboards from PBI service into report server directly, without downloading and publishing into RS? any roadmaps in upcoming release for this future

Q: can we embed editable excel in power bi report/dashboard? this is respect to the video uploaded “can you embed powerpoint into power bi app”.

Q: sorting based on two columns?

Q: Is is possible for incremental refresh using Pro capacity? In my source DB I always have latest month data wherein PBI I need to show historical data

Q: Is there a way to hide page tab in power bi service?

Q. I work for a firm that is so used to paginated reports but will not spend money on higher priced version of power BI. what’s best way to used embedded to get best of both worlds

Q: How can you sort 2 columns? For example, monthname and dayname.

Q: I have sometimes seen DAX expressions/measures returning null/blank without errors. Have you seen this as well and do you know why? I have no example.

Q: Have you guys been kicking the tires on deployment pipeline? I can’t get it to work with my incremental refresh stuff. 😞

Q: Has there been any telemetry yet on Personalize Visuals and how much the feature is being used?

Q Why do we spend so much time doing Covid19 aggregated reports when we know that the data quality sucks?

Q: Any suggestions about CI/CD for power bi?

Q: Where would be the best place to define the date calendar for data that is refreshed, so that its updated accordingly?

Q: Which book can we refer for Power Query and M?

Q: When I chose “mark as Date Table'” for my Date Table, I lost my Date table build in-hierarchy(year, quarter,month day), and it affected a lot of my data… How can I bring this hierarchy back?

Q: how can we work with the slowly changing dimensions? For example if a product manager of a product changes over time. And that information is kept in the products table

Q: Tips to improve the Power BI file

Q: Can we refresh a dataset from PWBI desktop without gateway?

Q: is there a visual for html rich text formatting?

Q: how do I provide inputs on power bi published version

Q: Any book to learn Dax and master them?

Q: If we have long list of value in parameter drop-down. then can we have search options in parameters of paginated reports?

Q: Do you know when will be the next update of power bi desktop optimized for report server?

Q: Is there a visual (table) in which one can change dynamically the dimension on the rows ( product / client) maintaining the same measure set on the columns ?

Q: Can you please tell me the best way to push data from power query to SQL? my data is 500mb i need analyze in sql

Q: Do you make use of any wireframing tool before building a multiple page report?

Q: Connecting to SharePoint On-Premises – “Password will not be encrypted when sent” – issue?

Q: Is there anyone that can change the visualization to the top of the ribbon like excel is at the top?

Q: can power bi detects automatic relationship of column based on data in column rather than just column name

Q: will there ever be an easy way to create similar measures at once. For example, I have to create similar formatted 100 measures.

Q: can we have search options in parameters of paginated reports?

Q: how to improve performance of Dax measure?

Q: what is the best way to have a datetime column available to view datetime and date only?

Q: will release pipeline support dataflow with gateway as source and will the pipeline support dataset built as direct query on that dataflow? Or Can this be done in PowerShell – move to diff workspace

Q: Please comment on support for version control for PBIX files

Q: Do you guys prefer developing Light or Dark Mode?

Q: Why the PowerShell Cmdlets for Gateway management can only run on PowerShell Core?

Q: Version control in Power BI?

Q: how do we provide input fields on power bi published version

Q: Can we refresh a dataset from PWBI desktop without gateway?

Q: Version Control in Power BI?

Q: How to stage data reading from GOOGLE BigQuery to Power BI?

Q: Any chance that the Power BI ream will fix the Name of Time Intelligence to Date Intelligence since that is what is really is?

Q: Data used by an R visual for plotting is limited to 150,000 rows. Can we expect that this limit can exceed in near future?

Q: hide page is a available at the bottom?

Q: can we have search options in parameters of paginated reports?

Q: Any chance the Power BI team will fix the name of Time Intelligence to Date Intelligence since that is what it is? They are starting to add time based functions after all.

Q: can we have search options in parameters of paginated reports?

Q: How can we pass windows SSO credentials to Power BI so that premium capacity users can seamlessly consume reports without being bogged down by log in screens constantly?

Q: is there a possibility to increase the size of page report? So I don’t need to create too many pages

Q: Can I calculate dynamic percentile, I have a map, I want percentile on countries and after drill down to particular country then calculate percentile based on states data ,and after that counties

Q: Data used by an R visual for plotting is limited to 150,000 rows. Can we expect that this row limit will increase in near future?

Q: Team, I wanna hide page but show all the visuals in the page? Not completely hiding page…!!Thank you

Q: What is the difference between PBI Embedded vs PBI App service? Is there any major missing features in PBI embedded?

Q: Seeing a lot of maxing out dataflows resources still with enhanced compute on. How/when do you position Enterprise Grade ETL and using External CDM while still promoting self-service BI?

Q: Can we sync filters?

Q: Where to get French Toast Merch?

Q: did you guys used Azure Synapse with PBI and what are the real advantages of doing it.?

Q: Can we move Dataflows in PBI Service from workspace to another?

Q: Is dataflows enabled for Premium Capacity?

Q: if a datasource has an error on refresh, they all fail. is it possible to configure skip?

Q: Data used by an R visual for plotting is limited to 150,000 rows. Can we expect that this row limit will increase in near future?

Q: Is it possible to show by default a graph with three values from three measures and then have a slicer to filter the graph based on it?

Q: Is there any magic trick to persist calculated measures back to a AAS cube(Live connection) that was created in PBI desktop ?

Q: Is it possible to get metrics on my published reports on how my users are using the pages, similar to a heat map for a website

Q: Is there any plan to apply RLS on the comments section as well.?

Q: ”Usage Metrics Report” dataset gets auto created when we request 1st time. My Q: is there a way to control the refresh schedule for this dataset. Note: I am pro user but not an admin.
Q: object level security anytime soon??

Q: what if there are 5 pages in a report and filter has to be applied on only three pages? ANd other two pages has different filters

Q: is there any plan to apply security on pages.?

Q: What is better from a security and scalability perspective (external users) publishing to an App or Embedding? Is there any limitations using the App as to #of users?

Q: what’s the deal with switching themes? When I upload some say custom theme, then decide to try some of the default ones, then want again my uploaded I have to reupload. Just why:D

Q: Do you know when we will see the next update of power bi desktop optimized for report server?

Q: is there any plan to add write back functionality to write commentaries or run simulations?

Q: How do I get the column title of a table visual to be dynamic? The measure I use in that column is dynamic based on a disconnected slicer.

Q: How do you organize your day to do actual work and keep up to date with learning new features of PBI? (Of course, also making the videos for community)

Q: Any tips for working with one report that is copied to multiple workspaces? In terms of updating, users retaining any bookmarks etc

Q: Paginated reports for Pro License??

Q: how to provide input fields on power bi published version