Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.

Reply
ioniPeis
Regular Visitor

Export updated data to be used in another bi tool.

Hello,

a client has asked me for access to transformed data (raw data to which different business rules have been applied). This customer wants to use the data in his own BI tool.

It is important that the data is kept updated in each automatic refresh that is programmed in PBI service.

I was thinking that it would be possible to export the data from PBI to an Azure SQL DB with an R script, and then the customer connects their own BI tool with Azure. But I think it could have limitations in terms of updating the data.

Any better idea?
Is there any other functionality that allows me to do this?

 

Captura de pantalla 2021-09-12 120547.png

1 ACCEPTED SOLUTION

Hi @lbendlin 

 

Thanks for your answer.

Your question makes a lot of sense, it happens that the DB is provided by a partner so we only have read access. Regarding your answer, I see it a bit complicated for me, I think that at this point it would be more convenient to create an intermediate DB where we can apply the transformations and then give the client access.

View solution in original post

3 REPLIES 3
lbendlin
Super User
Super User

"It is important that the data is kept updated in each automatic refresh that is programmed in PBI service."

 

This means you need to write polling software that checks for dataset refresh completion (successful completion actually)  and then you can issue an API call against the dataset via DAX.

 

Or - you can do all that much more convenient from the comfort of your SSMS console - including refreshing partitions on your own schedule and then pulling the refreshed data into the Azure db.

 

The real question here is WHY?  Can't you implement the business logic in MySQL and give your client access to the MySQL database?

Hi @lbendlin 

 

Thanks for your answer.

Your question makes a lot of sense, it happens that the DB is provided by a partner so we only have read access. Regarding your answer, I see it a bit complicated for me, I think that at this point it would be more convenient to create an intermediate DB where we can apply the transformations and then give the client access.

HI @ioniPeis,

Did you mind using the live mode to connect to these datasets?
If that is the case, you can create a pbix report and publish it to power bi service, setting the refresh scheduler to bring data from your database.

After these steps, you can ask your customer to create a report that connects to the power bi service dataset as the data source.

For the new report, it will live connected to the power bi service dataset and get the latest data(based on the raw report refresh scheduler) every time you interact what it's report contents.

Regards,

Xiaoxin Sheng

Community Support Team _ Xiaoxin
If this post helps, please consider accept as solution to help other members find it more quickly.

Helpful resources

Announcements
Microsoft Fabric Learn Together

Microsoft Fabric Learn Together

Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City

PBI_APRIL_CAROUSEL1

Power BI Monthly Update - April 2024

Check out the April 2024 Power BI update to learn about new features.

April Fabric Community Update

Fabric Community Update - April 2024

Find out what's new and trending in the Fabric Community.

Top Kudoed Authors