cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
ellisjm Frequent Visitor
Frequent Visitor

RDL using Power BI Dataset in Service

Hi All, we're doing a PoC of PBRS.  I've created a quick & dirty RDL using Power BI Report Builder (v15.0.1380.0) that uses a Power BI Dataset in Service.  We have a Premium tenant.  While the RDL runs just fine in Power BI Report Builder, I can't get the darn thing to run once uploading it to PBRS.

Steps to recreate:

  1. Start a blank report in Power BI Report Builder
  2. Right click on Data Sources, choose Add Power BI Dataset Connection:
  3. Select the workspace & dataset
  4. Right click on Datasets and Add Dataset
  5. Select the Data Source and click Query Designer
  6. Grab a couple of dimension attributes & measures in Query Designer, hit OK
  7. Add a tablix to the report and aforementioned dimension attributes & measures.
  8. Save the RDL
  9. Upload to the PBRS
  10. Manage the report & go to Data Sources
  11. Connection Type is PBIDATASET.  It has an error saying "The data extension used here is not available. It has either been uninstalled, or it is not configured correctly."

I've tried changing the type and doing more of an XMLA type connection to the Power BI Dataset in the service but can't get that working either.  Any hints would be greatly appreciated!

 

2 REPLIES 2
jcadle Frequent Visitor
Frequent Visitor

Re: RDL using Power BI Dataset in Service

I am seeing the same thing, the option was not available in version 14 either so I updated to version 15 thinking that may resolve it. No go, and so far this is the only topic I have been able to find on the internet even discussing this.

jcadle Frequent Visitor
Frequent Visitor

Re: RDL using Power BI Dataset in Service

I found a way to accomplish this though not with that extension, I think that extension is fairly new even to the power bi report builder and may come to power bi server in a future release. The upside to the discovery I made is that it works on a regular report server also. Though you can not do it as a shared datasource on the server.

Step 1: make a basic report using Power Bi report builder and the new datasource that lets you connect to a published dataset. Add your datasets and save the file.

Step 2: Go to your power Bi online enviroment to the dataset and choose the analyse in excel option. Once excel opens go to the data tab and choose existing connections. Right click on the connection in the workbook and choose edit. On the Definition tab you will find the OLE DB connection string. Copy this.

Step 3: Open Report builder for RS or PBI RS. Create a OLE DB embedded connection and paste in the connection string from excel then remove the Integrated Security=ClaimsToken entry. You have to check the box to Use single transaction (I think this is why it wont work from a server shared connection, that option is not available). Then go to the credentials tab and either set it to prompt or to use a username password, if setting a user name it will need to be a member of the Power BI workspace where the dataset is published. Test the connection and save.

Step 4: Add a dataset. Choose the embedded dataset you just created as the datasource in the query segment choose the import button. In the file selection window find that origonal basic Power BI Report Builder file you made and select it. A box will pop where you can choose the datasets you had created there. Bring what ever you had created in to the new project and you are ready to build out the rest of your report.

Helpful resources

Announcements
Ask Amanda Anything Q&A

Ask Amanda Anything Q&A

Learn the answers to some of the questions asked during the Amanda Triple A event.

October 2019 Community Highlights

October 2019 Community Highlights

October was a busy month in the community. Read the recap article to learn about some of the events and content.

New Solution Badges

New Solution Badges

Two waves of brand new solution badges are coming! Read the article for more information on our new community badges.

Analytics in Azure virtual event

Analytics in Azure virtual event

Experience a limitless analytics service built to ingest, prep, manage, and serve data for immediate use in Power BI.

Top Kudoed Authors
Users Online
Currently online: 318 members 3,605 guests
Please welcome our newest community members: