cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Anonymous
Not applicable

Cannot use PowerBI as data source

Hi *,

 

i want to use selected data in PowerBI within my PowerApps Application. I tried first creating a new PowerApps Application from within PowerBI. It created a new Application and this application had already the connection to the right data fromt he PowerBI Report and also the PowerBIIntegration Object in the left bar.

 

When i create a new application from scratch go to Add Data Connection > Select PowerBI (Preview) > Type in my PowerBI credentials, then under Data PowerBI is visible but i cannot select it ! And there is also no PowerBIIntegration Object created.

 

Where is my fault? What i am doing wrong? I have google'd aroung and but there is always only description about how to create out of PowerBI a PowerApp, but not how to create an app from scratch and connect to PowerBI.

 

Best regards

Yavuz

1 ACCEPTED SOLUTION

Accepted Solutions
Super User
Super User

Re: Cannot use PowerBI as data source

@Anonymous

 

I just tried adding the custom visual and chose an existing app to add the PowerBIintegration object and it worked fine.

 

See the below screenshots -

2018-02-14 08_56_55-Belt Drive -Analysis 1 - Power BI.png2018-02-14 08_56_42-Belt Drive -Analysis 1 - Power BI.png2018-02-14 08_57_16-Belt Drive -Analysis 1 - Power BI.png2018-02-14 08_58_07-Test - Saved (Unpublished) - PowerApps.png2018-02-14 08_59_22-.png

Is this what you were trying to achieve?


Vivek Bavishi aka That API Guy
PowerApps and Flow MVP
Blog | Twitter | YouTube | Community Profile | GitHub



If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

View solution in original post

19 REPLIES 19
Super User
Super User

Re: Cannot use PowerBI as data source

@Anonymous

 

You can insert PowerBI tiles from the Insert - > Controls menu2018-02-11 17_39_55-Test - Saved (Unpublished) - PowerApps.png

 

Then select the workspace , dashboard and the tile you want to insert accordingly

2018-02-11 17_40_57-Test - Saved (Unpublished) - PowerApps.png

 

Hope this helps.

 


Vivek Bavishi aka That API Guy
PowerApps and Flow MVP
Blog | Twitter | YouTube | Community Profile | GitHub



If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Anonymous
Not applicable

Re: Cannot use PowerBI as data source

Thanky for your response. Thats not what i was looking for. I dont want to embed a PowerBI Tile in my PowerApps Application, instead i want to view a selected data value from a PowerBI Report in PowerApps using for example a Textbox or Label. See also this link which refers to creating such a connection between PowerApps and PowerBI, but dont show this integration step by step building an application from scratch:

 

https://powerapps.microsoft.com/en-us/blog/powerbi-powerapps-visual/

 

best regards

Community Support Team
Community Support Team

Re: Cannot use PowerBI as data source

Hi @Anonymous,

 

You can not create App from Power BI DataSet directly under PowerApps, at least currently.

If you would like this to be added, then please consider submit as an idea:

https://powerusers.microsoft.com/t5/PowerApps-Ideas/idb-p/PowerAppsIdeas

 

Currently Microsoft only offers the following approach:

1. PowerApps custom visual,

Which allows you to pass Power BI filtered results into PowerApps, and then do the data modification within the PowerApps visual,

 

2. Power Bi connector, 

Which acts like a service connector as Office 365 Users, you could be able to send service call through

PowerBI.FunctionName,

 

3. Embed Power Bi reports in PowerApps,

 

Regards,

Michael

Community Support Team _ Michael Shao
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Anonymous
Not applicable

Re: Cannot use PowerBI as data source

Hi, thank you for your reply.

 

This is exactly what i want to do:

 

1. PowerApps custom visual,

Which allows you to pass Power BI filtered results into PowerApps, and then do the data modification within the PowerApps visual,

 

But i dont know how to access those filtered results within PowerApps. I would exactly like to know how to "add these functionality to an existing PowerApps App"

 

best regards

Yavuz

Community Support Team
Community Support Team

Re: Cannot use PowerBI as data source

Have you checked the following blog?

https://blogs.msdn.microsoft.com/charles_sterling/2018/01/05/walk-through-of-using-the-powerapps-cus...

 

Community Support Team _ Michael Shao
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Highlighted
Anonymous
Not applicable

Re: Cannot use PowerBI as data source

Yes i have. But this example is also using the PowerBIIntegration Object and there is nowhere documented how to get this one in an existing app. The post also referes to a "App in one day" documentation and i have checked all the related content but couldnt find any hint on the PowerBIIntegration Object. Its really frustrating.

 

Noone has done this before? I mean creating an app from scratch and adding this thing to the app?

Super User
Super User

Re: Cannot use PowerBI as data source

@Anonymous

 

I just tried adding the custom visual and chose an existing app to add the PowerBIintegration object and it worked fine.

 

See the below screenshots -

2018-02-14 08_56_55-Belt Drive -Analysis 1 - Power BI.png2018-02-14 08_56_42-Belt Drive -Analysis 1 - Power BI.png2018-02-14 08_57_16-Belt Drive -Analysis 1 - Power BI.png2018-02-14 08_58_07-Test - Saved (Unpublished) - PowerApps.png2018-02-14 08_59_22-.png

Is this what you were trying to achieve?


Vivek Bavishi aka That API Guy
PowerApps and Flow MVP
Blog | Twitter | YouTube | Community Profile | GitHub



If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

View solution in original post

strategery
Level 8

Re: Cannot use PowerBI as data source

I think the confusion is in your approach. To get the integration object created, you must start in PowerBI, not PowerApps, even for existing apps. Save your app, publish it, then close PowerApps and open up your PowerBI report.

 

Add the custom visual in PowerBI from the marketplace (blog screenshot 1). Click the PowerApps icon to add the visual to the page, then drag at least one field of your data over to 'PowerApps Data' box (blog screenshot 2). From there the tile will refresh and give you the option to create an app or choose one. Once you click choose it will refresh and show you all your apps and allow you to pick it. Follow @ThatAPIGuy's screenshots to get you the rest of the way.

 

I'm not sure but you will probably need to make sure you have published your app for it to show up in the list. The first time I clicked 'Choose app' it actually failed and I had to go back, but the second time worked fine.

Super User
Super User

Re: Cannot use PowerBI as data source

@Anonymous

 

I agree with @strategery's comment. I probably didn't understand your question initially.

 

Is there any specific reason why you want to add the integration object from PowerApps instead of PowerBI?

 

You can achieve what you want by going through this route PowerBI -> Custome Visual -> select PowerApp - > Edit in PowerApps. Then why not?


Vivek Bavishi aka That API Guy
PowerApps and Flow MVP
Blog | Twitter | YouTube | Community Profile | GitHub



If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Helpful resources

Announcements
thirdimage

Power Automate Community User Group Member Badge

Fill out a quick form to claim your user group badge now!

sixthImage

Power Platform World Tour

Find out where you can attend!

Power Platform 2019 release wave 2 plan

Power Platform 2019 release wave 2 plan

Features releasing from October 2019 through March 2020

fifthimage

Microsoft Learn

Learn how to build the business apps that you need.

Top Kudoed Authors (Last 30 Days)
Users online (4,989)