Hello, Can we use the output of a visual or SQL query of a datamart in a visual of PowerBI report ? I do not see the visual / SQL queries that I have written in the datamart are visible in PowerBI desktop once I connect/import in to PBIX in PowerBI desktop. If the visual or SQL query output can't be used in a powerBI report, what could be use of the same ? Please suggest. Also I am looking for data refresh from the source for every 2-5 minutes ( import mode). But in the premium capacity , we don't see any better frequency than 30 minutes. Thanks!
Thanks for the useful tips. however, sometimes, snowflake schema is more appropriate than star schema. and I think that Power BI handles it very well. Cheers.
Great timing. Just had something go off the rails, need a good baseline to work to.
Glad I could help
Thank you, very helpful and concise.
Hello, Can we use the output of a visual or SQL query of a datamart in a visual of PowerBI report ?
I do not see the visual / SQL queries that I have written in the datamart are visible in PowerBI desktop once I connect/import in to PBIX in PowerBI desktop.
If the visual or SQL query output can't be used in a powerBI report, what could be use of the same ?
Please suggest.
Also I am looking for data refresh from the source for every 2-5 minutes ( import mode).
But in the premium capacity , we don't see any better frequency than 30 minutes.
Thanks!
Thanks for the useful tips.
however, sometimes, snowflake schema is more appropriate than star schema. and I think that Power BI handles it very well.
Cheers.
very interesting, thank you!
Million thanks
thank you
Thanks alot