Forum Discussion

JasonY's avatar
JasonY
Helper I
5 years ago

Download a dataset using SSIS

    Hello, Getting the below error from SSIS while trying to connect to the dataset, from the same machine I can connect o the dataset using the Power BI desktop App, and using DaxStduio.   Also ...
Need Help
Tips and Tricks
Tutorial Requests
Anonymous's avatar
Anonymous
Not applicable
5 years ago

Hi JasonY ,

 

Based on your description, I think your filename entered in “Server or file name” may be not right. What’s more, this feature of connecting to Power Bi dataset in Service is not yet available for Integration service projects.

But I have found a solution to connect to Power BI if your data model is in Desktop. Please refer to the following idea.

https://www.oraylis.de/blog/how-to-use-power-bi-as-data-source-in-ssis

https://www.powerbi-pro.com/power-query-in-ssis/

It is a great workaround even though there are few limitations to that approach.

 

Hope that's what you were looking for.

Best Regards,

Yuna

 

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

  • Anonymous's avatar
    Anonymous
    Not applicable
    4 years ago

    Hi JasonY 
    Could you please let me know if you were able to successfully test this connection?
    Did the Initial Catalog dropdown populated on its own or you entered the database name manually?

    Regards,

    Sunil

    • JasonY's avatar
      JasonY
      Helper I
      4 years ago

      No, never been able to automate it; yes, it gets populated on its own.

      • Anonymous's avatar
        Anonymous
        Not applicable
        4 years ago

        Hi JasonY,
        Thank you for your response.

        Could you please let me know if you took a manual approach and if you can share the steps you followed in that manual approach to download data from Power BI Datasets using SSIS?