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

Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started

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
Europe Fabric Conference

Europe’s largest Microsoft Fabric Community Conference

Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.

Power BI Carousel June 2024

Power BI Monthly Update - June 2024

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

RTI Forums Carousel3

New forum boards available in Real-Time Intelligence.

Ask questions in Eventhouse and KQL, Eventstream, and Reflex.

Top Solution Authors