Join us live as we answer your questions about Power BI

Questions

Q: How a company can go about engaging you guys to provide consulting services on as needed basis?

Q: is there anyway to manage the Salesforce objects data when connecting rather than just having to import everything we have millions of rows of data and it’s super slow?

Q: Is there any video made for Report server configuration in Mobile app using Azure AD ?

Q: Please i have question about create hierarchy ssas with power BI, I try hierarchy slicer but I have a problem I can’t select one level tks you

Q: what’s most efficient/fast way to dynamically expand columns after function (changing/new columns)? Especially in dataflow: I get stack overflow with some methods that work in desktop.

Q: Export underlying data option in Power BI Service, the export file contains columns which r used to create the Matrix visual with all “Text” type columns only. How to get numerical columns as well.

Q: Why can’t we setup a dataset refresh against the Power BI service XMLA endpoint?

Q: How can I make incremental refresh for reports on Power BI report server. we use import query method and every time the report is really slow on schedule refresh with new data coming in, thanks

Q: Deployment Pipelines and Dataflows – how should we be managing these between workspaces?

Q: What do you think about Kimball?

Q: Do you think the Power BI eco-system combined with e.g. Azure Synapse will change or enhance DWH approaches like Kimball or Inmon? Could it be that features of today are unlocking new approaches?

Q: Is there another way of importing data from an Access Database into Power BI when you don’t have a direct connection?

Q: why do unlicensed users sometimes get prompted they need a license when accessing content within a premium workspace?

Q: is there an option to customize the way you send an email using power bi service?

Q: since you were talking about your gear, what kind of laptop specs would you recommend for someone that would work with PBI, Visual Studio and SQL Management Studio?

Q: is possible to do the same for “week number”?

Q: How to fix relations between tables in power BI using power query?

Q: Do you have any videos where we can create “dashboards” from “reports” in power bi service? That is only used to pin visuals from reports or is they anything more I am missing?

Q: Any idea of when we might do my report review/teardown?

Q: how do you display date and day of the week in a line chart? If I turned the auto-time intelligence off, no date hierarchy, I cannot create such display.

Q: I have 80 KPI’s and every KPI have different thresholds and figures, such as Number, %, Avg. 1- Can I make an input through BI directly? 2- How to make different KPI’s dashboard?

Q: Is there any way to embed usage analytics services (ex. Google Analytics) into Power BI reports? We are hoping to have more granular usage data like what data was filtered

Q: Date hierarchy not available in live connection mode, Situation: I am not allowed access to the model at my work place, work around possible ?

Q: Hi guys, is there a way I can use REGEX in M ?

Q: I have a measure that calculates compliance scores. Is there a way to show a card visual where it shows the +/- change from the current week and last week. How can I do that? I am fairly new to PBI

Q: can I create basic and custom date filter in one page in power bi. can u help me that? One filter is affecting the other.

Q: Do we any tool to migrate Google data sheet to Power Bi?

Q: Is it a good idea of moving from MDX(SSAS) to DAX(PBI), If so what are the Advantages/Disadvantages?

Q: Can DAX be recursive?

Q: Can I create different embedded capacity for different app workspace as an ISV I wanted to bill my customer based on the capacity my client is willing to pay?

Q: can dataflows be created using power bi dataset as source?

Q: Another Salesforce one why is it I experience a List error when I try and expand a column, this doesn’t happen on all columns.?

Q: For the “one big data model” stance, does it make more sense to build this as a Power BI dataset, or Azure Synapse?

Q: I am not able to scroll down the data in tool tip. Is that how tool tip works. Ex: Like we scroll down our data in tables or matrix.

Q: Can we perform cohort analysis using dax? Have you guys ever done that? If yes, can you show it to us? Would love to see a video from you guys on cohort analysis.

Q: Can we write back to analysis service which is connected to Data warehouse? is there is a way for write back to database or analysis service

Q: Can I create different embedded capacity for different app workspace as an ISV I wanted to bill my customer based on the capacity my client is willing to pay?

Q: What would you recommend in terms of minimum system requirements for power bi report server?

Q: I’ve a matrix table with Filters on my PBI desktop, when I publish it to PBI Service, it looses all the filters. Any idea why.

Q: Can we write back to analysis service which is connected to SQL data warehouse or any other way to achieve the write back .

Q: Is there a way to enable incremental refresh based on date created/modified from a sharepoint list? I get errors when I try to do that

Q: Is there another way of importing data from an Access Database into Power BI? I am using an Excel VBA script that pulls the data from the Access Database into my spreadsheet

Q: When I try to use MAX function on a measure, I have a response as “The MAX function only accepts a column reference as an argument.” Is there any alternative function that I can use? Thank you.

Q: any tips for working with SharePoint? I have models that are connecting to lists and some that are just pulling CSV files from SharePoint folders. connection is so slow! refresh sometimes times out

Q: Can we instead of having Grand Total , to be Subtraction is there a way to do it in visual instead

Q: why refresh does not work with SharePoint 2010 lists?

Q: Further to your great earlier videos for Embedded, could you guys do some more relating to JavaScript embedding and RLS?

Q: How can you group columns in a Matrix visual?

Q: Do you have lists of best books on your page/site? Might be something that would be helpful

Q: Can you show how to embed word/ppt docs etc as part of an app custom navigation link (loaded in content area) please?

Q: I want to measure the login data of my clients I have a client list that is changing on a monthly basis. the date table connects the client list and the logins do I lookup the date via meas. or col

Q: For Patrick, Do you think Ironman uses Power BI?

Q: hey guys! please some references to start with DAX

Q: What does your typical work week look like? You mention working with customers but you also say that you don’t do consulting.

Q: When documenting PBIX files created by others what do you look at as a guide for best practice to do this after the fact?

Q: Power BI desktop with SSAS Multi source, how do I get a hidden field

Q: is it possible to consolidate the data on day to day basis as a snapshot to do time series analysis. My datasource only has the current day data.

Q: As of today enhanced metadata format is in preview. What happens when it goes to GA? Will there be two metadata formats at the same time: current and enhanced? Or will the current one be dropped?

Q: Power bi with SSAS Multi data source, if I have attribute not included in perspective shows as hidden in model and can’t access. fair enough.

Q: How to overcome BEx Query to Power BI Direct query limitations i.e 50 dimensions?

Q: When using Power BI to connect to a managed instance or Azure SQL DB, can you use an AAD account to connect and process the model. The only option seems like the Microsoft account which uses OAuth.

Q: Is there any way to get notified after dataset refreshes? Power Automate allows you to trigger a refresh, but doesn’t have the option to check refresh status. (success or failure w/ error msg)

Q: Is there any guidance on whether to use O365 vs AAD security groups to manage app distribution/workspace roles (and how to keep them in sync)?

Q: Is it possible to sort by multiple columns simultaneously in a matrix?

Q: At present the Tabs are not appearing in the mobile view (embedded). we can use the navigation button as the workaround. But any chance this can be fixed (to show the tab)

Q: COVID-19 is moving from Country to Country over time. Want Chart showing Highest Cases for a Country and Date occurring. Both measures working. What is the most suitable visual?

Q: Some tables in my dataset are so big, 15GB-65GB. how can I use Power BI to handle such a big dataset?

Q: I want to set upper limit of my whatif parameter based on some slicer selection. Is it possible to make dynamic in GENERATESERIES function ?

Q: Shall I go for DA-100 beta certification or wait for stable version. ?

Q: RLS and OLS simultaneously!!! Can you do that?

Q: As of today enhanced metadata format is in preview. What happens when it goes to GA? Will there be two metadata formats at the same time: current and enhanced? Or will the current one be dropped?

Q: The column in which I have city names does not plot correctly on the Map? How can I improve it?

Q: Service-now integration with Power BI? any other option other than CDATA?

Q: Can we create a Date slicer/filter where based on a user date selection (end date) limit the start date to be Trailing 12 months ?

Q: Is there a way i can use multiple values in power bi filter link …like in(1,2,3….)???

Q: I am not able to scroll down the data in tool tip. Is that how tool tip works. Scroll is not working for me

Q: can is use multiple values in one parameter in power bi url?????