Sql server list table

funichi88 Power BI

Its very simple to find all the table or view in a sql db. On management studio select your db and open a new query.

Then past this query

Select * from information_schema.tables

If you want to see only table add

Where table_type =’base table’

Annunci

Power BI desktop march Resume

funichi88 Power BI

Hi everybody, today we speak about some interesting new features on power bi desktop. This upgrade is very interesting. IN particular this month:

Report view

  • Report theming preview: When you import a theme, all your charts will automatically update to use the theme colors, and you’ll have access to the theme colors from the color palette.You can upload a theme file using the Import Theme option under the Switch Theme button.clip_image004A theme file is a JSON file that includes all the colors you want us to use in your report. Se my Next article where i explain how to use it.
  • New matrix visual preview: new version of the matrix as a separate visual Once you turn on the preview by selecting New matrix visual under File > Options and settings > Options > Preview features, you will see the new matrix in the visualization pane. Benefits of this new matrix include:
    • Performance improvements
    • Drilling into hierarches
    • Stepped layout
    • Cross highlighting and filtering from matrix headers and cell contents
  • Textbox font color: added the ability to change font color of your text in textboxes
  • Numeric range slicer preview: adding a preview of a new type of slicer, the numeric range slicer. You can use this slicer type with any numeric column in your data model. You can choose to filter your data between two values, less than or equal to a value, or greater than or equal to a value
  • Percent of total on pie and donut chart data labels: added percent of total as another data label option for pie and donut charts
  • Cross-highlight using multiple series: you can now multi-select multiple series in a chart when cross-highlighting.

Analytics

  • Clustering is now generally available

Data connectivity

  • New Connector: Azure Analysis Services : adding a new connector to allow you to import data or connect live to your Analysis Services instances running on Azure.
  • Azure Data Lake Store connector is now generally available
  • DB2 connector: option to specify package collection . The DB2 connector dialog now exposes a new option to specify the package collection to connect to, within a given DB2 server.
  • Combine binaries: ability to specify sample file to use. exposing a new control in the file preview dialog to select one of the files available in the selected folder. Default selection is the first file found, but this can now be easily customized by you.

Query editing

  • Split column by delimiter: automatic detection of delimiter character

Ataira Analytics BI – Collaboration for SharePoint Power BI Groups Support

funichi88 Power BI

During my browsing online about Power Bi i found an interesting solution to Sharepoint power bi. His Name is Ataira Analytics +BI  and with their solution can view your Power BI items within a convenient SharePoint web part. You can also send notifications to your corporate groups and add follow-up actions for your team to more tightly collaborate on your business intelligence efforts in one location. Continua a leggere →

Power BI Mobile February 2017 Update

funichi88 Power BI

Here we are with the news about Power Bi Mobile:

  • Power BI app for Android tablets is now available globally
  • New dashboard tile actions (All): To access this menu, just tap and hold on a tile in a dashboard, or tap the ellipsis (…). The menu allows you to navigate directly to the underlying report, expand the tile, or even manage an alert for the tile if the type supports it.

TileActions

  • SSRS – multi server support (iOS): you can connect to up to five different SQL Server Reporting Services servers at the same time. All the servers you connect to will be available under the settings screen.
  • Scrolling Improvements: added the ability to scroll in any Cartesian chart (Bar, Colum etc.) by touching the chart itself, rather than touching the scroll bar. This new interaction is available in any visual in a report, report focus mode, phone report, or Q&A tile.

How to: Integrate Power BI reports in SharePoint Online

funichi88 Power BI

In these days Microsoft has announced the introduction of a new web part that enables SharePoint authors to embed Power BI reports directly in SharePoint Online pages with no code required.

This is a easy e short guide to how to integrate power bi report on sharepoint online. We start from requirements:

  • This solution works only with Sharepoint Online
  • The web part requires new SharePoint features to be enabled. Your tenant needs to be enrolled in the Set up the Standard or First Release options in Office 365 program to use this feature.
  • The Power BI (Preview) web part for SharePoint Online requires Modern Pages.
  • The creator and the user of power bi report must have Power BI Pro license

If you have all the 4 requirements, we can start from Power BI service site where you have published your Report.

  1. Open your Report online and
  2. select File menu item
  3. Select Embed in SHarePoint Online
  4. Copy The url From Dialog Box

Now we can pass to our Sharepoint website and follow these steps:

  • Open the desired page or created a new one in SharePoint Online and select Edit.

    • Select + and select the Power BI (Preview) web part and Select Add report.

  • Past the report URL into the property pane. This is the URL you copied from the steps above. The report will load automatically.

  • Select Publish to make the change visible to your SharePoint Online users.

Important:

Embedding a report in SharePoint Online does not automatically give users permission to view the report. The permissions to view the report are set within the Power BI service. There are two ways to provide access to the report within the Power BI service:

  • If you are using an Office 365 Group you list the user as a member of the group workspace within the Power BI service. This will make sure that users can view the contents of that group.
  • Alternatively, you can grant users access to your report by Adding a tile from the report to a dashboard. Share the dashboard with the users that need access to the report.

Power BI Embedded in sharepoint support data security through Power BI’s Row Level Security features. Users viewing the report embedded in a SharePoint Online page will see the same data they would via PowerBI.com. This makes building secure internal portals to disseminate critical business insights easy and trustworthy.

Web part parameters

Property Description
Page name Sets the default page that is shown by the web part. Select a value from the drop down. If no pages are displayed, either your report has one page, or the URL you pasted contains a page name. Remove the report section from the URL to select a specific page.
Display Option to adjust how the report is fit within the SharePoint Online page.
Show Navigation Pane Shows or hides the page navigation pane.
Show Filter Pane Shows or hides the filter pane.