1.

What are Variables in DAX and why we use them in Power BI?

Answer»

STREAMING dataset is also called as Real Time Datasets and can create real time Dashboard, which updates just SIMILAR Live Cricket score or Live Football Score or Live Temperature etc.

  • Open app.powerbi.com.
  • upper right corner Click on + Icon.
  • Select Steaming Dataset.
  • Flyout will appear with 3 options API, Azure Stream Analytics & PUBNUB.
  • Select API and hit next.
  • Next flyout, Provide dataset NAME then Column names and respective data types.
  • Enable Historic data analysis (which will help holding old data in dataset to perform analysis) then hit Create.
  • Streaming dataset will be created, and it will show api url and also Codes – Raw, cURL & Powershell.
  • Select PowerShell, copy code.
  • Open PowerShell ISE.
  • Paste the code and modify default values and press F5.
  • It will immediately insert the data into Streaming dataset.

Go to dataset:

  • check for the dataset which is created.
  • click create REPORTS to insert visuals and PIN those visuals to Dashboard

(OR)

Go to dashboards:

  • Upper middle click + Add tile.
  • In flyout select source tile as REAL-TIME DATA then next.
  • Your existing Steaming dataset will appear, if it’s not readily available then create new dataset.


Discussion

No Comment Found