Search Microsoft Fabric Ideas

Power BI

Web.Contents () should support scheduled refresh even with dynamic URL

In order for a Power Query data source to be refreshable via scheduled or on-demand refresh inside the Power BI service, the Web.Contents base URL has to be hardcoded. For example, the following is not allowed: (URL) => Web.Contents(URL) Only the following is allowed: Web.Contents("https://bing.com") (You can pass in dynamic headers or query string parameters.) I propose that you enable Power Query inside the Power BI service to retrieve dynamic base URLs. Please add a setting where I can authorize a particular Power Query data source to grab any URL. This scenario already works inside Power BI Desktop or Excel in that Power Query can retrieve dynamic URLs after the user sets the auth for each dynamic base URL. The current workaround is to pass the URL you want to a hardcoded http://YourSiteHere.com/redirect.aspx?url=http://yourdynamicURL.com But that it not a great workaround.

Power BI

Enable Organizational Authentication for Web URL Parameters for Excel Files on SharePoint

Issue Definition:

• I have a power query function that works in Power BI Desktop.
• I want this function in a dataflow on the Service, but the dataflow is not authenticating SharePoint Excel URLs when it is based on a parameter input within my function.
• I've followed the instructions from Refresh and dynamic data sources to keep the URL static, while passing the relative path as a "RelativePath" string. Unfortunately, this does not work for Excel files on SharePoint.
• I still want to specify data privacy using my Organizational Account at the sharepoint.com level.

If-else logic can be used as an authentication workaround in the Service, detailed below. This is sufficient when the number of URLs is low, but not sufficient when when the number of URLs is high. The most ideal solution is just one line, also detailed below.

let Source = (Parameter1 as text) =>

   let

       Source = (if Parameter1 = "First URL String"

                   then Excel.Workbook(Web.Contents("First URL String"), null, true)

           else

           (if Parameter1 = "Second URL String"

                   then Excel.Workbook(Web.Contents("Second URL String"), null, true)

           else

           (if Parameter1 = "Third URL String"

                   then Excel.Workbook(Web.Contents("Third URL String"), null, true)

           else ""))),

       TableFromExcel = Source{[Item="Table1",Kind="Table"]}[Data]

/* 

URLs might look like:

"https://COMPANY.sharepoint.com/sites/SITE_NAME/Shared%20Documents/RELATIVE_PATH"

"https://COMPANY.sharepoint.com/sites/RELATIVE_PATH"

We cannot use this code in the Service, but it works on Desktop and is the most ideal solution:

       Source = Excel.Workbook(Web.Contents(Parameter1), null, true),

       TableFromExcel = Source{[Item="Table1",Kind="Table"]}[Data],

 */

 in TableFromExcel

in Source

Power BI

Bookmarks That Survive Publish

The bookmark feature is really useful, and we were encouraging our web users to save their own bookmarks rather than save copies of a published report. The problem is that when we publish an update from the desktop application, it overwrites all those web saved bookmarks. It would be good if the publish function merged new desktop and existing web bookmarks.

Issues

Publish to Web button is not available for the reports shared in Groups

HI , I have created a report, and shared this report to a group who have edit permissions. But "publish to web" option is available only for me not available for my group members? what needs to be done to get this button available fro group members?

Power BI

Publish to web: control when a refresh must be done

Currently, reports published to web refresh automatically after some minutes. I'd like to control when a refresh must be done. We could have buttons like Refresh Now and an option to schedule a refresh.

Power BI

Enable specific security groups setting for 'Publish to web'

The "Publish to web" setting for portal administrators currently has the options of 'Enabled' or 'Disabled'. It would be beneficial to have this manageable in the same way as content packs so certain security (AAD) groups could be set as publishers.

Power BI

Publish to Web - enable data download feature

Enable me to allow Consumers of the 'Publish to Web' embedded link the ability to download the data. Similar to with report viewing/creating in the service or desktop that we can select download from the '...' more actions of the visual.

Power BI

Publish to web - save / download chart image

The ability for viewers of published to web reports to download either a single visual or the entire page as a .png/.jpeg file. Internet explorer kind of allows this with right-click -> save picture as... but a native option would be better.

Power BI

Azure maps should support for publish to web

Hello Team, it would be helpful to the users if azure map supports for publish to web option i.e when integrated Power BI report which contains Azure maps.

Power BI

Enable Publish to Web for Azure Private Link.

Currently, Publish to Web isn't supported when the tenant setting Azure Private Link is enabled in Fabric. Kindly enable this feature so that users will be able to protect the data.