User Profile
Mimoune_Djouall
New Member
Joined 1 year ago
User Widgets
Contributions
Datamart should not block managed managed identity access.
we have a use case where we want to Extract Data from Datamart and load it to an Azure SQL DB, the data will be used for an OLTP scenario. as of today, Datamart endpoint block managed identity access , as a matter of fact even Python Access is Blocked, I know it is a preview, but IMHO, it is a very big limitation, Datamart was supposed to make PowerBI Data more open, that's not the case385Views12likes3CommentsDataflow, load to an existing Datamart
Currently when you create a dataflow, it give you the option to either create a new dataflow or a new datamart, which is a great option for a new user as you get a full Online experience from Data Prep, Modelling to Final reports, and a good option to start a new standalone report but for existing users with a bit of experience, we prefer another Workflow, give us an option to load a dataflow to an existing Datamart, we want to use a Datamart as a central Database to store a lot of tables for a specific Business Topic, Currently the only way to do it is to create a separate dataflow and load data from there, the problem is, if you have a Datamart with 100 Tables, and only one table has changed, you need to reload all the 99 tables, that's not a very good usage of PowerBI resources Neither for customers nor Microsoft. When Loading Data from Dataflow to Datamart, we prefer those option in order of Priority. Overwrite Incremental refresh append Upsert using PK etc This is Microsoft opportunity to redefined ETL for mass market, and blur the line between Enterprise ETL and Self service Data preparation.519Views39likes4CommentsDatamart, make the auto generated dataset optional
we have a lot of cases where we prefer to turn off the auto generated dataset When Datamart is used only to share data When the dataset is already built using PowerBI Desktop/Tabular and Datamart is only used to store Data The Risk is users may used the auto generated dataset, even if if it was not intended to be used that way.929Views75likes7CommentsDon't refresh Data from Dataflow if the Data has not changed
let's say you are importing data from dataflows to a PowerBI dataset, can we have an option when we refresh PowerBI dataset that the connector to the dataflow check if the table last modified date has changed or not, if the date has not changed since the last refresh just ignore the refresh. this is particularly useful, when you have big tables or you are using multiple dataflow with different refresh schedule, it will make reloading data only when necessary, it is less usage on PowerBI service and make the refresh substantially faster.79Views4likes1CommentPreserving Data Types With SQL Queries In Power Query And Power BI when Using BigQuery and other Connectors
Currently when running a custom SQL Query using BigQuery, PowerBI send another Query just to check the Data type, it slow the performance and honestly it is not necessary, this behavior was fixed for SQL Server as per Chris Webb blog here https://blog.crossjoin.co.uk/2021/09/12/preserving-data-types-with-sql-queries-in-power-query-and-power-bi/ can we have please the same behavior for BigQuery please.123Views2likes1Commentconcatenatex should respect the Selection Order
in this example, I am using concatenatex to build a line string geometry that is rendered on the fly by the Icon Map, unfortunately concatenatex has no way to keep the selection order, there is an optional parameter to keep order but it is only ascending or descending usually the order is not that important, except in this case, where the line string has to be built exactly as it is selected in the visual104Views1like1CommentMake a DAX measure react to internal filter selection in the same Visual
I have a use case where I want the DAX measure to update when I select some rows in the same Visual, Currently DAX measure capture only external filter selection not internal Selection it is a very common pattern in GIS, I am using M Parameter to return a cluster of some points selection and I want to show the result in the same Map. Live Report here : https://app.powerbi.com/view?r=eyJrIjoiZjA3ZGQ5NjctZGQxNS00NmMxLTgwZDktY2RlMjM1ZDRkNzJjIiwidCI6IjdmNjhjN2QwLTc0ZTgtNGE2Ni04NGI3LWZhMjdlMzYyNTFiOCJ9209Views8likes1CommentSupport Direct Query SQL Result cache
with the introduction of M Parameter, a new class of use cases became Possible in PowerBI, Currently it is possible to send an M Parameter and get back some heavy calculation done by the Source Database for Example GIS calculation, (Clustering, Area size, length etc). ML calculation. but there is a General performance Problem, PowerBI as far as I can see don't cache any SQL Query results, which make the whole experience less than Optimum, let's say the First Query will take 10 second, I expect if the user run again the same Query he will get instantaneous cache result. Another expectation if the user clicks refresh in the report, I expect the result cache to expire. I appreciate the Product team is investing a lot in automatic aggregation, but I am afraid, it does not help when using M Parameter. Here is an example using M Parameter, I can see in my Database Console, a hundred of the same SQL Queries sent again and again by PowerBI, Import does not work as I can not import all the possible combination of results https://app.powerbi.com/view?r=eyJrIjoiZjA3ZGQ5NjctZGQxNS00NmMxLTgwZDktY2RlMjM1ZDRkNzJjIiwidCI6IjdmNjhjN2QwLTc0ZTgtNGE2Ni04NGI3LWZhMjdlMzYyNTFiOCJ9282Views6likes2Comments
Data Privacy
Microsoft Fabric Community and Privacy
To learn more about how we manage your data, please review the Microsoft Fabric Community Data Privacy guide.