James

My feedback

  1. 56 votes
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)

    We’ll send you updates on this idea

    3 comments  ·  Power BI Ideas » Data Sources  ·  Flag idea as inappropriate…  ·  Admin →
    James commented  · 

    Snowflake security administrators can assign only one default role to a user account. Per vendor recommendations, members of built-in roles (e.g. SECURITYADMIN, SYSADMIN, and ACCOUNTADMIN) are encouraged to assign a low-privilege default role. Those users must elevate their security token to perform DBA like tasks and will generally have insufficient permissions to read from user-defined content hosted in the Snowflake account. With interactive sessions and other BI tools, those user accounts can issue statements like "USE ROLE mydatabase_db_reader" to change security contexts for BI client purposes. The inability to alter the default role limits some users from being able to access all of the database tables and views that would otherwise be available using other BI tools that support the USE ROLE semantics.

    James supported this idea  · 
  2. 68 votes
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)

    We’ll send you updates on this idea

    5 comments  ·  Power BI Ideas » Dataflows  ·  Flag idea as inappropriate…  ·  Admin →
    James supported this idea  · 
  3. 382 votes
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)

    We’ll send you updates on this idea

    10 comments  ·  Power BI Ideas » Desktop  ·  Flag idea as inappropriate…  ·  Admin →
    James supported this idea  · 
  4. 40 votes
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)

    We’ll send you updates on this idea

    7 comments  ·  Power BI Ideas » Data Sources  ·  Flag idea as inappropriate…  ·  Admin →
    James supported this idea  · 
  5. 22 votes
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)

    We’ll send you updates on this idea

    0 comments  ·  Power BI Ideas » Data Sources  ·  Flag idea as inappropriate…  ·  Admin →
    James supported this idea  · 
  6. 1 vote
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)

    We’ll send you updates on this idea

    0 comments  ·  Power BI Ideas » Desktop  ·  Flag idea as inappropriate…  ·  Admin →
    James shared this idea  · 
  7. 14 votes
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)

    We’ll send you updates on this idea

    1 comment  ·  Power BI Ideas » Analytics  ·  Flag idea as inappropriate…  ·  Admin →
    James supported this idea  · 
  8. 146 votes
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)

    We’ll send you updates on this idea

    8 comments  ·  Power BI Ideas » Data Sources  ·  Flag idea as inappropriate…  ·  Admin →
    James supported this idea  · 
  9. 53 votes
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)

    We’ll send you updates on this idea

    4 comments  ·  Power BI Ideas » Reports  ·  Flag idea as inappropriate…  ·  Admin →
    James commented  · 

    Jonathan, it might help to clarify if you are looking for support for concurrent/simultaneous edits of the same report in the PowerBI service. Multiple users of the same workspace can progressively edit a report (one at a time), but they cannot edit the same file concurrently. It sounds like you might be advocating for a concurrent authoring experience that mimics using Office 365 documents on SharePoint Online.

  10. 3,218 votes
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)

    We’ll send you updates on this idea

    226 comments  ·  Power BI Ideas » Desktop  ·  Flag idea as inappropriate…  ·  Admin →
    James supported this idea  · 
  11. 1,878 votes
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)

    We’ll send you updates on this idea

    30 comments  ·  Power BI Ideas » Desktop  ·  Flag idea as inappropriate…  ·  Admin →
    James supported this idea  · 
  12. 45 votes
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)

    We’ll send you updates on this idea

    2 comments  ·  Power BI Ideas » Custom Connectors  ·  Flag idea as inappropriate…  ·  Admin →
    James supported this idea  · 
    James commented  · 

    It would be helpful to know if this is technically feasible, particularly when it comes to Snowflake on Azure. There are probably logistical challenges for Snowflake's own VNET/public network endpoints as well as potential challenges around which Azure region hosts the tenant's PowerBI instance vs. Snowflake's Azure region.

  13. 59 votes
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)

    We’ll send you updates on this idea

    7 comments  ·  Power BI Ideas » Data Sources  ·  Flag idea as inappropriate…  ·  Admin →
    James commented  · 

    Please add an "Organizational Account" authentication option to the Snowflake connector. It would be very helpful to have the ability to use Azure Active Directory accounts against the Snowflake databases.

    James supported this idea  · 
  14. 1,871 votes
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)

    We’ll send you updates on this idea

    178 comments  ·  Power BI Ideas » Other  ·  Flag idea as inappropriate…  ·  Admin →
    James supported this idea  · 
  15. 123 votes
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)

    We’ll send you updates on this idea

    planned  ·  14 comments  ·  Power BI Ideas » Data Sources  ·  Flag idea as inappropriate…  ·  Admin →
    James commented  · 

    There are times when a standard Excel pivot table makes a bit more sense than the PowerBI table and matrix. With PowerBI hosting 'apps' in SharePoint Online, there is a natural fit for colocating "Analyze in Excel" workbooks for data consumption. The ability to alter the slicer/filter elements of an Excel PivotTable could provide a lower barrier to entry for people to consume PowerBI content if it could be actively filtered in Excel Online.

    James supported this idea  · 
  16. 29 votes
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)

    We’ll send you updates on this idea

    4 comments  ·  Power BI Ideas » Data Preparation  ·  Flag idea as inappropriate…  ·  Admin →
    James commented  · 

    It would be helpful to have a syntax like Text.ComputeHash(Algorithm,InputText) that is similar to the SQL HASHBYTES (e.g. with support for MD5, SHA1, etc.). There are a lot of sources outside of SQL Server that do not have native hashing functions and Power Query does not expose extensions to functions that would be available in .NET Framework cryptography libraries.

    When queries eventually make their way into a DAX-based model, there are situations where it would be helpful to have a single, surrogate key that replaces a composite key. A MD5 hash key could replace a much longer text concatenation. In the absence of such a key, it can be complex to lookup a surrogate value (with a hit to performance). Having a 32 character, deterministic key in a fact load that can be computed independently of a corresponding dimension load would make it possible to avoid a lookup/merge in many situations.

    Arguably this could be done by formal data warehousing ETL, one of the value propositions of Power Query and PowerBI is the ability of mashup data that might not exist already in formal repository. I have seen a lot of Excel VLOOKUP style solutions that could have been replaced with this kind of hash over multiple columns. As such, this makes a lot of sense as a feature that is added to Power Query for use in both Excel and PowerBI.

    In my application, a 32 character ASCII hex encoding of the MD5 binary output makes the most sense as a default output format. It tends to be a more universally supported data warehousing option.

    James supported this idea  · 
  17. 604 votes
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)

    We’ll send you updates on this idea

    132 comments  ·  Power BI Ideas » Data Sources  ·  Flag idea as inappropriate…  ·  Admin →
    James supported this idea  · 
  18. 3,915 votes
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)

    We’ll send you updates on this idea

    423 comments  ·  Power BI Ideas » Data Sources  ·  Flag idea as inappropriate…  ·  Admin →

    We’re pleased to announce that in the May release of Power BI Desktop you can now define incremental refresh policies for your models.

    At present these only apply once the model is published to a Premium workspace in the Power BI service; we’ll be bringing it to all Pro users in the future.

    You can read more about it in our blog here: https://powerbi.microsoft.com/en-us/blog/power-bi-desktop-may-2018-feature-summary/#incrementalRefresh

    We’re going to leave this idea open for now, so please give us your feedback while we’re in this preview phase!

    James supported this idea  · 
  19. 331 votes
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)

    We’ll send you updates on this idea

    39 comments  ·  Power BI Ideas » Data Sources  ·  Flag idea as inappropriate…  ·  Admin →
    James supported this idea  · 
  20. 17 votes
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)

    We’ll send you updates on this idea

    4 comments  ·  Power BI Ideas » Desktop  ·  Flag idea as inappropriate…  ·  Admin →
    James commented  · 
    James supported this idea  · 
← Previous 1

Feedback and Knowledge Base

Ready to get started?

Try new features of Power BI today by signing up and learn more about our powerful suite of apps.