REPLAY Power BI tips from the Pros – LIVE (Sept 19, 2020)

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

Q: When will we be able to filter by parameter? (15:22)

Q: Is there an easy way to highlight a single point in a line chart? (16:50)

Q: Have you done a video on embedding Power BI Dashboards into a Salesforce environment? (18:29)

Q: Patrick you still got that Phil Seamark debug sumx on the board? (19:49)

Q: Could you recommend a method/technique to migrate a pbix data model (import) to Azure Analysis Services? (21:29)

Q: Is it possible to switch off tooltip based on certain criteria on a matrix. For example, if hover a mouse on certain account codes which has some details (26:54)

Q: I have multiple reports using a shared dataset in our bi service. I do not seem to be able to use the edit interactions option to have my graphs interact with each other. Have I missed something? (27:43)

Q: When will I be able control deployment pipelines? I don’t yet see a toggle button to turn it off for the tenant. (29:30)

Q: RLS while embedding and publishing in SharePoint. If u guys can help out or suggest how to approach this. (31:13)

Q: We’ve integrated Power BI embedded into SharePoint online. since dashboard are not supported in embedded, what are my options to get the dashboards in there? We’ve already tried web URL n cross drill through. (32:32)

Q: Calculation Groups are great but when we put them in a Matrix we can’t sort by a specific column, can we? (33:30)

Q: What else can I do with M? (36:03)

Q: Power BI has no support for GCP Service Account?? Why is it so?? When it is expected. (37:47)

Q: Adam, why is your Ignite session at 5am? Uhg. (39:35)

Q: How does model eviction work? Technically (40:54)

Q: Can we export Power BI report to MS Word like we do PowerPoint? Is it in roadmap? It could replace some use cases of paginated reports. (42:57)

Q: When can we expect to have incremental refresh on deployment pipelines? (45:14)

Q: I have empty cells in a matrix viz because there is no underlying data for some cells. Is there a way to color those cells with conditional formatting even though there is no underlying data? (46:30)

Q: Do you have any advice on page size / ratio for embedding a report on Teams? I hate how it resizes based on the monitor’s aspect ratio. Some reports become way to ugly. (47:37)

Q: Any good whitepapers on automated AAS processing using AMO libraries from ADF or Azure Automation to kick off the refresh. I found Christian Wade’s paper from 2017 but wonder if newer one. (50:11)

Q: Are there any advantages for getting Power BI Certifications? (50:59)

Q: Planning to educate Excel users on Power BI, the online documentation is very extensive, but are there any areas that would be easier to understand with a demonstration or in person? (55:12)

Q: I have some customers that want to insert items into the axis of chart that are….definitely not found in the same field…how can they combine different fields to be side-by-side in an axis? (1:00:12)

Q: What are most common data lake engines being used with Power BI that you see with customers? (1:02:49)

Q: I’m trying to do modeling D365 data into a nice star schema. It looks extremely rough. Who is the expert at this? (1:07:46)

Q: DirectQuery against 365/CDS. is that safe to use now? (1:09:55)

Q: Can we format the date/time in a linear line graph?

Q: Is there any way to use DAX to select the date slider with some value for example less than 5 years from today selected on the slider?

Q: A paginated report issue. Some users can connect, and some cannot. All permission is set correctly, the dataset is loaded to P1, live and not evicted. CPU and Ram is not peaked. Any thoughts why?

Q: Can we format the date column on the visualization differently? I need them to be seen short or long on different visualizations.

Q: Any tips on connecting PBI to Facebook? When I tried to sign in, I just get an error saying that the link is not available without even letting me enter FB credentials

Q: It is possible to create a custom input like text box and use the value as a filter?

Q: I have empty cells in a matrix viz because there is no underlying data for some cells. Is there a way to color those cells with conditional formatting even though there is no underlying data?

Q: Do you have any advice on page size / ratio for embedding a report on Teams? I hate how it resizes based on the monitor’s aspect ratio. Some reports become way to ugly.

Q: Is there a way to easily schedule the upload of a SharePoint folder of CSV files to an azure sql database table the same way we do in a Power BI model with power query

Q: I have a table with target to reach for my clients. The target is per year. But when I filter my dashboard for a specific month, I’m not able to display the target on my dashboard. How to solve?

Q: Any hints if there’s a roadmap for paginated reports support for Power BI dataflow data source?

Q: Can we use paginated report to send mail to vendors (a vendor should get only his data) with RLS? I haven’t tried this, any tutorials you recommend for paginated reports?

Q: Any fancy way to automate export visual to excel? I read a way via a python script, but I read that it works only with a personal gateway and not enterprise.

Q: Possible to apply edit interaction, i.e., filter to all visuals instead of selecting 1 by 1?

Q: I’ve a fact table w 4 duplicated fields, i.e. Good Qty, Bad Qty, Code Bad, Time Bad, one for Left and Right sides, and I need to know each side. Should I unpivot? When I did, got duplicated values

Q: Send an email upon slicer selection. Have set of 2 slicers that require input and once input is selected, a table displays list of emails. Add a button and generate an email to the listed emails.

Q: I recently switched to ODBC connector and view native query no longer works when in PQ; folding still happening when I look at my db query history, any way to “fix” the view native query?

Q: Is there a workaround for conditional formatting line charts?

Q: When RLS will be applied also to the comment section in Power BI?

Q: Best/quickest way to learn the DAX theory, and the number one thing you would say is important to fully understand DAX theory (before learning functions)

Q: How can i export all PBI Desktop M-Script stuff to JSON and import as Power BI service dataflow?

Q: Anyone know if there’s a good PQ/M as it relates to Databricks story in our future?

Q: Can you use RLS to allow certain tables rather deselecting all tables? When adding tables to my central model I have to remember to remove them for most roles which takes ages.

Q: My users love the pie chart tree for their hierarchies, they want these to be able to filter other visuals as they navigate the tree. Does anything do this

Q: Could you please list some advantages and dis-advantages for using SSAS Tabular versus singe file Data Model / Data Set ?

Q: So can we talk about 4-4-5? What is your preferred approach?

Q: Would 4-5-4 from Marco work with 4-4-5?