none
Project Online and Power BI RRS feed

  • Question

  • Hi,

    Did anybody connect Project Online OData to the new Power BI, enabling a scheduled refresh (without opening offline files)?Regards,

    Barak

    Sunday, August 2, 2015 12:56 PM

Answers

All replies

  • Hi Barak,

    Yes I did. See the blog post I recently wrote about Power BI:

    http://psbehindthescene.blogspot.ca/2015/07/my-first-power-bi-report-whitout-excel.html 


    Hope this helps,


    Guillaume Rouyre, MBA, MVP, P-Seller |

    Sunday, August 2, 2015 9:43 PM
    Moderator
  • Hi Guillaume,

    but if i have an Excel report file created in the Report folder of Project Online, with feature like data model and powerview... how can i refresh it online (data model can't be refreshed online) and giving access to user to the specific excel file?

    Which is the right solution? I need Power BI licenses for all the users accessing the excel report?

    Thanks

    Daniele


    Daniele

    Monday, August 24, 2015 1:22 PM
  • Hi Daniele,

    No you just need a powerBI license for the admin who creates the report with PowerBI.


    Hope this helps,


    Guillaume Rouyre, MBA, MVP, P-Seller |

    Monday, August 24, 2015 1:27 PM
    Moderator
  • Ok thanks,

    but how to create the scenario?

    I'm not able to find the right way, where to place the excel file, how to connect it, and how to give access to users?

    Did you write anything about or see any blog from others?

    Thanks for quick reply

    Regards

    Daniele


    Daniele

    Monday, August 24, 2015 1:29 PM
  • I wrote a blog about it (see the link above) so you can see how to set up autorefresh.

    See those other references:

    • https://support.office.com/en-us/article/Schedule-data-refresh-for-workbooks-in-Power-BI-for-Office-365-7d6d2816-7fb0-4c5f-a353-d5bd13124985?ui=en-US&rs=en-US&ad=US&fromAR=1
    • https://support.powerbi.com/knowledgebase/articles/474669-refresh-data-in-power-bi
    • http://blogs.technet.com/b/hansbaumann/archive/2014/10/17/power-bi-excel-auto-refresh-from-on-premise-sql-server-data-source-in-office-365.aspx
    • http://blogs.msdn.com/b/powerbi/archive/2014/02/12/keeping-your-reports-up-to-date-with-scheduled-data-refresh.aspx

    Hope this helps,


    Guillaume Rouyre, MBA, MVP, P-Seller |

    Monday, August 24, 2015 1:50 PM
    Moderator
  • Sorry Guillaume but this doesn't help,

    I'm trying to refresh an Excel file and not a PowerBI file(as your blog refer too).

    Now there is the new PowerBI portal and i found out that the only way is to save the excel file in your personal OneDrive for Business... but in this way i have to ask to all customer's user to go there to see the reports (non correct way i think).

    I guess there is not yet enough indications about that. Isn't it?

    Thanks

    Regards

    Daniele


    Daniele

    Monday, August 24, 2015 2:35 PM
  • As far as I understand, PBIX files can only be published in the PowerBI portal. But Excel files created with PowerX addons can be published in Office 365 and/or PowerBI portal.

    See this blog:

    http://blogs.msdn.com/b/powerbi/archive/2014/12/11/embed-power-view-interactive-reports-in-your-blogs-and-websites.aspx


    Hope this helps,


    Guillaume Rouyre, MBA, MVP, P-Seller |

    Monday, August 24, 2015 2:55 PM
    Moderator