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’
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’
Hi everybody, today we speak about some interesting new features on power bi desktop. This upgrade is very interesting. IN particular this month:
Last week, Guy in a Cube shows how to configure Active Directory Federated Services (ADFS) and the Web Application Proxy (WAP) role in Windows 2016, so that you can connect from Power BI mobile to SQL Server Reporting Services using OAuth. See the video, it’s very interesting.
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
Here we are with the news about Power Bi Mobile:
Quick Calc and Format of column are two much requested features. In this article I’ll explain how to use this two Features in Power bi. Continua a leggere
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:
If you have all the 4 requirements, we can start from Power BI service site where you have published your Report.
Now we can pass to our Sharepoint website and follow these steps:
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:
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.
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. |