Forum Discussion

Amerikaner's avatar
Amerikaner
Icon for Helper I rankHelper I
5 years ago
Solved

Paginated Reporting / Power BI Premium Per User License

The documentation states supported data sources for Power BI Paginated Reports included Power BI Dataset (Premium and Non-Premium) and Premium Power BI Dataset XMLA. Upgrading from Power BI Pro to Premium Per User  (PPU), I tried to create the pagnated reports from the Report Builder. My problem is that there is no data connection option to either a local hard drive or the service to access the dataset. The 11 options begin with Microsoft SQL Server to Teradata. What do I need to do to connect the PowerBI datasets?

 

THX

Need Help
  • AbhiSSRS's avatar
    AbhiSSRS
    5 years ago

    Hello Amerikaner !

     

    This works fine for me, I have worked with my power BI service hosted datsets connected live with a Premium per User workspace. It works the same way it works with Power Bi Desktop ,I only had to enable XMLA Read Write on my Power BI tenant .

     

    I am able to use DataSOurce -->Add Power Bi Datset Connection and it works seemlessly from there.

    And If you want to use your local power BI dataset, then please open up your PBix file that contains the dataset on local and then copy the port name from DAX studio or local folder (you may find that on web how to get that) . Now use this to connect to "SQL Server Analysis Services" connection :

     

    You are good to use your paginated with this datasource creating the datsets on this ! Only issue is that you will need to keep your PBIX running and also if you choose to close it /restart machine then change the datsource to new port/select new DB that appears on new Pbix open.

     

     

     

    Thanks!
    Abhinav Singh

    LinkedIn 

16 Replies

  • Anonymous's avatar
    Anonymous
    Not applicable
    5 years ago

    There is no such limitation for using Power BI dataset from report builder. Can you share screenshots of what you are referring to?

  • AbhiSSRS's avatar
    AbhiSSRS
    Icon for Solution Sage rankSolution Sage
    5 years ago

    Hello Amerikaner !

     

    This works fine for me, I have worked with my power BI service hosted datsets connected live with a Premium per User workspace. It works the same way it works with Power Bi Desktop ,I only had to enable XMLA Read Write on my Power BI tenant .

     

    I am able to use DataSOurce -->Add Power Bi Datset Connection and it works seemlessly from there.

    And If you want to use your local power BI dataset, then please open up your PBix file that contains the dataset on local and then copy the port name from DAX studio or local folder (you may find that on web how to get that) . Now use this to connect to "SQL Server Analysis Services" connection :

     

    You are good to use your paginated with this datasource creating the datsets on this ! Only issue is that you will need to keep your PBIX running and also if you choose to close it /restart machine then change the datsource to new port/select new DB that appears on new Pbix open.

     

     

     

    Thanks!
    Abhinav Singh

    LinkedIn 

    • Amerikaner's avatar
      Amerikaner
      Icon for Helper I rankHelper I
      5 years ago

      Hi Abhinav,

      I really appreciate your assistance in trying to solve this problem! The good news is that I am able to successfully connect to the Power BI Desktop Dataset (see attached). The bad news is that I am unable to connect to the Power BI Service to connect to the Power BI Dataset in my Premium Workspace (see attached).  I have a pending case open on this issue with Microsoft and will update once it gets resolved. It has to be something on my end ... in the interim, you saved me a lot of time so I can proceed. Thanks again!!