Forum Discussion

ioniPeis's avatar
ioniPeis
Regular Visitor
5 years ago
Solved

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 t...
Need Help
  • ioniPeis's avatar
    ioniPeis
    5 years ago

    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.

ioniPeis's avatar
ioniPeis
Regular Visitor
5 years ago

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.

Anonymous's avatar
Anonymous
Not applicable
5 years ago

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