Check out our FREE courses: bit.ly/3N00AJw

If it was possible to like something twice I would have! Great video, just what I was looking for. Thanks 🙂

Super thank you for this. I have the exact same use case where the PowerBI dataset has a 1 to zero relationship to the Comments table. I am using SQL Server on Azure, and this worked fine. The key concept that you showed, and not discussed extensively elsewhere is the conditional statement in the Form.DefaultMode which switches to Edit or New depending. This technique unblocked me on a problem that has taken a few solid days. Using the Rectangle to enable comments only when one row is selected is a nice touch, and shows polish. Thank you again. :-)

This is awesome thanks Tim! I love when I watch a video like this and straight away, a use case for it comes to mind. I've never used PowerApps before but I'm definitely going to dive into it now. Thanks Again. :)

Incredibly helpful video, made it simple and easy to follow. This was amazing thank you

This is exactly what I need when my IT department lets me out of my Personal Productivity environment. Bookmarking this.

Great tutorial video. I needed a refresher as I have a presentation tomorrow on Power BI / Power Apps integration. New subscriber here

@EnterpriseDNA

Жыл бұрын

Hi @guyinazo , glad you found this video helpful! If you haven't yet, you can subscribe to our channel to see all our upcoming data skills and AI tutorials, and announcements. Cheers!

Can you please help, getting error for below code - No is not valid LookUp('Action Items Tracker for DCR - DEX',Title=First(PowerBIIntegration.Data).No)

omg i was struggling with this for so long u told in such a great way

@EnterpriseDNA

Жыл бұрын

Hi Shreya, glad that this video is of help! If you haven't yet, you can subscribe to our channel to see all our upcoming Power BI and Power Platform video tutorials and announcements. Cheers!

@shreyasonawane8119

Жыл бұрын

also can u tell me that how do i auto refresh the powerbi dataset i connected it with powerautomate but dint work

@AuroraS934

7 ай бұрын

@@shreyasonawane8119 Yes, you could use a Power Automate Flow that triggers when there is a change in the SharePoint list however I do not find this option user friendly as the refresh might take a while and user is NOT aware when it is finished. I would instruct the user to use "Refresh" button in PBI Service after all updates are done.

@efficiencygeek

2 ай бұрын

@@shreyasonawane8119 One thing to try - Call PowerBIIntegration.Refresh() in your Form.OnSuccess event. If the PowerBI Dataset is loaded via DirectQuery, the updates should appear on PowerBI as well. Other videos by Reza and How To Power BI have this too.

great job

Thank you for this content. I have been looking to do this for sometime and this is by far the best explanation I have come across. Cheers

@EnterpriseDNA

10 ай бұрын

Hi @davidkelly1634 , we’re glad you found this video helpful! If you haven't yet, you can subscribe to our channel to see all our upcoming data skills and AI tutorials, and announcements. Cheers!

Great tutorial. My PowerApp never updates when a selection is made. If I make a label that shows RowCount(), it shows total rows but never updates.

Amazing tool

@EnterpriseDNA

Жыл бұрын

Hi Adriano, glad that you appreciated our content! If you haven't yet, you can subscribe to our channel to see all our upcoming Power BI and Power Platform video tutorials and announcements. Cheers!

Thanks Tim, really good guide. Do you know if there is direct query option in PowerBI to avoid refreshing entire dataset? Unless it’s not needed.

Hi Tim, I’m after the solution that you mentioned at 03:22 of your video which is using URL linking to pass data from Power bi to power app. Do you have a video on it that i can refer to? Embedding power app visual in power bi isn’t the solution for my scenario. Any help will be greatly appreciated. Thanks!

What program are you using to record your screen? Looks incredibly well

How do you have added comments column in the existing powerbi reports columns?

Great video! Is it possible to know who added the comments? I mean, in the table or Power Apps, the name of the person adding the comment would appear.

Thank you for sharing your knowledge and video. In my list, i have default ID column, could you be able to help me lookup formula? Fyi, i am not using default Title column.

Brilliant

@EnterpriseDNA

Жыл бұрын

Hi Kurt, glad that you appreciated our content! If you haven't yet, you can subscribe to our channel to see all our upcoming Power BI and Power Platform video tutorials and announcements. Cheers!

In regards to the lookup function, I keep getting an error saying my field name is not valid/recognized. Do you know why this might be?

My biggest issue is how the app is rendered when the report is in "Fit to page" view, all fuzzy. Unfortunately I cannot use the "Actual size" view.

Hi there what about when you have an existing powerapp and you want to embedded it into PowerBi? I tried doing this and I am not getting any data from my PowerBi report. Can you please assist? Thanks!

Can we get the file he worked on, it would be good for training

I have a Power BI dashboard that similar as yours. In the Power App, I have a button that will add selected item (First(PowerBIIntegration.Data)) from BI into a collection. So user need to select the BI item, then press button, then select BI item, then press button again to add multiple items. Is it possible to directly add the selected item to Power App collection using something like PowerBIIntegration.Data.OnSelected?

Hello. What license/s are you using? Hope you can reply. Thank you so much.

Hi, Can you help me? I can't seem to make it work when my column name has spaces. It throws "Error when trying to retrieve data from the network:" message. But if I tried to use "Column_x0020_Name" as replacement for 'Column Name', the error is gone but there's no data shown in my form. Edit: It seems to be an ongoing bug on Excel Online (Business) Data connector. As a workaround, I used the OneDrive for Business Data connector instead and now I can use spaces in column name and reference them using 'Column Name' without any error.

Hello, It looks really good with a list!! I am trying to duplicate the concept with a table in a SQL Azure database. However, there's a message error when I validate the Lookup fot the Item. Any idea/recommandation plz?

@finnpower92

28 күн бұрын

Hi, this might reach you too late, but as far as I know, this technique works only with Power BI service, in browser. You can't do this in desktop

Sorry if I missed this in the video but is there a way to set this up so that the submitted comment is visible in the report right after submitting it? Perhaps some power automate job or something to trigger refresh?

@timweinzapfel

Жыл бұрын

You certainly could use power automate to do a refresh. However if you have a number of updates to make, that could be an issue. This is one downside to this integration unless you are perhaps doing a direct query to the data.

Good video. But don’t we have a delegation issue here ?

@gregoryoliveira8358

7 ай бұрын

I was looking for something about this. Because there is a warning about this. However, I believe we can accept this warning considering you prepare your application to dont fall into a delegation problem.

Super, is it possible to upload datas from the App to the report directly? Without a excel file or a special DB?

@suprateem

9 ай бұрын

yes, possible to upload data from app to report instandly using PowerAutomate flows API mode, which will instantly refresh the dataset in power bi service with updated information from the sharepoint list, which itslef is gettign updated by the embedded Power App

This didn’t work with SQL database source .. the lookup threw an error. Can you do a demo with SQL database source ?

@kanchidoshi6907

6 күн бұрын

We also need to work with SQL server

The issue I have is that if there is not a corresponding item in my Sharepoint list (i.e. Comment would show blank in your example), the ID that is passed to Power Apps somehow gets filtered out and nothing gets passed to Power Apps at all. To troubleshoot, if I add another table on my page with only ID in it, it's also blank when I selected an ID in my main table without a corresponding comment. Any idea how to solve this?

Great video! I was able to create similar functionality thanks to your excellent guidance! Would there be a way to also add functionality to create a new record using the integrated Power App? In my case, it is updating Consultant records, but I would like the ability to add new records, as well.

@AuroraS934

7 ай бұрын

I would add another button "New Lease" and re-use the form; the Default value for Lease ID field should then populate with maximum value in LeaseID field from "Lease Comments List" data.

Hello and thanks for the content. At 11:09 you typed in the look up formula text, why does it use the phrase “Title=First..” should it not refer to “Lease ID=First…, as title did not seem to appear on the SharePoint list you were using? I’m trying to replicate this app and this step confused me? Thanks David.

@QuantumDot2

6 ай бұрын

SharePoint lists always have a "Title" field upon creation. This can be renamed later (to 'Lease ID' in the video), however the *internal* SharePoint field name would still be "Title" which is why it appears that way in the formula. It's one of those endearing SharePoint *quirks*. :)

@davidkelly1634

6 ай бұрын

@@QuantumDot2 thank you. “It’s a feature of the product.” as i heard once.

I only face difficulty in getting the formulae

@EnterpriseDNA

10 ай бұрын

Hi @UPHARANAND, It's a bit difficult to assess and recommend without looking at the data structure, model and working of the PBIX file for reference. For further queries, you can also reach out to us at our Community Forum by providing a detailed description of your query along with relevant files for reference. Our members and team of Experts will be happy to help out! If you haven't yet, do subscribe to our KZread channel and LinkedIn group to keep posted on the latest data skills and tools updates. Hoping you find this useful! Cheers, Enterprise DNA forum.enterprisedna.co/ www.youtube.com/@EnterpriseDNA www.linkedin.com/groups/12004506/

@UPHARANAND

10 ай бұрын

@@EnterpriseDNA Can I get the data set used in the video ?

@UPHARANAND

10 ай бұрын

@@EnterpriseDNA Can I get the dataset ?