Forum Discussion
Datamart compatability with PA
Not sure what you mean. Please elaborate.
Can you trigger a refresh of datamart's default dataset upon a src file modification in share point? If you can, I will be very interested; cause I failed to achieve that.
- lbendlin3 years agoSuper User
datamart's default datasetNot sure if that is even a thing. A datamart is a dataflow with an Azure SQL db bolted on in front to make you think you could access dataflows in Direct Query mode.
- smpa013 years agoCommunity Champion
Okay, then can you trigger the refresh of a datamart upon a SP file modification ? Btw it is a thing, in case u have not discovered it yet. Datamart is double edged- the tables are both accessible through SQL as well SSAS (hence default dataset).
- lbendlin3 years agoSuper User
The default Power BI dataset created from a datamart eliminates the need to connect to a separate dataset, set up refresh schedules, and manage multiple data elements. Instead, you can build your business logic in a datamart and its data will be immediately available in Power BI,