Відео

You are right, but if you go to cost benefit and efforts involved, it is the best solution.

Port forwarding is must to take your server public.

You're welcome!

Thanks a lot for your encouraging feedback.

If you feel its worth putting in your resume, plz go ahead.

You can choose hours/minutes/Seconds from Format>Visual>General.

@@virtual_school why choose just one

Because you cannot display two different standards in any chart. Even in line chart, can you display numbers in thousands and millions at the same time? you have to choose one.

You need power bi service for push dataset, which not everyone has. And there are many other issues as well. Power BI users are mostly basic users, and push data does not have a proper interface. You have to use command line tools and other stuff to make it work. And at the end you get similar results.

Every statistic has their unique code. Like SP.POP.TOTL is for total population. You must find out the code for statistics you want to display, and use that in the query.

@@virtual_school Thank you very much! and where exactly can I find those?

Go to databank.worldbank.org/metadataglossary/gender-statistics/series. In every section there is a "code". Press Ctrl+F and write code. All codes will be highlighted.

Could you elaborate plz. What is taking long and what is "from:12:15" ?

@@virtual_school once the whole project is done when we have to open it again it is not showing the first visual representation It showing error message

This tutorial is based on SQL Server. I read online that npgsql can help you connect to postgre using direct query.

These are all work arounds. To get proper power bi features, you need power bi service from Microsoft, which also gives you the facility to share your reports to general public without user name and password.

I am a robot. We are taking over 😂.

:) What would you prefer? A clear understandable voice or a voice with some strange accent, with coughing, clearning throat, mic issues, "ummm ummm" etc? Which are bonus with human voice :)

There are many ways. You have import and export wizards in SSMS. You can use select * from OPENROWSET command if you prefer query. You can save excel file as text and use Bulk Insert command as well. However you must have advanced SQL or database knowledge, to use any of these methods. Databases are highly strict. In a column where Null is not allowed, any blank cell will result in error. Any space or hidden special character may result in error as well. In some cases application using the database can malfunction as well.

How many rows and columns are we talking about?

You're welcome!

That is not difficult. Declare a variable, say x, outside the loop. Then on each iteration add one to that variable i.e. x = x + 1. And you will get non random values. Is that what you want?

@@virtual_school no I am asking I have the data points but it is in very large number so it is quite impossible to insert one by one so how I can feed my data points(nonrandom data points) by using loop

@@julishaw516 if you have static data, you dont have to use a loop. You can either upload a file directly into your database table, or you can use insert command. You can use multiple insert commands together. i.e. insert into xyz values (1,2,3); insert into xyz values (4,5,6); and so on. And you can create these insert statements using some automatic formula. Like if you have data in excel, you can create a formula to generate, say one thousand of these insert commands, and then you can paste those in your sql querym and all one thousand rows will be entered at once.

Are you using the same visual? Maybe its a different version where this option is not available. Following this thread. github.com/mprozil/PlayAxis/issues/9 I used this version (shared for educational purposes, please their official website) drive.google.com/file/d/1F76unGLcNRW16Fx_WA79ONfGSmDXVZB0/view?usp=sharing

Are you using the same visual? Maybe its a different version where this option is not available. Following this thread. github.com/mprozil/PlayAxis/issues/9 I used this version (shared for educational purposes, please their official website) drive.google.com/file/d/1F76unGLcNRW16Fx_WA79ONfGSmDXVZB0/view?usp=sharing

Should work using local ip address. Command Prompt > ip config

Thanks.

Thank you too. You are most welcome.

Thanks.

Yes you are right. Average is better for analysis. Sum or average will however have no affect when data is presented on daily basis.

In power BI desktop, there is no limit on refresh.

@@virtual_school what are you talking about there is a limit of 8 refreshes and 48 refreshes in the premium version

Power BI "Desktop"?

@@virtual_school what about online service is there a way to avoid refreshes on that?

Power BI service (online) is different. It has limitations.

Thanks 🙏

This is a tutorial on "Realtime SQL Data". You cannot provide a dataset on that. The entire process on how to create this realtime data (database, table and query) is explained in the first portion of video which I think you have missed. The query that "GENRATES" data is explained at @10:30.

USERELATIONSHIP uses only two columns as argument. Check if you have used more than two columns maybe.

Page refresh option only appears when you choose the DirectQeuery method, instead of import. See at 8:47

Thanks.

Dear Sir, It is frankly the easiest way of creating such analysis. All other methods invovle a lot of work (formulas, relationships, tables etc.) Here you just connect same table to its duplicate, and use one table as navigation and the other as output. Just pause video and follow each step as shown in the video. Maybe you are missing something. And if it still does not work, email your power bi file to virtualschoolofintotech@gmail.com and I will take a look at it. Good luck.