cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Concat
Level: Powered On

Power BI Integration - Data not showing

Hello everyone,

 

I am able to build an app using powerbiintegration.data, but let's say I publish and close the session.  Then I come back to work on it some more.  Every session after the initial setup shows no data in any of the tables or fields that leverage powerbiintegration.data.

 

I have to constantly publish it, then go into Power BI and refresh to see how my changes affect the app.

 

Am I missing something?  Why won't PowerApps pull the PowerBI data in every time I go to edit the app in the editor?

1 ACCEPTED SOLUTION

Accepted Solutions
Highlighted
PowerApps Staff sarafankit
PowerApps Staff

Re: Power BI Integration - Data not showing

Yes, you need to get in the edit report mode first before you get the edit option on the visual.

 

edit-app.png

10 REPLIES 10
Community Support Team
Community Support Team

Re: Power BI Integration - Data not showing

Hi @Concat,

 

Would you please try add a button to Refresh the data after editing? Set the OnSelect property of the button to:

Refresh( DataSource )

For your reference:

https://docs.microsoft.com/en-us/powerapps/functions/function-refresh

 

Regards,

Mona

Community Support Team _ Mona Li
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Concat
Level: Powered On

Re: Power BI Integration - Data not showing

Thanks, but it doesn't work.  The table just says "We didn't find any data to show at this time" - the default message for when there is no data.

 

The app works fine when I put it into a PowerBI visual on my report...  it's just editing and building the app where I can't see the data.  The only time I get to work with the data is when I first create the app.  If I close my session, then poof.  No more data when editing.

 

A second, presumably unreleated problem is that a date column in the data source is not displaying at all - even when the other data columns are.  I changed the data source from date to date/time and iot didn't fix it.  My only solution is to create a duplicate column but store it as text, but then i cannot use Date Picker.

 

I understand the Power BI integration is in its infancy, but I am new to Power Apps so I might be missing somthing.

FelipeStag
Level: Powered On

Re: Power BI Integration - Data not showing

Having the same issue. Any solution yet?

johnchill
Level: Powered On

Re: Power BI Integration - Data not showing

Same problem here. Looking for a solution please.

Administrator
Administrator

Re: Power BI Integration - Data not showing

adding in @sabinn to review and assist

 

@TopShelf-MSFT

Moderator
Moderator

Re: Power BI Integration - Data not showing

Thanks for reaching out and reporting the issue.

 @millopis +Miguel to review and redirect as appropriate

sabinn
PowerApps Staff sarafankit
PowerApps Staff

Re: Power BI Integration - Data not showing

To continue to see the data in the app in subsequent session while in PowerApps studio, please go back into your Power BI report, select the PowerApps app on your report and then select Edit app from the "..." on the top right corner.

 

The data integration object depends on context only available within Power BI and cannot be loaded if the app is directly edited from PowerApps.

johnchill
Level: Powered On

Re: Power BI Integration - Data not showing

Thank you but I don't see an 'Edit App' option. there is an option to 'Edit' which opens the Power BI report for editing, not the PowerApps visual. I am missing something?

Highlighted
PowerApps Staff sarafankit
PowerApps Staff

Re: Power BI Integration - Data not showing

Yes, you need to get in the edit report mode first before you get the edit option on the visual.

 

edit-app.png