Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago

Error refreshing Composite model live connection to Power BI dataset

I have a composite model that combines a direct query to a Power BI dataset in the service with imported data from Excel/dataflow. When I try to refresh in the service to re-import the non-live data ...
Need Help
belvoir99's avatar
belvoir99
Icon for Resolver III rankResolver III
4 years ago

Anonymous I have had the same issue (see other post in this thread). I think I have now found the 'answer'. See this page of documentation on Composite Models:

https://docs.microsoft.com/en-us/power-bi/transform-model/desktop-composite-models

 

Scroll down to 'Limitations and considerations'. There it states that you can't use Power BI datasets with composite models.

That is what I was trying to do. Perhaps you were also?


  • belvoir99's avatar
    belvoir99
    Icon for Resolver III rankResolver III
    4 years ago

    Possibly to answer other people's questions on this thread, I will be undertaking the following:

    1. Connect direct to the dataflows that deliver content to the shared datasets.
    2. Remove any relevant code out of the shared datasets and up into the dataflows.
    3. Test like crazy to ensure my numbers are still correct.

    I have a long tedious build ahead! ğŸ˜’